# my percona xtraDB cluster 8.0.19 do not replicate well

**URL:** <https://forums.percona.com/t/my-percona-xtradb-cluster-8-0-19-do-not-replicate-well/7889>\
**Category:** Percona XtraDB Cluster 8.x\
**Tags:** community, mysql, percona\
**Created:** [August 12, 2020, 3:27am UTC](https://forums.percona.com/t/my-percona-xtradb-cluster-8-0-19-do-not-replicate-well/7889 "2020-08-12T03:27:21Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![DBA100](https://avatars.discourse-cdn.com/v4/letter/d/b3f665/32.png) [@DBA100](https://forums.percona.com/u/DBA100)\
**Post date:** [August 12, 2020, 3:27am UTC](https://forums.percona.com/t/my-percona-xtradb-cluster-8-0-19-do-not-replicate-well/7889/1 "2020-08-12T03:27:21Z")

</div>

hi,  
  
I found sth funny about my percona xtraDB cluster 8.0.19, I can create database and it is replicated to other members, but not tables inside, any reason why on this?  
  
wrep status shows normal.  
  
what I can say is , before that when I restore data from xtraDB cluster 5.7.x and probably data sent too large, the cluster drop off 2 twice !  
  
first time is node 1 need to restart, and the second one is node 2 need to restart, now they seems unsync in this way, how to fix it?

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [August 12, 2020, 11:55am UTC](https://forums.percona.com/t/my-percona-xtradb-cluster-8-0-19-do-not-replicate-well/7889/2 "2020-08-12T11:55:45Z")

</div>

Hi DBA100,  
Unfortunately this is sounds like a complicated issue that cannot be resolved over forum posts. I highly suggest you contact our [Support](https://www.percona.com/services/support/mysql-support) department for assistance on this matter.

---

<div class="post-metadata">

**Author:** ![DBA100](https://avatars.discourse-cdn.com/v4/letter/d/b3f665/32.png) [@DBA100](https://forums.percona.com/u/DBA100)\
**Post date:** [August 13, 2020, 1:33am UTC](https://forums.percona.com/t/my-percona-xtradb-cluster-8-0-19-do-not-replicate-well/7889/3 "2020-08-13T01:33:10Z")

</div>

then they will bill me!&nbsp;  
what I experienced is , just reboot the node out sync, which monitoring variable said it is synced, then it solved!  
and I just restore DB yesterady and this make cluster broke down twice!

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [August 13, 2020, 7:39am UTC](https://forums.percona.com/t/my-percona-xtradb-cluster-8-0-19-do-not-replicate-well/7889/4 "2020-08-13T07:39:15Z")

</div>

So, everything is OK now?

---

<div class="post-metadata">

**Author:** ![DBA100](https://avatars.discourse-cdn.com/v4/letter/d/b3f665/32.png) [@DBA100](https://forums.percona.com/u/DBA100)\
**Post date:** [August 13, 2020, 7:47am UTC](https://forums.percona.com/t/my-percona-xtradb-cluster-8-0-19-do-not-replicate-well/7889/5 "2020-08-13T07:47:47Z")

</div>

yeah! any global variable you suggest me to avoid this ? and what value should it be ?  
cluster nodes has to reboot many time for data to be REAL sync… amazing/

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [August 13, 2020, 1:01pm UTC](https://forums.percona.com/t/my-percona-xtradb-cluster-8-0-19-do-not-replicate-well/7889/6 "2020-08-13T13:01:52Z")

</div>

Without knowing your setup, schemas, etc, I can’t provide much help. I don’t really know what your original issue was. Do you have any MyISAM tables? These will not replicate data within the cluster. Switch them to InnoDB.

---

<div class="post-metadata">

**Author:** ![DBA100](https://avatars.discourse-cdn.com/v4/letter/d/b3f665/32.png) [@DBA100](https://forums.percona.com/u/DBA100)\
**Post date:** [August 14, 2020, 12:10am UTC](https://forums.percona.com/t/my-percona-xtradb-cluster-8-0-19-do-not-replicate-well/7889/7 "2020-08-14T00:10:38Z")

</div>

"Do you have any MyISAM tables?&nbsp;"  
no!  
“These will not replicate data within the cluster. Switch them to InnoDB.”:  
good information tks.  
  
but how to change without impacting data?

---

<div class="post-metadata">

**Author:** ![DBA100](https://avatars.discourse-cdn.com/v4/letter/d/b3f665/32.png) [@DBA100](https://forums.percona.com/u/DBA100)\
**Post date:** [August 14, 2020, 12:12am UTC](https://forums.percona.com/t/my-percona-xtradb-cluster-8-0-19-do-not-replicate-well/7889/8 "2020-08-14T00:12:06Z")

</div>

the problem is , sometimes even user login can’t replicate well and has to reboot out synced nodes! that user login is not in MYISM table …

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [August 14, 2020, 7:59am UTC](https://forums.percona.com/t/my-percona-xtradb-cluster-8-0-19-do-not-replicate-well/7889/9 "2020-08-14T07:59:15Z")

</div>

If you have to reboot nodes to get them to sync, that’s usually indication you have MyISAM tables. MyISAM tables will only sync on SST. Run this “SELECT table\_schema, table\_name FROM information\_schema.tables WHERE engine = ‘MyISAM’ and table\_schema != “mysql”” to see if you have any.  
If you’re still having issues after that, I suggest you grab a support contract with Percona to assist you further.
