On Tue, Jul 30, 2002 at 10:35:06PM -0700, Bhavin Vyas wrote: > Is there a way to have DB-A and DB-B such that DB-A is the master and DB-B > is the slave. However, I also want to make DB-B the master and DB-A it's > slave so that if I have to fail over to DB-B then DB-A is automatically > following the changes. It doesn't seem probable that this is possible, but I > wanted to know if there was a way to do this, that I don't know of.
Yes, you can do it. But beware of auto-increment fields as discussed in the manual. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 62 days, processed 1,313,338,207 queries (242/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
