1

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.

1
  • please upload your mariadb log to GitHub Gist or other paste service. Please post details about your configuration (my.cnf). Are in datadir *.GRA files?
    – Sybil
    Commented Mar 16, 2017 at 7:15

1 Answer 1

1

pt-table-checksum supports Galera. Try it to see if there are any inconsistencies.

4
  • Thanks @akuzminsky for the response. I confirmed that there are inconsistency in some tables. And pt-table-checksum only supports for STATEMENT. But my binlog_format is ROW.
    – Rameez
    Commented Mar 16, 2017 at 6:46
  • That's not correct. pt-tc depends on STATEMENT format which it sets in its own session. So, it works perfectly fine even if binlog_format is ROW.
    – akuzminsky
    Commented Mar 16, 2017 at 16:02
  • percona.com/doc/percona-toolkit/2.2/…
    – Rameez
    Commented Mar 20, 2017 at 5:14
  • Oh, you found the documentation! Why don't you read it now ?
    – akuzminsky
    Commented Mar 21, 2017 at 14:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.