List:General Discussion« Previous MessageNext Message »
From:Baron Schwartz Date:August 28 2007 5:07pm
Subject:Re: mysql-table-checksum with mixed storage enginges
View as plain text  
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
Thread
mysql-table-checksum with mixed storage engingesBill Newton28 Aug
  • Re: mysql-table-checksum with mixed storage engingesBaron Schwartz28 Aug