MGR单主模式部署

# 关闭防火墙 
systemctl  stop firewalld 
# 临时关闭
selinux setenforce 0 

 hostnamectl  set-hostname mgr_node1  
 hostnamectl  set-hostname mgr_node2  
 hostnamectl  set-hostname mgr_node3 

cat >> /etc/hosts <<EOF 
192.168.136.11 mgr_node1 
192.168.136.12 mgr_node2 
192.168.136.13 mgr_node3 
EOF 

# 时间同步 
yum install ntpdate -y 
ntpdate time.windows.com 

链接：https://pan.baidu.com/s/10ctZd1sZurlmi6yhE0TX_Q  提取码：m9e7  
链接：https://pan.baidu.com/s/15xVbZ5tLXyf87s4AMCH4eA  提取码：vn8f  

#解压 
tar -xvf mysql-8.0.24-1.el7.x86_64.rpm-bundle.tar 
#yum包安装 
rpm -ivh mysql-community-* --nodeps --force 
---------------------------------------------------- 
#二进制安装 （本文采用）
scp mysql-8.0.24-el7-x86_64.tar.gz 192.168.136.12:~ 
groupadd mysql 
useradd -r -g mysql mysql 
mkdir -pv  /data/{data,log,temp} 
chown -R mysql:mysql /data 
mkdir /usr/local/mysql 
tar -zxvf mysql-8.0.24-el7-x86_64.tar.gz  
mv mysql-8.0.24-el7-x86_64/* /usr/local/mysql/ 
cd /usr/local/mysql/bin 
ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql 
ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql  

# 创建存放数据库初始化信息的目录 
mkdir -pv  /data/{data,log,temp} 
# 修改数据目录属主属组 
chown -R mysql:mysql /data 
# 初始化数据库,设置默认密码为空 
./mysqld --initialize-insecure --datadir=/data/data --user=mysql 
# 修改数据目录属主属组 
chown -R mysql:mysql /data 

tree /data/ -L 1 
[root@mgr_node1 ~]# tree /data/ -L 1 
/data/ 
├── data    # 存放MySQL数据信息 
├── log     # 存放MySQL产生的错误日志，二进制日志信息 
└── temp    # 存放MySQL的一些临时文件，比如pid,sock文件

vim /etc/my.cnf 

[mysqld]
user=mysql
port=3306
datadir=/data/data
log-error=/data/log/err.log
pid-file=/data/temp/mysqld.pid
socket=/data/temp/mysql.sock
symbolic-links=0
#忘记密码时使用
#skip-grant-tables
#设置协议认证方式(重点啊)
default_authentication_plugin=mysql_native_password
​
[client]
socket=/data/temp/mysql.sock

cd /usr/local/mysql/bin/  
./mysqld --initialize-insecure --datadir=/data/data --user=mysql  
./mysqld  --defaults-file=/etc/my.cnf --daemonize  
#修改root密码，执行命令之后输入您要设置的root密码 
mysql -u root -p 
mysql>set password for root@localhost ='tj123456'; 
#开放远程连接 
mysql>use mysql; 
mysql>update user set user.Host='%' where user.User='root'; 
mysql> flush privileges; 
#确保navicat可以连接 
mysql>ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'tj123456'; 
mysql> flush privileges;   

# 执行后输入密码（cnemc.cn）tj123456
[root@localhost repo.mysql.com]# mysql -uroot -p -e "SELECT UUID()" 
Enter password: 
+--------------------------------------+ 
| UUID()                               | 
+--------------------------------------+ 
| 7fdbce46-aa47-11eb-9363-0050568f03a0 |
+--------------------------------------+  

vim /etc/my.cnf 

[mysqld]
user=mysql
port=3306
datadir=/data/data
log-error=/data/log/err.log
pid-file=/data/temp/mysqld.pid
socket=/data/temp/mysql.sock
symbolic-links=0
disabled_storage_engines="MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY"
​
server_id=101
gtid_mode=ON
enforce_gtid_consistency=ON
binlog_checksum=NONE
master_info_repository=TABLE
relay_log_info_repository=TABLE
log_slave_updates=ON
log_bin=/data/log/binlog
binlog_format=ROW
transaction_write_set_extraction=XXHASH64
​
#忘记密码时使用
#skip-grant-tables
#设置协议认证方式(重点啊)
default_authentication_plugin=mysql_native_password
​
plugin_load_add='group_replication.so'
​
loose-group_replication_group_name="d6dc0864-ae46-11eb-ab0e-0050568f03a0"
#配置 group_replication_start_on_boot 变量以off，指示插件在服务器启动时不自动启动操作。这在设置组复制时非常重要，因为它可以确保您可以在手动启动插件之前配置服务器。一旦配置了成员，就可以设置on以便在服务器启动时自动启动组复制
loose-group_replication_start_on_boot=off
loose-group_replication_local_address= "mgr_node1:33061"
loose-group_replication_group_seeds= "mgr_node1:33061,mgr_node2:33061,mgr_node3:33061"
loose-group_replication_bootstrap_group=off
​
[client]
socket=/data/temp/mysql.sock

# 关闭数据库，执行后输入root密码 
./mysqladmin  -uroot -p shutdown 
# 启动数据库 
./mysqld  --defaults-file=/etc/my.cnf --daemonize 

# 登陆数据库 
mysql -uroot -ptj123456 

# 创建MGR内部消息互通的用户
SET SQL_LOG_BIN=0; 
CREATE USER mgr_user@'%' IDENTIFIED WITH mysql_native_password BY 'mgr@123'; 
GRANT BACKUP_ADMIN ON *.* TO mgr_user@'%'; GRANT REPLICATION SLAVE ON *.* TO mgr_user@'%'; 
FLUSH PRIVILEGES; 
SET SQL_LOG_BIN=1; 

# 安装MGR插件
INSTALL PLUGIN group_replication SONAME 'group_replication.so'; 
# 检查是否成功安装 
SHOW PLUGINS ; 

#构建 group replication 集群
CHANGE REPLICATION SOURCE TO SOURCE_USER='mgr_user', SOURCE_PASSWORD='mgr@123' FOR CHANNEL 'group_replication_recovery'; 
# 使用当前数据库节点引导组,一个组内只有一个节点能引导 
# 不允许组内多次引导，这将导致产生两个相同名称的不同组 
SET GLOBAL group_replication_bootstrap_group=ON; 
START GROUP_REPLICATION USER='mgr_user', PASSWORD='mgr@123'; 
SET GLOBAL group_replication_bootstrap_group=OFF; 

SELECT * FROM performance_schema.replication_group_members\G 
​
SELECT * FROM performance_schema.replication_group_members; 

CREATE DATABASE test; 
USE test; 
CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT NOT NULL); 
INSERT INTO t1 VALUES (1, 'Luis'); 

SELECT * FROM t1; 
+----+------+ | c1 | c2   | +----+------+ |  1 | Luis | +----+------+  SHOW BINLOG EVENTS; +---------------+------+----------------+-----------+-------------+----------------------------------------------------------------------------------+ | Log_name      | Pos  | Event_type     | Server_id | End_log_pos | Info                                                                             | +---------------+------+----------------+-----------+-------------+----------------------------------------------------------------------------------+ | binlog.000001 |    4 | Format_desc    |       101 |         125 | Server ver: 8.0.24, Binlog ver: 4                                                | | binlog.000001 |  125 | Previous_gtids |       101 |         152 |  

scp /etc/my.cnf 192.168.136.12:/etc/my.cnf 
scp /etc/my.cnf 192.168.136.13:/etc/my.cnf 

# 初始化数据库,设置默认密码为空 
cd /usr/local/mysql/bin/ 
./mysqld --initialize-insecure --datadir=/data/data --user=mysql 
./mysqld  --defaults-file=/etc/my.cnf --daemonize 
#设置密码 
mysql -u root -p 
mysql>set password for root@localhost ='tj123456'; 
#开放远程连接 
mysql>use mysql; 
mysql>update user set user.Host='%' where user.User='root'; 
mysql> flush privileges; 
#确保navicat可以连接 
mysql>ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'tj123456'; 
mysql>flush privileges; 

#创建MGR内部消息互通的用户
mgr_user SET SQL_LOG_BIN=0; 
CREATE USER mgr_user@'%' IDENTIFIED WITH mysql_native_password BY 'mgr@123'; 
GRANT REPLICATION SLAVE ON *.* TO mgr_user@'%'; 
GRANT BACKUP_ADMIN ON *.* TO mgr_user@'%'; 
FLUSH PRIVILEGES; 
SET SQL_LOG_BIN=1; 

# 安装MGR插件
INSTALL PLUGIN group_replication SONAME 'group_replication.so'; 
# 加入组复制 
reset master; 
CHANGE REPLICATION SOURCE TO SOURCE_USER='mgr_user', SOURCE_PASSWORD='mgr@123' FOR CHANNEL 'group_replication_recovery'; 
START GROUP_REPLICATION USER='mgr_user', PASSWORD='mgr@123'; 

SELECT * FROM performance_schema.replication_group_members; 

mysql> SHOW DATABASES LIKE 'test'; 
+-----------------+ | Database (test) | +-----------------+ | test            | +-----------------+  
mysql> SELECT * FROM test.t1; 
+----+------+ | c1 | c2   | +----+------+ |  1 | Luis | +----+------+  
mysql> SHOW BINLOG EVENTS; 

pkill mysql 

vim /etc/systemd/system/mysqld.service 

[Unit] 
Description=MySQL Server 
Documentation=man:mysqld(8) 
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html 
After=network.target 
After=syslog.target 
[Install] 
WantedBy=multi-user.target 
[Service] 
User=mysql 
Group=mysql 
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf 
LimitNOFILE = 5000 
systemctl  start mysqld 

echo 'export PATH=/usr/local/mysql/bin:$PATH' >> /etc/profile 
​
source /etc/profile