MYSQL搭建

#卸载mysql
yum remove mysql mysql-server mysql-libs mysql-server;
find / -name mysql|xargs rm -rf
rpm -qa|grep mysql|xargs yum -y remove

下载

wget https://repo.mysql.com/mysql80-community-release-el7-3.noarch.rpm

确认可以安装的版本# 安装仓库

yum -y install mysql80-community-release-el7-3.noarch.rpm

#yum list | grep mysql | grep server
yum -y install mysql-community-server.x86_64 8.0.21-1.el7 mysql80-community

安装 MySQL

yum -y install mysql-community-server

#成功安装之后重启mysql服务
service mysqld restart

修改密码，初始密码在 /var/log/mysqld.log

[root@D-WY-DEV8 ~]# grep password /var/log/mysqld.log
root@localhost: dIc%e:ptD54?
[root@D-WY-DEV8 ~]# mysql -u root -p

修改mysql密码，要求大小写字母，符号，不低于8位数
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘@Qwer6666’;
进行远程访问的授权
create user ‘root’@’%’ identified with mysql_native_password by ‘@Qwer6666’;
grant all privileges on . to ‘root’@’%’ with grant option;
flush privileges;

设置对外端口
iptables -A INPUT -p tcp --dport 80 -j ACCEPT;
iptables -A INPUT -p tcp --dport 3306 -j ACCEPT;
iptables -A INPUT -p tcp --dport 33061 -j ACCEPT;
iptables -F

开放通讯端口（推荐）
yum install -y policycoreutils-python
semanage port -a -t mysqld_port_t -p tcp 33061

修改my.cnf设置
server_id=3
gtid_mode=ON
enforce_gtid_consistency=ON
binlog_checksum=NONE

log_bin=binlog
log_slave_updates=ON
binlog_format=ROW
master_info_repository=TABLE
relay_log_info_repository=TABLE

transaction_write_set_extraction=XXHASH64
loose-group_replication_group_name=“aadaaaaa-adda-adda-aaaa-aaaaaaddaaaa”
loose-group_replication_start_on_boot=OFF
group_replication_recovery_get_public_key=ON
loose-group_replication_local_address= “172.20.130.138:33061”
loose-group_replication_group_seeds= “172.20.130.129:33061,172.20.130.132:33061,172.20.130.138:33061”
loose-group_replication_bootstrap_group=OFF

report-host=172.20.130.138

设置复制账号

SET SQL_LOG_BIN=0;
CREATE USER repl@’%’ IDENTIFIED BY ‘@Qwer6666’;
GRANT REPLICATION SLAVE ON . TO repl@’%’;
FLUSH PRIVILEGES;
SET SQL_LOG_BIN=1;
CHANGE MASTER TO MASTER_USER=‘repl’, MASTER_PASSWORD=’@Qwer6666’ FOR CHANNEL ‘group_replication_recovery’;

安装插件

install PLUGIN group_replication SONAME ‘group_replication.so’;
show plugins;

#多节点配置好了之后进行主节点操作
SET GLOBAL group_replication_bootstrap_group=ON;
START GROUP_REPLICATION;
SET GLOBAL group_replication_bootstrap_group=OFF;

#多节点配置好了之后进行从节点操作
SET @@GLOBAL.read_only = ON;
START GROUP_REPLICATION;

查看MGR组信息
SELECT * FROM performance_schema.replication_group_members;