以下是在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_%'查看集群健康状态。