MySQL Forums
Forum List  »  Performance

Masters in HA and slaves in LB
Posted by: Britto I
Date: May 17, 2010 06:09AM


Consider this scenario,

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.

Thanks & regards,


Options: ReplyQuote

Written By
Masters in HA and slaves in LB
May 17, 2010 06:09AM

Sorry, you can't reply to this topic. It has been closed.

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.