MySQL Forums
Forum List  »  NDB clusters

Re: Data node deletion in NDB
Posted by: Tayyab Fayyaz
Date: December 06, 2021 04:07PM

Hi Mauritz Sundell,

Thank you for your input.

I found some user tables and ordered index part if 3,4 nods id, My question here drop the object so other node groups (3,4) will not cause the data loss?


Can I avoid the drop table statement and move all the fragments to other nodes?



SELECT DISTINCT node_id, fq_name, type FROM ndbinfo.memory_per_fragment WHERE node_id IN (3,4);
+---------+-----------------------------+---------------+
| node_id | fq_name | type |
+---------+-----------------------------+---------------+
| 3 | test1/def/test1_retry_queue | User table |
| 4 | test1/def/test1_retry_queue | User table |
| 3 | test1/def/test1 | User table |
| 4 | test1/def/test1 | User table |
| 3 | test1/def/NDB$BLOB_13_13 | User table |
| 4 | test1/def/NDB$BLOB_13_13 | User table |
| 3 | test1/def/test1 | User table |
| 4 | test1/def/test1 | User table |
| 3 | test1/def/NDB$BLOB_16_11 | User table |
| 4 | test1/def/NDB$BLOB_16_11 | User table |
| 3 | sys/def/13/PRIMARY | Ordered index |
| 4 | sys/def/13/PRIMARY | Ordered index |
| 3 | sys/def/16/PRIMARY | Ordered index |
| 4 | sys/def/16/PRIMARY | Ordered index |
+---------+-----------------------------+---------------+

Options: ReplyQuote


Subject
Views
Written By
Posted
703
November 30, 2021 01:28PM
374
November 30, 2021 04:36PM
378
December 01, 2021 07:21AM
379
December 03, 2021 03:16PM
503
December 03, 2021 03:43PM
367
December 03, 2021 03:49PM
368
December 03, 2021 03:53PM
384
December 03, 2021 04:35PM
Re: Data node deletion in NDB
388
December 06, 2021 04:07PM
366
December 07, 2021 12:30PM
349
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.