Hi Currently, I maintain two mysql server, hosted by separate ISPs, and keep them synchronised using standard MySQL replication.
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. The replication model I have implemented only works with TWO servers. 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. If I do add this option, and one server logs all its 'native' transactions + 'replicated' transactions, will this confuse the second server ? 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 ? Thanx Simon -- Name Simon Windsor Tel 0(44) 454 617 689 Email [EMAIL PROTECTED] Fax 0(44) 454 610 709 --------------------------------------------------------------------- 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
