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
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
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
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
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:
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
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
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
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:
: 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
10 matches
Mail list logo