[ILUG] Dual Master MySQL replication ?

[Stephen Brooks]

Paul Reilly wrote:
> Has anyone any experience setting up Dual Master replication
> between 2 MySQL servers? What I want is described in slide 24
> "Dual Master Replication" at
> 
> http://jeremy.zawodny.com/mysql/managing-mysql-replication.html
> 
> 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?
> 
> In my scenario, only one server will get updates, but if it's down, then
> the second server will get the updates, and would need to update the first
> master with any changes when it came back up. And vice-versa!
> 
> Ideas?
> 
Haven't done this myself but I did look into it a few months ago and 
found a link which I squirreled away.
http://www.phpbuilder.com/columns/tanoviceanu20000912.php3?page=1 has a 
brief tutorial on creating a master->slave slave->master relationship 
between 2 machines, also has some handy php example code.  If one should 
fail and and come back at a later time they sync accordingly.

-- 
Stephen Brooks <stephen at lincor.com>                     17 Dame Court
Software Engineer                                   Dublin 2, Ireland
Lincor Solutions Ltd.                          Ph: +353 (0) 1 6746413