MySQL Forums
Forum List  »  NDB clusters

InnoDB to NDBCLUSTER Engine
Posted by: Schinas Florian
Date: March 06, 2015 04:49AM

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 .

Options: ReplyQuote


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.