On Fri, Feb 15, 2002 at 10:32:06AM +0000, Simon Windsor wrote: > > Currently, I maintain two mysql server, hosted by separate ISPs, and > keep them synchronised using standard MySQL replication.
Great! > Server A is master+slave to server B, and likewise server B is master > +slave to server A. > > This allows both servers to receive inserts/updates/deletes and > replicate them accordingly. This has, and continues to work well. > > The problem I have is simple, it has been decided to have a third web > site, with an associated database. Okay... > The replication model I have implemented only works with TWO servers. Or so you think. :-) > The only solution to this is to add to one servers my.cnf the option > LOG-SLAVE-UPDATES and enable read-only replication to this new > server. Right. That's one way to do it. > If I do add this option, and one server logs all its 'native' > transactions + 'replicated' transactions, will this confuse the > second server? Nope. > Will the second server try and apply the remote native transaactions > only, or will I get into a loop of a machine applying its own > transactions back on to itself ? It's not a problem because each server has a unique id. The server id of the server which "originated" each query is stored in the binary log. This helps to prevent "looping" problems and servers getting confused. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 10 days, processed 328,170,509 queries (377/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
