469,106 Members | 2,225 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,106 developers. It's quick & easy.

index and data files in mysql 3.23

Folks,

I have 3 mysql replicated servers ( 1 master + 2 slaves). One thing I
noticed is that every once in a while the data (*.MYD) and index (*.MYI)
files for a table may differ from the other mysql servers. Now my
question is this:

If I have identical data files on each server (verified by using
checksums), should the indexes generated be identical on each mysql
server? If not, is there something wrong? Is it possible for mysql to
generate 2 different and ok indexes from identical data files?

I am using

Mysql 3.23.58
myisam tables

All the servers are configured indentically (except for master/slave
relationships).

Thanks for your input,
Misk
Jul 20 '05 #1
0 1189

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by Andrew Dalke | last post: by
reply views Thread by Karam Chand | last post: by
reply views Thread by Mike Coppinger | last post: by
reply views Thread by Jean Hagen | last post: by
1 post views Thread by Rod Davis | last post: by
2 posts views Thread by Carlos Eduardo Peralta | last post: by
5 posts views Thread by Boo | last post: by
13 posts views Thread by Richard Brooks | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.