MySQL haproxy (read only)?

Question

MySQL

Greetings

There is a MySQL 8 master replication master. I would like to deploy haproxy with the parameters:
write: host1
read: host1, host2 (round robin)
and only if host1 is unavailable, transfer write to host2 but I can’t even find it

for the read only manual
generally implement such a scheme without using cluster software?

Answer 1

mysql proxy