MySQL Forums
Forum List  »  InnoDB clusters

Using Clone for Cluster.addInstance uses 100% Memory
Posted by: Marvin Warble
Date: March 04, 2024 09:35AM

When trying to add a new node to a MySQL Innodb cluster using Cluster.addInstance() and selecting the Clone option, within 2 or 3 minutes the donor nodes memory usages hits 100% on a server with 36Gb of memory. At 100% memory usage the server becomes unresponsive and the recipient server moves to another server in the cluster, tries to clone, and the memory usage of the 2nd donor hits 100%. The entire cluster is degraded in under 10 min and unavailable.

This is on a Production server so the consequences here are pretty devastating.

I'm running MySQL 8.0.35-27 on Debian 12 Bookworm.

I have not encountered this problem setting up a test cluster with a small amount of data, which I have done several times to ensure I'm doing everything correctly. However on my Production server with about 125Gb of data, this problem occurs consistently.

Has anyone else experienced this problem or know what the cause might be?

Thank you.

Options: ReplyQuote


Subject
Views
Written By
Posted
Using Clone for Cluster.addInstance uses 100% Memory
126
March 04, 2024 09:35AM


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.