1.There are two masters configured for High Availability. Only writes will happen to these servers and only one server will be available for writes.
2.The slaves will get replicated through any one of the master and they are load balanced for select queries.
3.The live mysql master will replicate the databases to three servers [ One master, two slaves].

The problem which we see is the difference mysql positions when one of the mysql server failed and there will be the change in the position of the binary logs.

How do we overcomethis ?

Basically I would like to splittup the read and write queries to different servers with redundancy.

We cannot have the choice as mysql cluster because of its limitations.

Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.