Re: Is this what this is? (what is MySQL Clustering)

[Klaus Berkling]

I have somewhat the same problem.

I have a database with about 7 million rows, the SQL dump file is about 2GB.

Here are steps I tried to migrate my data:
- I created all my tables with type ndbcluster. So far so good.
- I then dumped the data from my 4.0 server without create table commands and imported it to my 4.1 server. I did not use extended-insert nor the 'quick' flags. Trying to keep things simple.

This works for the smaller tables, and maybe this is how it can normally work. However the largest table did not import and failed: "ERROR 1297 (HY000) at line 226031: Got temporary error 4010 'Node failure caused abort of transaction' from ndbcluster." I get the same error if I ALTER TABLE, BTW.

So this procedure may work with smaller data sets, just not with 7 million rows.