Re: Master-master replication configuration...how?
Hi Craig and others, On Fri, Mar 27, 2009 at 4:16 PM, Craig Dunn li...@codenation.net wrote: 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 I am new to replication so please bear with me. What is the difference between 'multi-master'/'dual-master' and 'bi-directional replication'? I was under the impression they meant the same thing... Thanks.
Master-master replication configuration...how?
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? 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? TIA -- V
Re: Master-master replication configuration...how?
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
