I have read 4.10.7 and the only caveat stated is that updates can occur in different orders on the different servers. Each of my updates are autonomous and that should not be a problem. Are there any other gotchas I should be concerned about. I saw a posting the stated not to turn on log-slave-updates and that auto increment fields can cause problems.
On Fri 2002-12-06 at 15:35:53 -0600, [EMAIL PROTECTED] wrote: > > I am new to this list and have not been able to find an answer in the > searchable archive, So I am sorry if this question has been asked > before. > > The documentation (section 4.10.7) mentions 2 way replication but does > not give any information about how to set it up. Well, that is probably, because it has its problems and is not recommended by default (as section 4.10.7 explained). > I have searched the documentation and the site. Any pointers for more > information would be great. Their is nothing special about it. Simply set up both sides as master and slaves: Set up A and B as master-slave pair according to the documentation. Then set up a B as a master, additionally (assuring that the server-id is different from A) and then start A as slave. Done. The issue about server-id is explained in http://www.mysql.com/doc/en/Replication_Options.html HTH, Benjamin. -- [EMAIL PROTECTED] --------------------------------------------------------------------- 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
