MariaDB Galera Quicktips

 

Set mysql server to auto start on all nodes.

Only when all the nodes are down run on main node.

sudo service mysql start --wsrep-new-cluster

Run the following on member nodes.

sudo service mysql start 

Join nodes to cluster by using command, with IP of one of the cluster nodes.

sudo service mysql start –wsrep_cluster_address=gcomm://ip_address

Check cluster size

mysql -u root -p -e ‘SELECT VARIABLE_VALUE as “cluster size” FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME=”wsrep_cluster_size”‘


Double check configuration files

sudo nano /etc/mysql/conf.d/galera.cnf
or 
sudo nano /etc/mysql/conf.d/my.cnf

 

ERROR 1045 (28000): Access denied for user ‘debian-sys-maint’@’localhost’ (using password: YES)

Processing triggers for ureadahead (0.100.0-16) …

 

System check

mysql root e“show status like ‘wsrep%'”

wsrep_local_state_comment    |Synced         <cluster issynced
wsrep_incoming_addresses     |10.0.0.9:3306  <node db1 isaprovider
wsrep_cluster_size           |1              <cluster consists of1node 
wsrep_ready                  |ON             <good:)


If you are importing an SQL file. Ensure that the database is imported as InnoDB.
 
Galera only support InnoDB replication.
 

Leave a Reply