We have a script that transfers databases between clusters. To make sure the data is still valid, we run a checksum on some of the tables. If those are ok, we mark transfer succesful. The problem is that even though I notice the data is same, I get different result for servers. So running this:
CHECKSUM TABLE db.table EXTENDED
For Mariadb it gives over 500k and on Mysql over 3 bilion. This documentation says this should be the same but evidently, they are not. What could affect the difference?
I do know about pt library but I would rather use checksum if possible.
Thank you, I appreciate all help