MySQL Forums :: Performance :: Masters in HA and slaves in LB

Advanced Search

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

Subject Views Written By Posted
Masters in HA and slaves in LB 2301 Britto I 05/17/2010 06:09AM
Re: Masters in HA and slaves in LB 918 Rick James 05/18/2010 08:39AM

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.