MySQL Forums :: NDB clusters :: NDB Cluster dump import slow


Advanced Search

NDB Cluster dump import slow
Posted by: Nils Burkhardt ()
Date: November 11, 2016 07:00AM

Hi,

we just built a new NDB Cluster on physical hardware to replace our virtual cluster. Every night we create a dump file of all the databases on the production system. I am trying to import these into the new cluster. Unfortunately it is unbelievable slow. If it doesn't fail, 17GB will take around 45 hours. The cluster consists of 2 datanodes (16 cores and 178GB RAM each), 2 apinodes (16 cores and 48GB each) and 2 management nodes (2 cores and 24GB RAM each). All nodes are connected through a separate 10GBit network.
I am a bit confused why it is performing so badly, can someone help me? What am I missing?

Kind Regards,

Nils

Options: ReplyQuote


Subject Views Written By Posted
NDB Cluster dump import slow 494 Nils Burkhardt 11/11/2016 07:00AM
Re: NDB Cluster dump import slow 278 David Ashman 11/11/2016 12:06PM
Re: NDB Cluster dump import slow 299 Nils Burkhardt 11/14/2016 01:28AM
Re: NDB Cluster dump import slow 254 David Ashman 11/14/2016 12:27PM
Re: NDB Cluster dump import slow 77 Thomas Waibel 02/14/2017 09:39AM


Sorry, only registered users may post in this forum.

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.