hi, here is the problem ... think about this :
serverR1 / serverR2 : replication servers serverWWW : webserver serverWWW reads/writes data from/to serverR1 serverR2 replicate serverR1 data serverR1 crashes serverWWW reads/writes data from/to serverR2 serverR1 (up) replicate serverR2 data the goal of this architecture is to prevent to lose data i don't know if it's possible with mysql (that depends of internal auto_increment id management) -----Message d'origine----- De : gerald_clark [mailto:[EMAIL PROTECTED]] Envoye : jeudi 19 decembre 2002 16:59 A : [EMAIL PROTECTED] Objet : Re: replication and auto_increment Do not allow inserts on both machines. Maxime LEMAIRE wrote: >hi, > >i would like to create a dual master/slave replication with mysql >i think i wouldn't have any problem but i wonder how mysql manage >auto_increment id ... >how it works ? > > >maxime > > > --------------------------------------------------------------------- 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
