MySQL master/master how-to
New location: the How-to is now live at http://www.simplicidade.org/how-to/mysql-master-master/.
In the past, I needed to use a MySQL master/master setup for a client. At the time, I got it to work, but forgot to take notes about the process.
In the last days, a friend asked my for help to do a setup like that again, to use with a Tigase XMPP server.
So I wrote this how-to, complete with configuration files, sample data and schemas, that walks you step-by-step through the process of setting up a pair MySQL servers in a master/master configuration.
You can fetch the entire how-to with git:
git clone git://github.com/melo/mysql-master-master-how-to.git
The how-to is written in MultiMarkDown, but a simple Markdown should also format it correctly.
A tarball with everything is also available.
Please let me know if you find any mistakes. Pull requests are the preferred form of collaboration :).
Update: included some tweaks from dbr, and added a HTML version with proper CSS. Download again, and look at how-to.html.
