SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 07:00 AM
| ||||
| ||||
 mysql-table-checksum with mixed storage enginges 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      |
|
02-28-2008, 07:00 AM
| ||||
| ||||
| 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 |
Linear Mode
