Galera Cluster not working

OVERVIEW

Whenever an entire Galera cluster is not working then you should never stop or restart the entire cluster. You can refer to the below steps for it.                                                   

STEPS -

1 - Take ssh of MySQL/MariaDB node

Take the ssh / webssh of any one mysql/mariadb node in that cluster.

Go to /var/lib/mysql

open file grastate.dat

last line is safe_to_bootstrap: 0

change it to

safe_to_bootstrap: 1

Note: Bootstrap is the first node in a cluster. so we are saying it is safe for this node to be the first node in the galera cluster.

2 - Start mysql

Service mysql start

Once started, go to other 2 nodes and start mysql/mariadb one by one.

Note: Don't change grastate on the other 2 nodes.

 

  • 0 Utilisateurs l'ont trouvée utile
Cette réponse était-elle pertinente?

Articles connexes

PostgreSQL Database Replication

Database Replication with PostgreSQL 9 Replication is a basic technology for any database...

Scheduling Databases Backups

Scheduling Database Backups Scheduled backups are data backup processes which proceed...

MongoDB Database Backups

Create an environment 1. Log into your Apiqcloud account and click Create environment. 2. As...

Database Configuration

Database Configuration Below you will see the list of the configuration files available for...

PostgreSQL Database Backups

Automatic PostgreSQL Backups   The instruction below shows how to configure automatic...