Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Is it a good idea to have more than one management node for a MySQL Cluster?

April 26, 2017cluster good IDEA Management MySQL Node

0

Posted

Is it a good idea to have more than one management node for a MySQL Cluster?

1 Answer

0

Posted

It can be helpful as a fail-safe. Only one management node controls the cluster at any given time, but it is possible to configure one management node as primary, and one or more additional management nodes to take over in the event that the primary management node fails. See Section 17.3.4, “MySQL Cluster Configuration Files”, for information on how to configure MySQL Cluster management nodes.