Re: InnoDB replication to MYISAM

[Jeremy Zawodny]

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!
<Jeremy@stripped>  |  http://jeremy.zawodny.com/

[book] High Performance MySQL -- http://highperformancemysql.com/