InnoDB replication to MYISAM

[Shayne Paddock]

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.
 
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?
 
I wanted to take advantage of the huge speed boost MYISAM provides but
keep the data coming in clean.  
 
 
Kindest regards,
Shayne

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!
[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]