MySQL Forums
Forum List  »  Router & Proxy

Re: Master-Master full Redundant/Balanced setup
Posted by: Craig David
Date: October 01, 2009 11:07AM

Hi Romain,

To get the behaviour you are after I think you would need to have a setup like this:

[master1]
|
|
[proxy]
|
|
[master2]

The proxy sends all queries to both masters (including INSERTs/DELETEs) so that the data is the same on both - this gives us replication. When the proxy is receiving SELECTs only the queries could be load balanced between the two identical masters.

You do not want MySQL to handle replication through the standards binlog method, rather we roll our own replication/load balanced system using mysql proxy.

Initiate mysql proxy with the switches --proxy-backend-addresses=master1-IP-address and --proxy-backend-addresses=master2-IP-address. You will also need a lua script which will ignore the return from one of the masters and potentially handle load balancing.

I'm also trying to build a setup like this. So let's get a discussion going.

chamone!

Options: ReplyQuote


Subject
Views
Written By
Posted
4612
September 24, 2009 03:45AM
Re: Master-Master full Redundant/Balanced setup
2749
October 01, 2009 11:07AM


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.