Database Administrators Asked by Rameez on February 23, 2021
MariaDB cluster Version : mysql Ver 15.1 Distrib 10.0.24-MariaDB,
I have a two node + arbitrator cluster which is live and replicating data across nodes.
Unfortunately we found some inconsistency in some of the tables in Databases.
For instance:
Node1:
MariaDB [(none)]> select count(*) from example_db.reports;
+----------+
| count(*) |
+----------+
| 299 |
+----------+
1 row in set (0.00 sec)
Node2:
MariaDB [(none)]> select count(*) from example_db.reports;
+----------+
| count(*) |
+----------+
| 285 |
+----------+
1 row in set (0.00 sec)
Note: Not find any noticeable errors in mysql error log
What could be the reasons for these kind of inconsistency ?
Is that a bug or a known issues ?
Thank you.
pt-table-checksum
supports Galera. Try it to see if there are any inconsistencies.
Answered by akuzminsky on February 23, 2021
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP