Hello, I have set up a master/slave replication environment using 4.0.13 but would like to know if there is a way to set up master/master replication between two databases, both able to be inserted/updated/deleted, tables created, etc., with the changes on both databases propagated to each other. I see one comment in the documentation on two way replication:
Q: What issues should I be aware of when setting up two-way replication? A: MySQL replication currently does not support any locking protocol between master and slave to guarantee the atomicity of a distributed (cross-server) update. In other words, it is possible for client A to make an update to co-master 1, and in the meantime, before it propagates to co-master 2, client B could make an update to co-master 2 that will make the update of client A work differently than it did on co-master 1. Thus when the update of client A will make it to co-master 2, it will produce tables that will be different from what you have on co-master 1, even after all the updates from co-master 2 have also propagated. So you should not co-chain two servers in a two-way replication relationship, unless you are sure that you updates can safely happen in any order, or unless you take care of mis-ordered updates somehow in the client code. You must also realise that two-way replication actually does not improve performance very much, if at all, as far as updates are concerned. Both servers need to do the same amount of updates each, as you would have one server do. The only difference is that there will be a little less lock contention, because the updates originating on another server will be serialised in one slave thread. This benefit, though, might be offset by network delays. ------ But there is no further info on how to set it up. Is bidrectional set up by using the log-slave-updates parameter on the slave and point it to the 'master'? It's just kind of vague :-( Thanks in advance, Emi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
