Howto sync tables created with myisam engine in a cluster

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Hi,

I have a Mysql cluster with three nodes. Then by an error I created a table with engine myisam. After this, I insert multiple rows throught a load balancer. Now, I have X rows in first node, Y rows in second, and Z in thirth node.

If directly change each table from myisam to innodb, with alter table mytable engine=InnoDB, then the new rows that I insert synced correctly, but the old rows not synced.

Exists any automatic method for sync these old rows?

Regards,
Cesar Jorge

2

You need to delete the old rows.
and insert the rows again.