[ILUG] Dual Master MySQL replication ?

[bobb]

On Fri,  9 Jan 2004 in lists.ilug you wrote:
  
>  Has anyone any experience setting up Dual Master replication
>  between 2 MySQL servers?

Have used Master->Slave a number of times with 3.23.x
Works, although can be a little flakey at times, also, not what you want :)

>  However the official MySQL docs suggest dual master is a no-go.
>  I have slave/master working OK. Is it just a matter of doing the
>  same thing again with the roles reversed, so both servers are master
>  and slave at the same time?

The "Replication Intro" says ``A slave can also serve as a master if you set
up chained replication servers.'' 

I tested Master->Master with 4.x a year or two ago, I Think using
the chained replication stuff and it seemed to work in that
Updates to either were replicated to the other.

Think its just the "--log-slave-updates" on the slave thats needed
(hazy memory).

The only thing is that its possible that different updates to the same
table on different servers may cause problems with inconsistancies.
As mysql doesn't do replication locking you have to code your way around
such at thing happening yourself...

But for the situation where you just want failover, Master->Master
should be ok...

(I think... :)

- bobb

-- 
Mr. Rogers could explain shoe-tying and make it seem like the coolest 
thing in the world. He was our Uncle and older brother. He told us we 
were special, and we knew he'd be there for us.
A cult leader, right down to the sneakers.