I am using a slave on linux Centos 6.2 (mysql 5.1.61) with the master on windows (5.0.82-community-nt-log). I would like to reverse the roles of master and slave and insert a centos DVD into the windows machine and reinstall it, but… the windows machine is running the production database so I would like to be certain that the data is identical (enough).
Now I am running into this bug http://bugs.mysql.com/bug.php?id=12860
I can see it my just typing: ‘select 1e-7’ in the mysql command-line on both servers and this leads to three digits (1e-007) on windows and two (1e-07) on linux.
Do you know of any fix for this problem? Also, if I would fix this for pt-table-checksum then I would perhaps also need a similar for for pt-table-sync.
Any ideas on how to work around this problem?