Sunday, January 26, 2020

MariaDB Galera Cluster with Arbitrator


https://github.com/auntaru/vagrantfiles.git



[root@garb3 ~]# cat /etc/my.cnf.d/server.cnf
[mariadb]
wsrep_provider='/usr/lib64/galera/libgalera_smm.so'
wsrep_cluster_address=gcomm://192.168.33.11,192.168.33.12,192.168.33.13
wsrep_node_address=192.168.33.13
binlog_format=ROW
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
innodb_doublewrite=1
wsrep_on=ON
wsrep_cluster_name="auntaru_mariadb"
log-error = /var/lib/mysql/error.log
[root@garb3 ~]#


starting the cluster , adding one DB node and the arbitrator : 
 - galera_new_cluster
 - systemctl start mariadb.service
 - garbd -a gcomm://192.168.33.11,192.168.33.12,192.168.33.13 -g auntaru_mariadb

https://github.com/auntaru/vagrantfiles/blob/master/provision.sh


The Vagrant script downloads the official centos/7 box from :
https://cloud.centos.org/centos/7/vagrant/x86_64/images/


No comments:

Post a Comment