189 8069 5689
本文主要给大家简单讲讲MySQL5.7安装及配置MGR教程，相关专业术语大家可以上网查查或者找一些相关书籍补充一下，这里就不涉猎了，我们就直奔主题吧，希望MySQL5.7安装及配置MGR教程这篇文章可以给大家带来一些实际帮助。
创新互联是专业的册亨网站建设公司，册亨接单;提供网站建设、网站设计,网页设计,网站设计,建网站,PHP网站建设等专业做网站服务;采用PHP框架,可快速的进行册亨网站开发网页制作和功能扩展;专业做搜索引擎喜爱的网站,专业的做网站团队,希望更多企业前来合作!
一、云服务器规划
mysql_mgr_01 192.168.10.223
mysql_mgr_02 192.168.10.224
mysql_mgr_03 192.168.10.225
二、配置文件
1. mysql_mgr_01
[root@mysql_mgr_01 tmp]# cat /etc/my.cnf
[mysqld]
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
server-id=330601
port = 3306
log_bin = /data/mysql/binlog/mysql_mgr01-bin
#expire_logs_days=10
explicit_defaults_for_timestamp=true
datadir=/data/mysql/data
socket=/data/mysql/run/mysql.sock
skip-external-locking
pid-file=/data/mysql/run/mysql.pid
innodb_file_per_table = on
#skip_name_resolve = on
character-set-server = utf8mb4
character-set-client-handshake = FALSE
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
slow_query_log = on
long_query_time = 2
slow_query_log_file = /data/mysql/slow_logs/mysql-slow.log
binlog_rows_query_log_events=ON
relay-log=/data/mysql/relaylog/mysql_mgr_01-relay-bin
#
# Replication configuration parameters
#
gtid_mode=ON
enforce_gtid_consistency=ON
master_info_repository=TABLE
relay_log_info_repository=TABLE
binlog_checksum=NONE
log_slave_updates=ON
binlog_format=ROW
#
# Group Replication configuration
#
transaction_write_set_extraction=XXHASH64
loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"
loose-group_replication_start_on_boot=off
loose-group_replication_local_address= "192.168.10.223:24901"
loose-group_replication_group_seeds= "192.168.10.223:24901,192.168.10.224:24902,192.168.10.225:24903"
loose-group_replication_bootstrap_group=off
group_replication_member_weight = 100
symbolic-links=0
[mysqld_safe]
log-error=/data/mysql/logs/mysql.log
pid-file=/data/mysql/run/mysql.pid
[mysql]
default-character-set = utf8mb4
socket=/data/mysql/run/mysql.sock
[client]
#default-character-set = utf8mb4
socket=/data/mysql/run/mysql.sock
2. mysql_mgr_02
[root@mysql_mgr_02 tmp]# cat /etc/my.cnf
[mysqld]
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
server-id=330602
port = 3306
log_bin = /data/mysql/binlog/mysql_mgr02-bin
#expire_logs_days=10
explicit_defaults_for_timestamp=true
datadir=/data/mysql/data
socket=/data/mysql/run/mysql.sock
skip-external-locking
pid-file=/data/mysql/run/mysql.pid
innodb_file_per_table = on
#skip_name_resolve = on
relay-log=/data/mysql/relaylog/mysql_mgr_02-relay-bin
character-set-server = utf8mb4
character-set-client-handshake = FALSE
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
slow_query_log = on
long_query_time = 2
slow_query_log_file = /data/mysql/slow_logs/mysql-slow.log
symbolic-links=0
#
# Replication configuration parameters
#
gtid_mode=ON
enforce_gtid_consistency=ON
master_info_repository=TABLE
relay_log_info_repository=TABLE
binlog_checksum=NONE
log_slave_updates=ON
binlog_format=ROW
#
# Group Replication configuration
#
transaction_write_set_extraction=XXHASH64
loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"
loose-group_replication_start_on_boot=off
loose-group_replication_local_address= "192.168.10.224:24902"
loose-group_replication_group_seeds= "192.168.10.223:24901,192.168.10.224:24902,192.168.10.225:24903"
loose-group_replication_bootstrap_group=off
group_replication_member_weight = 80
[mysqld_safe]
log-error=/data/mysql/logs/mysql.log
pid-file=/data/mysql/run/mysql.pid
[mysql]
default-character-set = utf8mb4
socket=/data/mysql/run/mysql.sock
[client]
#default-character-set = utf8mb4
socket=/data/mysql/run/mysql.sock
3. mysql_mgr_03
[root@mysql_mgr_03 tmp]# cat /etc/my.cnf
[mysqld]
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
server-id=330603
port = 3306
log_bin = /data/mysql/binlog/mysql_mgr03-bin
#expire_logs_days=10
explicit_defaults_for_timestamp=true
datadir=/data/mysql/data
socket=/data/mysql/run/mysql.sock
skip-external-locking
pid-file=/data/mysql/run/mysql.pid
innodb_file_per_table = on
#skip_name_resolve = on
relay-log=/data/mysql/relaylog/mysql_mgr_03-relay-bin
character-set-server = utf8mb4
character-set-client-handshake = FALSE
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
slow_query_log = on
long_query_time = 2
slow_query_log_file = /data/mysql/slow_logs/mysql-slow.log
symbolic-links=0
#
# Replication configuration parameters
#
gtid_mode=ON
enforce_gtid_consistency=ON
master_info_repository=TABLE
relay_log_info_repository=TABLE
binlog_checksum=NONE
log_slave_updates=ON
binlog_format=ROW
#
# Group Replication configuration
#
transaction_write_set_extraction=XXHASH64
loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"
loose-group_replication_start_on_boot=off
loose-group_replication_local_address= "192.168.10.225:24903"
loose-group_replication_group_seeds= "192.168.10.223:24901,192.168.10.224:24902,192.168.10.225:24903"
loose-group_replication_bootstrap_group=off
group_replication_member_weight = 90
[mysqld_safe]
log-error=/data/mysql/logs/mysql.log
pid-file=/data/mysql/run/mysql.pid
[mysql]
default-character-set = utf8mb4
socket=/data/mysql/run/mysql.sock
[client]
#default-character-set = utf8mb4
socket=/data/mysql/run/mysql.sock
三、MGR配置
1. mysql_mgr_01
[mysql_mgr_01]
#关闭SQL_LOG_BIN
SET SQL_LOG_BIN=0;
#创建组复制使用的帐号密码
CREATE USER rpl_user@'%' IDENTIFIED BY 'password';
GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%';
FLUSH PRIVILEGES;
#开启SQL_LOG_BIN
SET SQL_LOG_BIN=1;
#安装组复制插件group_replication.so
INSTALL PLUGIN group_replication SONAME 'group_replication.so';
CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='password' FOR CHANNEL 'group_replication_recovery';
#初始化主节点
SET GLOBAL group_replication_bootstrap_group=ON;
START GROUP_REPLICATION;
SET GLOBAL group_replication_bootstrap_group=OFF;
#查看组复制成员状态
SELECT * FROM performance_schema.replication_group_members;
#备份
mysqldump -uroot -p --all-databases --master-data=2 --single-transaction>/tmp/all.sql
2. mysql_mgr_02
[mysql_mgr_02]
#恢复备份
#安装组复制插件group_replication.so
INSTALL PLUGIN group_replication SONAME 'group_replication.so';
CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='password' FOR CHANNEL 'group_replication_recovery';
#启动组复制
START GROUP_REPLICATION;
3. mysql_mgr_03
[mysql_mgr_03]
#恢复备份
#安装组复制插件group_replication.so
INSTALL PLUGIN group_replication SONAME 'group_replication.so';
CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='password' FOR CHANNEL 'group_replication_recovery';
#启动组复制
START GROUP_REPLICATION;
MySQL5.7安装及配置MGR教程就先给大家讲到这里，对于其它相关问题大家想要了解的可以持续关注我们的行业资讯。我们的板块内容每天都会捕捉一些行业新闻及专业知识分享给大家的。