MariaDB Galera Quicktips
By Tech Writer
•
•
1 min read
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 filessudo nano /etc/mysql/conf.d/galera.cnfor
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 -u root -p -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.