Re: Master-Master full Redundant/Balanced setup
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!
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.