Pivotal Knowledge Base

Follow

How to Manually Force a MySQL Node to Rejoin if a Node Cannot Rejoin the Cluster for P-MySQL v1.9 and v1.10

Environment

Pivotal Cloud Foundry MySQL for v1.9 and v1.10

Purpose

When a node cannot rejoin the cluster automatically a PCF operator needs to manually force a MySQL node to rejoin, the procedures are explained in this article.

If your cluster is experiencing downtime or is in a degraded state, Pivotal recommends the following workflow for gathering information to diagnose the type of failure the cluster is experiencing https://docs.pivotal.io/p-mysql/1-9/troubleshooting.html#diagnosing.

Procedure

This procedure removes all the data from a server node, forces it to join the cluster, and creates a new copy of the cluster data on the node. 

Note: Do not do this if there is any data on the local node that you need to preserve.

  1. Log into the node as root.
  2. Run monit stop mariadb_ctrl
  3. Run rm -rf /var/vcap/store/mysql
  4. Run /var/vcap/jobs/mysql/bin/pre-start
  5. Run monit start mariadb_ctrl

 

Comments

Powered by Zendesk