You can change the DB_Engine of MySQL tables even after creation, for example, when importing a database from a standalone setup (InnoDB or MyISAM) into a MySQL Cluster environment.
mysql> USE world;
mysql> ALTER TABLE city ENGINE=NDBCLUSTER;
mysql> ALTER TABLE country ENGINE=NDBCLUSTER;
mysql> ALTER TABLE countrylanguage ENGINE=NDBCLUSTER;
This method seems to no longer work, even though it’s still documented in MySQL manuals. I’ll update this section when I know more.
1️⃣ Create an SQL dump of the database you want to run in the cluster.
2️⃣ Edit the .sql file (the dump) with a text editor:
Replace ENGINE=InnoDB or ENGINE=MyISAM right after the CREATE TABLE statements with ENGINE=NDBCLUSTER.
3️⃣ Import the modified SQL dump into the cluster database.
✅ That’s it! 🎯
H@ppy H@cking! ⚡🐬