MySQL Forums
Forum List  »  NDB clusters

Re: Is this what this is? (what is MySQL Clustering)
Posted by: Klaus Berkling
Date: December 01, 2004 05:54PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Is this what this is? (what is MySQL Clustering)
2705
December 01, 2004 05:54PM


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.