In my MySQL cluster, the data usage of 4 data nodes is approximately 77%. I added a new data node online, and attempted to reorganize partition to redistribute data among all data nodes.
But before the query alter table customer_tbl reorganize partition; is successfully executed, the data usage of existing data nodes started increasing, and reached up to 95% before ERROR customer_tbl is FULL is encountered.
How can I bring a data node online and reorganize table successfully? My table has ~100 million rows.
Why the data usage of existing data nodes increased in the first place and what is the internal working of mysql cluster when it reorganizes partitions?