Implementing Multimaster Replication
Today I tried to implement multimaster replication on two Red Hat Enterprise Linux 5 servers. I studied the top three google result for 'multimaster replication mysql' today : http://onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html http://capttofu.livejournal.com/1752.html I found these three resources complementary. At first I have no idea about the replication process. Initially followed instructions from Dev.MySQL site to setup one-way replication, then read the livejournal blog for better one-page summary of the process. Reading the ONLAMP Article, I understood the syntax to stop replication and ordered MySQL to skip one SQL statement when resuming replication. I'm using replication with existing data in the database, so the steps I use is a little different from the three web resource above. And because I'm using out-of-the box RHEL setup, there is an issue with the firewall blockin