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]