On Wed, May 12, 2004 at 01:38:04PM -0400, Shayne Paddock wrote:
In section 16.7.5 in the mysql manual it says that you can setup
replication with InnoDB tables on the master to MYISAM tables on the
slave. While I have proven this to be true, it does not warn you that
if in your Master's contstraints you have ON DELETE or ON UPDATE clauses
those clauses will not run on the slave, causing the slave to be out of
sync with the master.
Correct. That's perhaps a documentation bug.
Paul?
I don't suppose there is a way to get those updates and deletes written
to the binary log? Or any other way to keep the slave in sync?
No.
The binary log records the queries you send to MySQL and a few other
bits of metadata.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
[book] High Performance MySQL -- http://highperformancemysql.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]