CODEWITHSUNDEEP
mysqlmariadbgalera
Rameez
Rameez

Reputation: 594

Inconsistency in Tables - Galera Cluster

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.

Upvotes: 1

Views: 337

Answers (1)

Rick James
Rick James

Reputation: 142298

I don't think there are any bugs in this very critical area.

In Galera clusters, you must check for errors after all statements, including COMMIT. (This is different than in ordinary replication.)

All tables are InnoDB, correct?

Upvotes: 0

Related Questions