Kris,
- Original Message -
From: Krzysztof Karski [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, January 21, 2003 11:35 AM
Subject: replication problems with InnoDB tables...?
So I have been reading a lot lately about replication but I can't find a
good summary/explanation of MySQL's replication features regarding InnoDB
tables and how their transactional properties may cause problems in
replication.
transactions should not cause problems in replication. However, a relevant
bug fix is this:
MySQL/InnoDB-4.0.6, December 19, 2002
...
Fixed a bug: in replication issuing SLAVE STOP in the middle of a
multi-statement transaction could cause that SLAVE START would only perform
part of the transaction. A similar error could occur if the slave crashed
and was restarted.
I have seen suggestions that InnoDB tables should be converted to MyISAM
tables before being loaded and then converted back to InnoDB tables.
LOAD TABLE FROM MASTER only works for MyISAM tables.
To set up a new replication slave you should use a cold backup, or a hot
backup made with the non-free InnoDB tool.
I have also seen many others here confused as to what problems there are
between InnoDB and replication.
So, could some friendly MySQL guru please explain to me, and many others,
what the replication issues with InnoDB tables really are...please? The
docs
state that InnoDB is replication safe yet there seem to be so many
problems
with them when updates fail, roll back or are partially executed because
some constraint conflict that causes replication to stop.
A relevant bug fix:
MySQL/InnoDB-4.0.6, December 19, 2002
...
Fixed two bugs introduced in 4.0.4: in AUTO_INCREMENT, REPLACE could cause
the counter to be left 1 too low. A deadlock or a lock wait timeout could
cause the same problem.
MySQL does not write to the binlog SQL statements which fail. It does not
write to the binlog any SQL statements from a transaction which is rolled
back. Thus, these are never replicated, and in the slave there should not be
any constraint violation errors.
Sincerely
Kris Karski
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com
sql query
-
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