RedHat 7.9安装MySQL 8.0 MGR.doc
50墨值下载
RedHat 7.9
安装
MySQL 8.0 MGR
目录
目录
.....................................................................................................................................................1
一、环境信息
.....................................................................................................................................3
二、各主机安装
MySQL
单实例
......................................................................................................4
1.
添加
hosts................................................................................................................................4
2.
关闭和禁用防火墙
.................................................................................................................4
3.
删除
mariadb-libs....................................................................................................................4
4.
配置环境变量
.........................................................................................................................4
5.
创建组和用户
.........................................................................................................................5
6.
关闭
selinux(
修改
SELINUX=disabled)................................................................................5
7.
解压二进制安装包
.................................................................................................................5
8.
创建数据目录
.........................................................................................................................6
9.
配置
my.cnf.............................................................................................................................6
10.
初始化
mysql........................................................................................................................7
11.
查看初始密码
.......................................................................................................................7
12.
配置开机自启动脚本
...........................................................................................................7
13.
启动服务
...............................................................................................................................7
14.
登录并修改初始密码
...........................................................................................................8
三、配置
MGR(
单主模式
)................................................................................................................9
1.
修改
my.cnf
，在
[mysqld]
下，新增如下配置
......................................................................9
2.
优化
innodb_buffer_pool_size..............................................................................................12
3.
重启数据库服务
(mgr01,mgr02,mgr03)..............................................................................13
4.
创建复制组的用户
(mgr01,mgr02,mgr03)..........................................................................13
5.
配置频道
(mgr01,mgr02,mgr03)...........................................................................................13
6.
查看复制组插件是否装载
(mgr01,mgr02,mgr03)..............................................................13
7.
启动复制组（引导）
...........................................................................................................14
8.
查看复制组
...........................................................................................................................14
9.
其他节点启动复制组
...........................................................................................................14
10.
最终状态
.............................................................................................................................14
11.
指定主节点
.........................................................................................................................14
四、配置
MGR(
多主模式
)..............................................................................................................16
1.
修改参数关闭单主模式
(mgr01,mgr02,mgr03)..................................................................16
2.
启动多组复制
.......................................................................................................................16
3.
检查
MGR
多主模式
............................................................................................................17
五、单主多主模式切换
...................................................................................................................18
1.
单主切多主
...........................................................................................................................18
2.
多主切单主
...........................................................................................................................18
六、
MySQL Group Replication
节点状态
......................................................................................19
七、配置
MySQL Router
实现高可用及读写分离
........................................................................20
1.
应用服务器安装
MySQL Router.........................................................................................20
2.
更改配置
...............................................................................................................................20
3.
启动
MySQL Router.............................................................................................................20
4.
测试连接
...............................................................................................................................21
5.
高可用验证
...........................................................................................................................21
八、节点宕机恢复
...........................................................................................................................24
1.
主节点宕机恢复
...................................................................................................................24
2.
从节点宕机恢复
...................................................................................................................24
九、常见故障处理
...........................................................................................................................25
1.
少数派成员失联时
...............................................................................................................25
2.
多数派成员失联时
...............................................................................................................25
十、监控常用相关表
.......................................................................................................................27
1. replication_group_member_stats..........................................................................................27
2. replication_group_members..................................................................................................28
3. replication_connection_status...............................................................................................29
4. replication_applier_status.....................................................................................................31
of 31
50墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论