blue.trapez...@gmail.com wrote:
Hi
I have 2 servers and I am trying to set up (for testing purposes) a
master-master replication environment. I read the instructions in the manual
for master-slave, but am not able to find any information on how to set up a
master-master system. Can someone on this list point me to any documentation
on this topic?
What you are probably trying to achieve is bi-directional replication
(arguably different from multi master but as close as you can get) -
take a look at auto_increment_increment and auto_increment_offset, the
idea is that all your primary keys use auto_increment integers and one
master will be offset from the other (ie: server A uses 1,3,5,7,9...etc
and server B uses 2,4,6,8...etc) so they never clash
Also, I am new to replication. Could someone briefly tell me typical
problems with this kind of setup, or why it is/is not advisable?
What's your primary reason for wanting multi master?
It's worth noting that this approach shouldnt be used if your primary
concern is master load... since using traditional statement based
replication, each master is going to process all write queries.
We're currently implementing a passive/active multi master set up using
MMM (http://code.google.com/p/mysql-master-master/) to handle failover,
it's a lot safer.
Craig
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
