InnoDB to NDBCLUSTER Engine
Hi everyone,
I ended up almost correctly configure my MySQL Cluster .
Now I would like to test to get closer to production.
I'll recover databases InnoDB and I love them for NDBCLUSTER convertirs in the tables work with my cluster.
I obviously try
"ALTER TABLE table ENGINE = NDBCLUSTER" but this is a per-table and I did not really want to waste my time with that.
Is there a way to change all the tables in a DB of a sudden?
I also try
"SELECT CONCAT (' ALTER TABLE ',table_name ' ENGINE = NDBCLUSTER;')
FROM INFORMATION_SCHEMA.TABLES
WHERE table_schema IN ('db1','db2');"
But it does not work despite it selects me well
"ALTER TABLE table1 ENGINE = NDBCLUSTER"
"ALTER TABLE table2 ENGINE = NDBCLUSTER"
in profit ..
Can you help me?
Best Regards,
Florian .
Subject
Views
Written By
Posted
InnoDB to NDBCLUSTER Engine
2109
March 06, 2015 04:49AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.