MySQL Forums
Forum List  »  NDB clusters

Re: MySQL Cluster 5.6 Load slow
Posted by: Jonathan Stephens
Date: September 09, 2015 02:24AM

I think it's very likely that the fastest method would be simply to copy all the necessary table files to an SQL node then convert the tables to NDB after you've imported them.

This would be much easier to do with MyISAM than with InnoDB, so convert the tables (or copies of them) to MyISAM first.

Stop the target SQL node if it's already running, copy the .frm, .MYI, and .MYD files over to it, then start it again.

In the mysql client, perform ALTER TABLE $tablename ENGINE=NDB on each imported table to convert it to NDB (should be easy to script this part if there are very many tables).



Note that when backing up and restoring NDB tables, you can use MySQL Cluster's native online backup and restore functionality, which is usually much faster and freer of hassles than using mysqldump.

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle

Options: ReplyQuote


Subject
Views
Written By
Posted
1653
September 01, 2015 06:52PM
Re: MySQL Cluster 5.6 Load slow
672
September 09, 2015 02:24AM


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.