It seems that having a master-master replication is very problematic for the first few hours of using it. If I want to switch from master-master to master-slave replication, can I simply remove the following line in my.cnf to go back to master-slave replication: Code: [...] [mysqld] [...] replicate-same-server-id = 0 auto-increment-increment = 2 auto-increment-offset = 2 relay-log = slave-relay.log relay-log-index = slave-relay-log.inde The code above is from the ISPConfig manual. And in slave server, how do I lock MySQL server to be read-only? So that only the master server can have write access. And also, if I want the slave server to accept site's visitors, so that the traffic will be distributed on master and slave server, how do I know that I am connected in the master server if I want to add post say on WordPress?
Never mind about this. I used slave_skip_errors to fix the problem. It seems the the conflict are not that important data.