In this stage you need two nodes with Debian OS for deploy Galera Cluster Maria DB. The next entry add other two nodes with HAProxy and VIP for load balancer to Cluster.
The first step is add the repository of mariadb to Debian (Node1 and node2):
sudo apt-get install software-properties-common
sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db
sudo add-apt-repository 'deb [arch=amd64,i386] http://mariadb.kisiek.net/repo/10.0/debian jessie main'
sudo apt-get update
sudo apt-get upgrade
When is done, install the software for Galera cluster (Node1 and node2):
apt-get install -y rsync galera mariadb-galera-server
The next step is configure the file of configuration of Galera:
For node01:
echo '[mysqld] # MySQL Configuration query_cache_size=0 binlog_format=ROW default-storage-engine=innodb innodb_autoinc_lock_mode=2 query_cache_type=0 bind-address=0.0.0.0 # Galera Provider Configuration wsrep_provider=/usr/lib/galera/libgalera_smm.so #wsrep_provider_options="gcache.size=32G" # Galera Cluster Configuration wsrep_cluster_name="test_cluster" wsrep_cluster_address="gcomm://192.168.30.11:4567,192.168.30.12:4567" # Galera Synchronization Congifuration wsrep_sst_method=rsync #wsrep_sst_auth=user:pass # Galera Node Configuration wsrep_node_address="192.168.30.11" wsrep_node_name="node01"' > /etc/mysql/conf.d/galera.cnf ; chmod 770 /etc/mysql/conf.d/galera.cnf
For node02:
echo '[mysqld] # MySQL Configuration query_cache_size=0 binlog_format=ROW default-storage-engine=innodb innodb_autoinc_lock_mode=2 query_cache_type=0 bind-address=0.0.0.0 # Galera Provider Configuration wsrep_provider=/usr/lib/galera/libgalera_smm.so #wsrep_provider_options="gcache.size=32G" # Galera Cluster Configuration wsrep_cluster_name="test_cluster" wsrep_cluster_address="gcomm://192.168.30.11:4567,192.168.30.12:4567" # Galera Synchronization Congifuration wsrep_sst_method=rsync #wsrep_sst_auth=user:pass # Galera Node Configuration wsrep_node_address="192.168.30.12" wsrep_node_name="node02"' > /etc/mysql/conf.d/galera.cnf ; chmod 770 /etc/mysql/conf.d/galera.cnf
BONUS configuration
[mysql_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Configure the file /etc/hosts (Node1 and node2):
192.168.30.11 node01
192.168.30.12 node02
Copy file /etc/mysql/debian.cnf to the node01 to node02
Stop the service MySQL (Node1 and node2):
service mysql stop
Execute the next command for create new cluster (Node1):
service mysql start --wsrep-new-cluster
ERROR: WSREP: gcs connect failed: Connection timed out SOLUTION: Execute:
service mysql bootstrap
Restart all services of MySQL and Galera (Node1 and node2).
The next query response the number of nodes of cluster Galera:
mysql -u root -e 'SELECT VARIABLE_VALUE as "cluster size" FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME="wsrep_cluster_size"' -p
Finish the first part.