Multi master replication question
I'm about to re-create a mulit master replication setup that was dismantled during server hardware/software upgrades. Replication setup: A - B - A | C One thing I can't remember is do I have to set an option somewhere to tell the masters to ignore the queries in the binlog that oringated from them? I know I have to have log-bin and log-slave-updates set on each but is there something else or will Server A automatically know to ignore an update query that originated on it, then replicated to server B which wrote it into it's binlog due to log-slave-updates setting (there are downstream servers doing one way replication off of server B) and then replicated back to A? Just having a brain fart here... Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Multi master replication question
Replication setup: A - B - A | C One thing I can't remember is do I have to set an option somewhere to tell the masters to ignore the queries in the binlog that oringated from them? Make sure you set different Server IDs on each machine and you should be just fine. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Multi master replication question
-Original Message- From: Dominik Klein [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 18, 2006 11:06 To: mysql@lists.mysql.com Subject: Re: Multi master replication question Replication setup: A - B - A | C One thing I can't remember is do I have to set an option somewhere to tell the masters to ignore the queries in the binlog that oringated from them? Make sure you set different Server IDs on each machine and you should be just fine. -- Excellent. Many thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]