https://mariadb.com/kb/en/installing-mariadb-deb-files/#installing-mariadb-galera-cluster-with-apt
mariadb:latest
apt-get update -y # 更新软件信息数据库
apt-get install -y wget vim net-tools curl git cron axel zip unzip
apt-get dist-upgrade -y # 这一步安装所有可用更新,包括新内核
apt-get upgrade -y
curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | bash
add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http://sfo1.mirrors.digitalocean.com/mariadb/repo/10.3/ubuntu bionic main'
apt-get install software-properties-common
apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db
apt-get install mariadb-server galera-4 mariadb-client libmariadb3 mariadb-backup mariadb-common
apt-get install galera-arbitrator-4
vim /etc/mysql/mariadb.conf.d/galera.conf
[galera]
# Mandatory settings
wsrep_provider= /usr/lib/galera/libgalera_smm.so
wsrep_cluster_address="gcomm://10.42.115.191,10.42.232.198,10.42.134.71"
wsrep_cluster_name = 'galera'
wsrep_node_name = 'tidb-galear1-1'
wsrep_node-address = '10.42.115.191'
binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0
mysql -A -uroot -pwdqdmm@r;
SHOW GLOBAL STATUS LIKE 'wsrep_%';
#查看几个集群节点
MariaDB [(none)]> SHOW STATUS LIKE 'wsrep_cluster_size';
#查看集群节点
MariaDB [(none)]> show global status like 'ws%';
可以看到集群正常使用。
注释:
wsrep_cluster_status为Primary,表示节点为主节点,正常读写。
wsrep_ready为ON,表示集群正常运行。
wsrep_cluster_size为3,表示集群有三个节点。