0、环境（三节点主从复制）
b1(master): 172.06.215.101
b2(slave): 172.06.215.102
b3(slave): 172.06.215.103
服务IP： 172.06.215.199
注：b1 b2 b3 分别为主机名
1、MySQL5.7增强半同步配置
基于GTID增强半同步的主从复制架构
-
参数设置：（b2、b3操作此步）
- set global super_read_only=0;
- set global read_only=0;
-
安装插件：（b1、b2、b3操作此步）
INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';
INSTALL PLUGIN rpl_semi_sync_slave SONAME 'semisync_slave.so';
set global rpl_semi_sync_master_enabled=1;
set global rpl_semi_sync_master_timeout=2147483648;
set global rpl_semi_sync_slave_enabled=1;
2、系统配置
-
三台主机的mysql账号指定shell 为/bin/bash ，并改密码（三台机密码改成一样）：
-
chsh mysql
15871587738942.jpg passwd mysql
-
mysql环境变量： 从其它普通账号复制 .bash* 到mysql 用户家目录
cd /usr/local/mysql
cp /home/xp/.bash* .
chown mysql:mysql .bash*
-
添加mysql账号的sudo权限
visudomysql ALL=(ALL) NOPASSWD: sbin/ip
-
-
三台主机做mysql账号ssh互信(db1 操作)
- su - mysql
- ssh-keygen
- cd .ssh
- cat id_rsa.pub >authorized_keys
- chmod 600 authorized_keys
- cd ~
- scp .ssh 172.16.215.102:~/
- scp .ssh 172.16.215.103:~/
3、安装golang(db1 db2 db3操作)
下载 wget https://studygolang.com/dl/golang/go1.14.2.linux-amd64.tar.gz
解压：tar -xzvf go1.14.2.linux-amd64.tar.gz /usr/local/
-
设置环境变量：vim /etc/bashrc 添加以下变量
export GOPATH=/usr/local/go export GOBIN=$GOPATH/bin export PATH=$PATH:/usr/local/go/bin
4、安装xtrabackup
yum localinstall percona-xtrabackup-80-8.0.4-1.el7.x86_64.rpm
yum install libdbi-dbd-mysql
5、安装xenon(b1 b2 b3操作)
git安装及下载xenon:
yum install -y git
mkdir /mygit
cd /mygit
git init
git clone https://github.com/radondb/xenon.git-
安装：
cd xenon
make
mkdir /data/xenon -p
cp -r bin xenon/
cp -r conf/xenon-simple.conf.json xenon/xenon.json
echo "/etc/xenon/xenon.json" >xenon/bin/config.path
mv xenon/xenon.json /etc/xenon/chown mysql:mysql /data/xenon -R
chown mysql:mysql /etc/xenon -R
6、所有机器配置xenon,下面以b1为例，其它机器，只需改成本机IP即可。
- vim /etc/xenon/xenon.json
"server":
{
"endpoint":"172.16.215.101:8801"
},
"raft":
{
"meta-datadir":"raft.meta",
"heartbeat-timeout":1000,
"election-timeout":3000,
"leader-start-command":"sudo /usr/sbin/ip a a 172.16.215.199/16 dev ens33 && arping -c 3 -A 172.16.215.199 -I ens33",
"leader-stop-command":"sudo /usr/sbin/ip a d 172.16.215.199/16 dev ens33"
},
"mysql":
{
"admin":"root",
"passwd":"a",
"host":"127.0.0.1",
"port":3306,
"basedir":"/usr/local/mysql",
"defaults-file":"/data/mysql/mysql3306/mysql3306.cnf",
"ping-timeout":1000,
"master-sysvars":"super_read_only=0;read_only=0;sync_binlog=default;innodb_flush_log_at_trx_commit=default",
"slave-sysvars": "super_read_only=1;read_only=1;sync_binlog=1000;innodb_flush_log_at_trx_commit=2"
},
"replication":
{
"user":"repl",
"passwd":"a"
},
"backup":
{
"ssh-host":"172.16.215.101",
"ssh-user":"mysql",
"ssh-passwd":"mysql",
"ssh-port":22,
"backupdir":"/data/mysql/mysql3306/data",
"xtrabackup-bindir":"/usr/bin",
"backup-iops-limits":100000,
"backup-use-memory": "2GB",
"backup-parallel": 2
},
"rpc":
{
"request-timeout":500
},
"log":
{
"level":"INFO"
}
}
7、开启xenon并配置集群（b1 b2 b3 操作）
如果mysql 不是以mysqld_safe方式启动，关库；
启动xenon:
cd /data/xenon/bin
./xenon -c /etc/xenon/xenon.json >./xenon.log 2>&1 &添加节点：
./xenoncli cluster add 172.16.215.101:8801,172.16.215.102:8801,172.16.215.103:8801-
查看集群状态
./xenoncli cluster status
15871651127172.jpg
上图状态为成功！
有疑问加站长微信联系（非本文作者）
