My Oracle Support Banner

[PCA 3.x] How to Re-initialize a MySQL Data Node (Doc ID 2866917.1)

Last updated on AUGUST 21, 2022

Applies to:

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

Goal

Sometimes when the Data Nodes mismatch, they will be unable to sync on startup.

This may result in an NDB data node being forced into a reboot loop.

The Data Node must be reinitialized to force it to sync data from other nodes.

WARNING: This will erase ALL data on the affected data node, take a backup before proceeding.

The "ndb_mgm -e show" command will constantly show a data node in "not connected" or "starting" states.

Tailing the /var/lib/mysql-cluster/ndb_*_cluster.log files will show a node constantly being disconnected. 

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.