Re: Replication and AUTO_INCREMENT; is it safe?

2007-10-24 Thread Harrison Fisk
Hello, On Oct 23, 2007, at 11:23 AM, js wrote: Hi list, Reading How AUTO_INCREMENT Handling Works in InnoDB[1] makes me wonder how is it possible to replicate AUTO_INCREMENTed value to slaves. According to the doc, "If you specify an AUTO_INCREMENT column for an InnoDB table, the table ha

Re: Replication and AUTO_INCREMENT; is it safe?

2007-10-24 Thread Eric Frazier
On 10/24/07, Eric Frazier <[EMAIL PROTECTED]> wrote: js wrote: Hi list, Reading How AUTO_INCREMENT Handling Works in InnoDB[1] makes me wonder how is it possible to replicate AUTO_INCREMENTed value to slaves. According to the doc, "If you specify an AUTO_INCREMENT column for an InnoDB ta

Re: Replication and AUTO_INCREMENT; is it safe?

2007-10-23 Thread js
Thank you for your reply. But I couldn't under stand how --auto-increment-increment and --auto-increment-offset helps me avoid my problem. Could you please explain? On 10/24/07, Eric Frazier <[EMAIL PROTECTED]> wrote: > js wrote: > > Hi list, > > > > Reading How AUTO_INCREMENT Handling Works in

Re: Replication and AUTO_INCREMENT; is it safe?

2007-10-23 Thread js
> > If After "delete from table where id = 4" and restart mysqld on server B, > > "insert into table (value) values(e)" is executed on server A. > > > Why would you delete data from the slave? The delete statement is for Master, not slave. -- MySQL General Mailing List For list archives: http://

Re: Replication and AUTO_INCREMENT; is it safe?

2007-10-23 Thread Philip Hallstrom
Reading How AUTO_INCREMENT Handling Works in InnoDB[1] makes me wonder how is it possible to replicate AUTO_INCREMENTed value to slaves. According to the doc, "If you specify an AUTO_INCREMENT column for an InnoDB table, the table handle in the InnoDB data dictionary contains a special counter c

Replication and AUTO_INCREMENT; is it safe?

2007-10-23 Thread js
Hi list, Reading How AUTO_INCREMENT Handling Works in InnoDB[1] makes me wonder how is it possible to replicate AUTO_INCREMENTed value to slaves. According to the doc, "If you specify an AUTO_INCREMENT column for an InnoDB table, the table handle in the InnoDB data dictionary contains a special

Re: Replication and Auto_Increment

2003-09-18 Thread Fred van Engen
On Thu, Sep 18, 2003 at 01:14:47PM -0400, Christopher Ferry wrote: > We're running bi-directional replication between two servers running > MySQL 3.23.56. > > One server being active the other a hot standby. > Wanting to switch to the hot standby I noticed that replication had > ceased on the HS s

Replication and Auto_Increment

2003-09-18 Thread Christopher Ferry
We're running bi-directional replication between two servers running MySQL 3.23.56. One server being active the other a hot standby. Wanting to switch to the hot standby I noticed that replication had ceased on the HS server. The show slave status: | 192.168.1.10 | mysql_replicator | 3309

RE: replication and auto_increment

2002-12-19 Thread Maxime LEMAIRE
TED] 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

replication and auto_increment

2002-12-19 Thread Maxime LEMAIRE
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://ww