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.