Howto sync tables created with myisam engine in a cluster


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?

Cesar Jorge

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