Not the answer you need?
Register and ask your own question!

Howto sync tables created with myisam engine in a cluster

cesarjorgemartinezcesarjorgemartinez EntrantLegacy User Role Beginner
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

Comments

  • steven Linsteven Lin Contributor Current User Role Contributor
    You need to delete the old rows.
    and insert the rows again.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.