Mariadb Galera Cluster

環境準備

1. 修改主機名
2. 配置主機名解析
3. 關閉防火牆 & selinux
4. 配置 yum 源

echo "10.35.172.77 node1
10.35.172.78 node2
10.35.172.79 node3" >> /etc/hosts



echo "[mariadb]
name=mariadb
baseurl=ftp://10.35.172.81/gpmall-repo
gpgcheck=0
enabled=1

[centos]
name=centos
baseurl=ftp://10.35.172.81/centos
gpgcheck=0
enabled=1" > /etc/yum.repos.d/ftp.repo           

安裝Mariadb Galera Cluster

# 安裝 mariadb
yum install mariadb-server -y

# 初始化資料庫
 systemctl start mariadb
 mysql_secure_installation 
 u
 # 配置資料庫檔案
 /etc/my.cnf.d/server.cnf
 
 # 修改資料庫密碼
 grant all privileges on *.* to root@'%' identified by '123456';
 
 # 停止資料庫
 systemctl stop mariadb
 
 # 啟動資料庫叢集
 node1
   galera_new_cluster
 node2 & node3
   systemctl start mariadb

# 驗證
node1
  MariaDB [(none)]> show status like "wsrep_ready";
  MariaDB [(none)]>  show status like "wsrep_cluster_size";
  MariaDB [(none)]> show status like "wsrep%"; 
  MariaDB [(none)]> create database abc; 
  MariaDB [(none)]> show databases;
node2
  MariaDB [(none)]> show databases;
node3
  MariaDB [(none)]> show databases;           

wsrep_on=ON 
wsrep_provider=/usr/lib64/galera/libgalera_smm.so
wsrep_cluster_address="gcomm://10.35.172.77,10.35.172.78,10.35.172.79"
wsrep_node_name=node1
wsrep_node_address=10.35.172.77
binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
wsrep_slave_threads=1
innodb_flush_log_at_trx_commit=0
innodb_buffer_pool_size=120M
wsrep_sst_method=rsync
wsrep_causal_reads=ON
bind-address=10.35.172.77