软件版本：
操作系统：CentOS 7.6
数据库：MySQL 8.0.19
虚拟机：VM Workstation 15 Pro
IP地址分配：
DB1 192.168.5.130:3306
DB2 192.168.5.130:3307
DB3 192.168.5.130:3308
1、安装MySQL
#依赖包
yum -y install libaio*
#解压软件
xz -d mysql-8.0.19-linux-glibc2.12-x86_64.tar.xz
tar -xvf mysql-8.0.19-linux-glibc2.12-x86_64.tar -C /usr/local
ln -s /usr/local/mysql-8.0.19-linux-glibc2.12-x86_64/ /usr/local/mysql
#创建用户
groupadd mysql
useradd -r -g mysql -s /bin/false mysql
#创建数据目录
mkdir -p /mysql_data/data/s{1..3}
chown mysql:mysql -R /mysql_data/data
chmod 750 -R /mysql_data/data
#初始化
/usr/local/mysql/bin/mysqld --initialize-insecure --basedir=/usr/local/mysql --datadir=/mysql_data/data/s1 --user=mysql /usr/local/mysql/bin/mysqld --initialize-insecure --basedir=/usr/local/mysql --datadir=/mysql_data/data/s2 --user=mysql /usr/local/mysql/bin/mysqld --initialize-insecure --basedir=/usr/local/mysql --datadir=/mysql_data/data/s3 --user=mysql
#my3306.cnf
#几乎默认参数，方便你们安装 [client] #user = root #password = xxxxx [mysqld] # basic settings # user = mysql port = 3306 socket = mysql.sock basedir = /usr/local/mysql datadir = /mysql_data/data/s1 bind-address = 0.0.0.0 max_connections = 500 max_connect_errors = 1000 log_error = error.log pid-file = mysql.pid server-id = 3306130 log_bin = binlog binlog_format = row sync_binlog = 1 log_timestamps=SYSTEM interactive_timeout = 28800 wait_timeout = 28800 default_authentication_plugin=mysql_native_password transaction_isolation = READ-COMMITTED binlog_rows_query_log_events = 1 # group repl settings # gtid_mode=ON enforce_gtid_consistency=ON binlog_checksum=NONE plugin_load_add='group_replication.so' group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa" group_replication_start_on_boot=off group_replication_local_address= "192.168.5.130:33061" group_replication_group_seeds= "192.168.5.130:33061,192.168.5.130:33062,192.168.5.130:33063" group_replication_bootstrap_group=off group_replication_unreachable_majority_timeout=60 group_replication_single_primary_mode = 1 #group_replication_enforce_update_everywhere_checks = 1 # innodb settings # innodb_buffer_pool_size = 128M innodb_buffer_pool_instances = 2 innodb_flush_log_at_trx_commit = 1
#启动MySQL
/usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my3306.cnf --user=mysql & /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my3307.cnf --user=mysql & /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my3308.cnf --user=mysql &
2、MGR配置
#记住哦 my3306.cnf，my3307.cnf、my3308.cnf的端口与server id差异哦，
group_replication_local_address 这里要改的
plugin_load_add='group_replication.so' group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa" group_replication_start_on_boot=off group_replication_local_address= "192.168.5.130:33061" group_replication_group_seeds= "192.168.5.130:33061,192.168.5.130:33062,192.168.5.130:33063" group_replication_bootstrap_group=off group_replication_unreachable_majority_timeout=60 group_replication_single_primary_mode = 1
3、主库执行(首次启动组的过程称为引导，只需要在其中一台服务器上执行一次，此库即为主库)
CREATE USER repl@'%' IDENTIFIED BY 'mysqldb@1025';
GRANT REPLICATION SLAVE ON *.* TO repl@'%';
FLUSH PRIVILEGES;
CHANGE MASTER TO MASTER_USER='repl', MASTER_PASSWORD='mysqldb@1025' FOR CHANNEL 'group_replication_recovery';
INSTALL PLUGIN group_replication SONAME 'group_replication.so';
首次启动组的过程称为引导，只需要在一台服务器上执行一次，此库即为主库：
SET GLOBAL group_replication_bootstrap_group=ON;
START GROUP_REPLICATION;
SET GLOBAL group_replication_bootstrap_group=OFF;
#查询集群状态
SELECT * FROM performance_schema.replication_group_members;
4、从库执行：
CHANGE MASTER TO MASTER_USER='repl', MASTER_PASSWORD='mysqldb@1025' FOR CHANNEL 'group_replication_recovery';
START GROUP_REPLICATION;
#查询集群状态
SELECT * FROM performance_schema.replication_group_members;