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