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!
>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
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!