Will mysql-table-checksum from mysql toolkit work with setups that have
different Master/ Slave storage engines? Are there any things to
consider when using it between two different engines ( say Innodb master
and MyIsam slave)?

Thanks in advance,

Bill Newton

Bill Newton wrote:
> Will mysql-table-checksum from mysql toolkit work with setups that have
> different Master/ Slave storage engines? Are there any things to
> consider when using it between two different engines ( say Innodb master
> and MyIsam slave)?

It should work fine with the default settings. The major difference
between the storage engines you mention is the row order might be
different for a full table scan. The default checksumming strategy uses
BIT_XOR(), which is order-independent.

If you have problems, please post a bug report on Sourceforge. There's
also a Sourceforge mailing list for the toolkit if you want to discuss
it at length (it's technically off-topic for this list, but I doubt
anyone minds much...)

Thanks
Baron