To be a bit clearer,
should the MYI index files betweened two slaves of a mirrored database be
I would think they would be identical, right?
From: DePhillips, Michael P
Sent: 7/16/2003 6:18 PM
Subject: MYI file difference
I tarred up the data directory from mirror1 data base - slave. Copied
tarball to mirror2 with the hopes of rebuilding mirror2 - another slave.
Backed up the data directory from mirror2 into old and untarred mirror1
Then I did a diff -r against another mirror and the diff came back with
Binary files old/blahblahblah.MYI and data/blahblahblah.MYI differ,
For all the .MYI files.
Any insight as to why these indexes are different?