MySQL Forums
Forum List  »  NDB clusters

Re: Data node deletion in NDB
Posted by: Mauritz Sundell
Date: December 07, 2021 06:00PM

Hi Tayyab

No, you must drop table test1.test1 do be able to free the data nodes 3 and 4.
This will drop all data for table also on node 1 and 2.

Common ways to downscale a cluster are:

1) backup, reconfigure a smaller cluster, restore
Cluster will be down during this process, but is often the quickest way.

2) To avoid down time one can create a new cluster in parallel with old cluster, and bring new cluster up to date using MySQL replication, and then switch over application to new cluster and bring down old cluster.

Regards,
Mauritz

Options: ReplyQuote


Subject
Views
Written By
Posted
868
November 30, 2021 01:28PM
492
November 30, 2021 04:36PM
478
December 01, 2021 07:21AM
496
December 03, 2021 03:16PM
610
December 03, 2021 03:43PM
480
December 03, 2021 03:49PM
492
December 03, 2021 03:53PM
498
December 03, 2021 04:35PM
504
December 06, 2021 04:07PM
472
December 07, 2021 12:30PM
Re: Data node deletion in NDB
448
December 07, 2021 06:00PM


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.