Not the answer you need?
Register and ask your own question!

pt-table-checksum and differences exponentials windows/linux

ErikEngerdErikEngerd EntrantCurrent User Role Beginner
Hi,


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?

Cheers
Erik

Comments

  • ErikEngerdErikEngerd Entrant Current User Role Beginner
    I should mention that I was already using the --float-precision 6 option to pt-table-checksum.
    Also, selecting a single row which is different (according to pt-table-sync --print only shows a difference in the formatting of this single floating point value. But rounding the value on both windows and linux leads to the same result.

    Could it be that the problem is in pt-table-sync instead?


    What could be wrong here?
  • ErikEngerdErikEngerd Entrant Current User Role Beginner
    I have now found one table for which there is only one difference reported from pt-table-checksum. Using pt-table-sync I can print the SQL that would update the row and extract the primary key of that row. If I then select this row from both the master and the slave in a mysql command prompt I see no differences. I verified this by cutting and pasting the output of the command on master and server and then using standard unix diff to check for differences.

    What could be the problem here? All I can think of is some compatibility issue between windows and linux.

    Any ideas?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.