# Percona mysql cluster not replicating DB to other 2 nodes in a cluster **URL:** \ **Category:** Percona XtraDB Cluster 8.x\ **Created:** [September 5, 2024, 8:08pm UTC](https://forums.percona.com/t/percona-mysql-cluster-not-replicating-db-to-other-2-nodes-in-a-cluster/32946 "2024-09-05T20:08:23Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Akkihadoop](https://avatars.discourse-cdn.com/v4/letter/a/a87d85/32.png) [@Akkihadoop](https://forums.percona.com/u/Akkihadoop)\ **Post date:** [September 5, 2024, 8:08pm UTC](https://forums.percona.com/t/percona-mysql-cluster-not-replicating-db-to-other-2-nodes-in-a-cluster/32946/1 "2024-09-05T20:08:23Z")
Hello I’ve recently installed percona mysql cluster on 3 nodes and so far it’s working fine. Few days back i’ve imported a DB in one node and when i ran select (_) on table it’s showing data only on the node where i imported database, on other 2 nodes in cluster it have DB and tables but when i ran select count(_) on table it’s giving output 0 I ran SHOW STATUS LIKE ‘wsrep\_%’; on all 3 nodes all of them synced. also verified wsrep\_cluster\_address, wsrep\_cluster\_name and wsrep\_node\_name values in all3 nodes. I din’t understand what’s going on so can someone please help. ---
**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:** [September 5, 2024, 8:43pm UTC](https://forums.percona.com/t/percona-mysql-cluster-not-replicating-db-to-other-2-nodes-in-a-cluster/32946/2 "2024-09-05T20:43:45Z")
Are all 3 nodes in ‘Primary’ state? Be sure to use SHOW GLOBAL STATUS. Check that none of the nodes are in `wsrep_desync=ON` state. ---
**Author:** ![Akkihadoop](https://avatars.discourse-cdn.com/v4/letter/a/a87d85/32.png) [@Akkihadoop](https://forums.percona.com/u/Akkihadoop)\ **Post date:** [September 5, 2024, 8:51pm UTC](https://forums.percona.com/t/percona-mysql-cluster-not-replicating-db-to-other-2-nodes-in-a-cluster/32946/3 "2024-09-05T20:51:39Z")
one thing what i noticed is the only tables not replicating are MyISAM structure and ENGINE set to MyISAM. All InnoDB structure tables are replicating fine on all 3 nodes in a cluster. could you please let me know is MyISAM tables replicate fine in Percona mysql cluster or it’s not supported? I am very new to the DB world please don’t mind my terminology wsrep\_desync\_count | 0 ---
**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:** [September 5, 2024, 8:55pm UTC](https://forums.percona.com/t/percona-mysql-cluster-not-replicating-db-to-other-2-nodes-in-a-cluster/32946/4 "2024-09-05T20:55:27Z")
> [@Akkihadoop](#): > > could you please let me know is MyISAM tables replicate fine in Percona mysql cluster or it’s not supported? 100% not supported. You shouldn’t have been able to create MyISAM tables, unless you turned off pxc\_strict\_mode which is designed to prevent these unsupported actions. You should not be using MyISAM tables at all, even in a non-PXC setup. The MyISAM engine is super old, out of date, not performant, etc. ---
**Author:** ![Akkihadoop](https://avatars.discourse-cdn.com/v4/letter/a/a87d85/32.png) [@Akkihadoop](https://forums.percona.com/u/Akkihadoop)\ **Post date:** [September 5, 2024, 9:01pm UTC](https://forums.percona.com/t/percona-mysql-cluster-not-replicating-db-to-other-2-nodes-in-a-cluster/32946/5 "2024-09-05T21:01:10Z")
Matthew Thank you so much for your quick response. Really appriciate your help I tried converting tables from MyISAM to InnoDB but still after converting also it’s not replicating the data from one node to other nodes in cluster. i’ve did this using below ALTER TABLE states ENGINE=InnoDB; other than that is there any other way i can convert tables and start replicating them ---
**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:** [September 6, 2024, 12:44am UTC](https://forums.percona.com/t/percona-mysql-cluster-not-replicating-db-to-other-2-nodes-in-a-cluster/32946/6 "2024-09-06T00:44:41Z")
Please set `pxc_strict_mode=ENFORCING` and then try your table alters. You might find out the immediate reason why nothing is working on these tables. > **[Percona XtraDB Cluster - Percona XtraDB Cluster strict mode](https://docs.percona.com/percona-xtradb-cluster/8.0/strict-mode.html)** > > The Percona XtraDB Cluster (PXC) Strict Mode is designed to avoid the use of > tech preview features and unsupported features in PXC. > This mode performs a number of validations at startup and during runtime.