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

Last updated on OCTOBER 29, 2024

Applies to:

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

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