导航：首页 > 数据库 >

MySQL5.7安装及配置MGR教程

发表于：2026-10-31 作者：千家信息网编辑

千家信息网最后更新 2026年10月31日，本文主要给大家简单讲讲MySQL5.7安装及配置MGR教程，相关专业术语大家可以上网查查或者找一些相关书籍补充一下，这里就不涉猎了，我们就直奔主题吧，希望MySQL5.7安装及配置MGR教程这篇文章可

千家信息网最后更新 2026年10月31日MySQL5.7安装及配置MGR教程

本文主要给大家简单讲讲MySQL5.7安装及配置MGR教程，相关专业术语大家可以上网查查或者找一些相关书籍补充一下，这里就不涉猎了，我们就直奔主题吧，希望MySQL5.7安装及配置MGR教程这篇文章可以给大家带来一些实际帮助。

一、云服务器规划

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教程就先给大家讲到这里，对于其它相关问题大家想要了解的可以持续关注我们的行业资讯。我们的板块内容每天都会捕捉一些行业新闻及专业知识分享给大家的。

很赞哦！

配置教程备份插件专业行业专业知识主题书籍内容实际密码成员文件新闻服务器术语板块状态知识数据库的安全要保护哪些东西数据库安全各自的含义是什么生产安全数据库录入数据库的安全性及管理数据库安全策略包含哪些海淀数据库安全审计系统建立农村房屋安全信息数据库易用的数据库客户端支持安全管理连接数据库失败ssl安全错误数据库的锁怎样保障安全北京路客互联网科技有限公司互联网科技有限公司经营范围互联网最新的科技有限公司互联网科技开发公司互联网科技金融科技服务与互联网齐家互联网科技互联网科技排名火传媒上海互联网科技深圳卡尔迅互联网科技有限公司怎么样恒银科技与互联网金融欧洲十大科技互联网公司智腾互联网科技有限公司中国航天科技大学国际工业互联网阿大互联网科技有限公司江阴互联网智能科技产品进口东莞新华互联网科技学校世界互联网领先科技成果获奖互联网金融科技名词解释上海万顺科技互联网有限公司招聘 A股互联网金融科技公司互联网最新的科技有限公司互联网科技汛青海省互联网新科技江阴互联网智能科技产品进口互联网媒体平台算高科技产业民营互联网公司国防科技上海钢联属于互联网科技股吗图游互联网科技国产互联网科技公司

千家信息网

千家信息网

MySQL5.7安装及配置MGR教程

【DB究谈】浅谈对数据库隔离级别的理解

MySQL中如何使用NoSQL插件

相关文章