MariaDB主主集群配置

机器1:192.168.1.101
机器2:192.168.1.102
数据库版本：MariaDB-10.0.34
关系：主主集群
搭建步骤：
1、修改yum源文件
vim /etc/yum.repos.d/mariadb.repo
[mariadb]
name = MariaDB
baseurl =http://mirrors.ustc.edu.cn/mariadb/yum/10.0.34/centos7-amd64/
gpgcheck=0
2、下载安装
yum install MariaDB-Galera-server （每台都要执行）
3、配置galera-server
[root@dn01 ~]# vim /etc/my.cnf.d/server.cnf
[mysqld]
transaction-isolation = READ-COMMITTED
key_buffer = 16M
key_buffer_size = 32M
max_allowed_packet = 32M
thread_stack = 256K
thread_cache_size = 64
query_cache_limit = 8M
query_cache_size = 64M
query_cache_type = 1
max_connections = 550
log_bin=/var/lib/mysql/mysql_binary_log
binlog_format = row
read_buffer_size = 2M
read_rnd_buffer_size = 16M
sort_buffer_size = 8M
join_buffer_size = 8M

InnoDB settings

innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 64M
innodb_buffer_pool_size = 4G
innodb_thread_concurrency = 8
innodb_flush_method = O_DIRECT
innodb_log_file_size = 512M
[galera]

Mandatory settings

wsrep_provider=/usr/lib64/galera/libgalera_smm.so
wsrep_cluster_address=“gcomm://192.168.1.101,192.168.1.102”
wsrep_provider_options=“gcache.size=1G”
wsrep_cluster_name=‘testcluster’
wsrep_node_name=192.168.1.101
wsrep_sst_method=rsync
wsrep_sst_auth=sst:password
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0
[embedded]
[mariadb]
[mariadb-10.0]
（注意wsrep_node_name根据节点地址修改）
4、初始化Glaera Cluster（选择一个节点即可）
/etc/rc.d/init.d/mysql start --wsrep-new-cluster
5、查看端口监控状态
netstat -plantu | grep mysqld
结果为：
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 97864/mysqld
tcp 0 0 0.0.0.0:4567 0.0.0.0:* LISTEN 97864/mysqld
6、验证集群状态
进入数据库
mysql -uroot -p
查看是否启用galera
show status like “wsrep_ready”;
±--------------±------+
| Variable_name | Value |
±--------------±------+
| wsrep_ready | ON |
±--------------±------+
查看集群机器数量
show status like “wsrep_cluster_size”;
±-------------------±------+
| Variable_name | Value |
±-------------------±------+
| wsrep_cluster_size | 2 |
±-------------------±------+
查看集群连接主机
show status like “wsrep_incoming_addresses”;
±-------------------------±------------------------------------+
| Variable_name | Value |
±-------------------------±------------------------------------+
| wsrep_incoming_addresses | 192.168.1.101:3306,192.168.1.102:3306 |
±-------------------------±------------------------------------+
7、测试
create database test;
show databases;
±-------------------+
| Database |
±-------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
±-------------------+
去其他机器上查看
±-------------------+
| Database |
±-------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
±-------------------+
成功同步！