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.
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.
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
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.
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
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.