My Oracle Support Banner

[PCA 3.x] How to Start MySQL Cluster in Degraded State (Doc ID 2867937.1)

Last updated on AUGUST 21, 2022

Applies to:

Private Cloud Appliance X9-2 - Version Not Applicable and later
Linux x86-64

Goal

When one Management Node is unavailable and cannot start, MySQL cluster will not start automatically and needs to be told to disregard the offline Management Node.

Check MySQL cluster state by ndb_mgm -e "all status".

If available ndbd nodes are stuck in "Starting" state and one or more is offline, the cluster will not start.

Tailing the /var/lib/mysql-cluster/ndb_*_cluster.log, there should be repeated messages that nodes are waiting for an offline node.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.