Alex Yurchenko wrote:
On Sat, 22 Aug 2009 06:54:19 -0400, Jim Starkey <[email protected]>
wrote:
Hmmm. How much consideration has been given to cross engine issues? A
checksum based on simple byte stream is going to give different results
on a record in an engine that stores in primary key order and an engine
that stores in physical order.
Expecting identical byte streams from distinct servers seems to be too
strict of a requirement. Perhaps it won't be too far-fetched to assume that
even with the same storage engine physical order of rows might differ on
different machines? Which leads us to two interesting conclusions:
1. Tables can be compared only in primary key order.
2. Tables without primary key are incomparable (unless you can consistently
sort whole rows).
Or use a byte order algorithm for rows and a second, order insensitive
algorithm to checksum row checksums (I have candidates for neither).
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
