I think you also want what ever the standby master gets a write /*assuming that the primary master where to go down or some other reason*/ the submaster needs to replicate that insert so
In /etc/my.cnf Use log-bin server-id=<different int then the master> log-slave-updates replicate-* = <replicate from master | replicate from submaster on master> -->-----Original Message----- -->From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] -->Sent: Tuesday, August 19, 2003 10:38 PM -->To: Sanya Shaik -->Cc: [EMAIL PROTECTED] -->Subject: Re: Mast-Master Replication --> -->On Tue, Aug 19, 2003 at 01:52:26PM -0700, Sanya Shaik wrote: -->> I am unable to find any information about master-master replication. I -->> need to replicate 1 mysql server over to other as a standby master -->> server. --> -->If the second server is merely standby, you probably want master/slave -->rather than master/master. -->-- -->Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! --><[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ --> -->MySQL 4.0.13: up 18 days, processed 911,623,980 queries (570/sec. avg) --> -->-- -->MySQL General Mailing List -->For list archives: http://lists.mysql.com/mysql -->To unsubscribe: -->http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]