galera_new_cluster - Linux
Overview
galera_new_cluster initializes and bootstraps a new Galera cluster, creating the necessary configuration files and database objects to enable multi-master replication. It automates the complex process of setting up a Galera cluster, making it easier to establish a highly available database infrastructure.
Syntax
galera_new_cluster [OPTIONS]
Options/Flags
- -u, –user=USER
- The MySQL user to use for database operations. Defaults to "root".
- -p, –password=PASSWORD
- The password for the MySQL user. Defaults to an empty string.
- -h, –host=HOST
- The hostname or IP address of the primary Galera node. Defaults to "localhost".
- -P, –port=PORT
- The port number to connect to MySQL. Defaults to "3306".
- -d, –datadir=DATADIR
- The directory to store MySQL data files. Defaults to "/var/lib/mysql".
- -c, –configdir=CONFIGDIR
- The directory to store MySQL configuration files. Defaults to "/etc/mysql".
- –force
- Proceed with cluster initialization even if the data directory is not empty.
Examples
Simple usage:
galera_new_cluster
Specify username and password:
galera_new_cluster -u username -p password
Using a custom data directory:
galera_new_cluster -d /opt/mysql/data
Common Issues
- Empty data directory: Ensure the data directory specified using the -d option is empty before running galera_new_cluster.
- MySQL user permissions: The MySQL user used for database operations must have the necessary privileges, including the ability to create and manage databases.
- Firewall restrictions: Check if firewalls are blocking connections to the MySQL port.
Integration
Creating a Galera cluster from scratch:
galera_new_cluster
sudo service mysql start
Adding a node to an existing Galera cluster:
galera_new_cluster -h <existing_node_hostname>
sudo service mysql start
Related Commands
- mysql – The MySQL command-line client.
- my.cnf – The MySQL configuration file.
- wsrep-recover – A utility used for recovering Galera nodes after a failure.