HELP, HELP! My Percona XtraDB Cluster version: 5.7.31-31. Single Node is stuck in a joined state.
I recently had the privilege to help a client with a fascinating issue.
NODE-B dropped out of the 3 node PXC cluster. It looked to be
DISK IO that caused NODE-B to fall far behind and eventually be
removed from the cluster. A restart of NODE-B allowed it
to rejoin the cluster. NODE-B looked to have been down for about 4 hours. Once NODE-B was back as part of the cluster, it required a full SST.
When NODE-B stayed in a joint state for more than 12 hours, the client gave me a call. They were concerned that there was another issue with this cluster.
Before going forward, let’s make sure we know the CPU, RAM and Database Size.
32 GB RAM
Database Size approx. 2.75TB
Let’s gather some base information.
I pulled the below data once I …[Read more]