Afficher un message
Vieux 28/08/2007, 18h07   #2
Baron Schwartz
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: mysql-table-checksum with mixed storage enginges

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
  Réponse avec citation
 
Page generated in 0,04837 seconds with 9 queries