# Inconsistent data in cluster of 3 nodes

**URL:** <https://forums.percona.com/t/inconsistent-data-in-cluster-of-3-nodes/2494>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [October 23, 2012, 8:41am UTC](https://forums.percona.com/t/inconsistent-data-in-cluster-of-3-nodes/2494 "2012-10-23T08:41:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![rtacconi](https://avatars.discourse-cdn.com/v4/letter/r/13edae/32.png) [@rtacconi](https://forums.percona.com/u/rtacconi)\
**Post date:** [October 23, 2012, 8:41am UTC](https://forums.percona.com/t/inconsistent-data-in-cluster-of-3-nodes/2494/1 "2012-10-23T08:41:44Z")

</div>

I am started to use in production the Percona XtraDB cluster. I checked the number of rows in each table in each node and the total is different in each node. All node have:

wsrep\_ready ON

and wsrep\_local\_state\_uuid is equal to wsrep\_cluster\_state\_uuid

It is clear that the cluster has made data inconsistent and it does not keep things on sync. How should I processed to fix the issues? How is it possible to have a different number of rows in the nodes and the cluster replication seems ok?

---

<div class="post-metadata">

**Author:** ![rtacconi](https://avatars.discourse-cdn.com/v4/letter/r/13edae/32.png) [@rtacconi](https://forums.percona.com/u/rtacconi)\
**Post date:** [October 23, 2012, 11:09am UTC](https://forums.percona.com/t/inconsistent-data-in-cluster-of-3-nodes/2494/2 "2012-10-23T11:09:22Z")

</div>

Actually I found that this query

SELECT table\_name, table\_rows FROM INFORMATION\_SCHEMA.TABLES WHERE TABLE\_SCHEMA = ‘my\_cd’;

returns sort of casual numbers, so if I run it 10 times, most of the times the number of rows are different. I saw that two tables have an issue: when a new row is inserted, the change is not replicated to the other two hosts. What would be the cause? How to fix it?

---

<div class="post-metadata">

**Author:** ![rtacconi](https://avatars.discourse-cdn.com/v4/letter/r/13edae/32.png) [@rtacconi](https://forums.percona.com/u/rtacconi)\
**Post date:** [October 23, 2012, 12:15pm UTC](https://forums.percona.com/t/inconsistent-data-in-cluster-of-3-nodes/2494/3 "2012-10-23T12:15:15Z")

</div>

The DB should had only InnoDB tables, but the two tables where MyIsam!