# Howto sync tables created with myisam engine in a cluster

**URL:** <https://forums.percona.com/t/howto-sync-tables-created-with-myisam-engine-in-a-cluster/7015>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [May 15, 2019, 1:01pm UTC](https://forums.percona.com/t/howto-sync-tables-created-with-myisam-engine-in-a-cluster/7015 "2019-05-15T13:01:56Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![cesarjorgemartinez](https://avatars.discourse-cdn.com/v4/letter/c/46a35a/32.png) [@cesarjorgemartinez](https://forums.percona.com/u/cesarjorgemartinez)\
**Post date:** [May 15, 2019, 1:01pm UTC](https://forums.percona.com/t/howto-sync-tables-created-with-myisam-engine-in-a-cluster/7015/1 "2019-05-15T13:01:56Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![steven\_Lin](https://avatars.discourse-cdn.com/v4/letter/s/4bbf92/32.png) [@steven\_Lin](https://forums.percona.com/u/steven_Lin)\
**Post date:** [August 8, 2019, 12:21am UTC](https://forums.percona.com/t/howto-sync-tables-created-with-myisam-engine-in-a-cluster/7015/2 "2019-08-08T00:21:45Z")

</div>

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