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?