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.