Hi, Jeremy. What if one is the master and one is a slave, but both are used in production environments? Is it possible for a slave to be used as a live production database or is it simply for backup?
If they can both be used as live production databases, how can they be synced with replication? Rick Rick Faircloth, Prism Productions -----Original Message----- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Monday, December 30, 2002 10:57 AM To: Maxime LEMAIRE Cc: Mysql Subject: Re: replication On Mon, Dec 30, 2002 at 08:37:13AM +0100, Maxime LEMAIRE wrote: > Hi, > > I would like to know how mySQL manage the identity (auto increment > counter) in a replication environment when 2 servers are both master > on the same database. In that situation, you really need to generate your own primary keys. Using auto-increment with a dual-master setup is asking for trouble. It'll fail sooner or later, leaving you two servers that no longer agree on primary keys. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 15 days, processed 549,176,147 queries (411/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 --------------------------------------------------------------------- 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
