以下是在Linux上搭建MariaDB集群的指南,以Galera Cluster為例:
編輯配置文件/etc/mysql/mariadb.conf.d/60 - galera.cnf
,添加以下內容:
[mysqld]
binlog_format=ROW
default-storage-engine=InnoDB
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0
wsrep_on=ON
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_cluster_address="gcomm://node1_ip,node2_ip,node3_ip"
wsrep_node_address="當前節點IP"
wsrep_node_name="當前節點名稱"
wsrep_sst_method=xtrabackup - v2
wsrep_sst_auth="sst_user:sst_password"
sudo systemctl stop mariadb
,然后sudo galera_new_cluster
,最后sudo systemctl start mariadb
。sudo systemctl restart mariadb
。在任意節點上登錄MySQL,執行SHOW STATUS LIKE 'wsrep_cluster_size'
,若返回值等于節點數,則集群搭建成功。還可執行SHOW STATUS LIKE 'wsrep_%'
查看集群健康狀態。