5.MGR组复制故障处理-IP没有在白名单中

最新推荐文章于 2023-06-06 13:01:03 发布

戒掉贪嗔痴(薛双奇)

最新推荐文章于 2023-06-06 13:01:03 发布

阅读量361

点赞数

分类专栏：数据库运维-MySQL 文章标签： tcp/ip mysql 数据库

本文链接：https://blog.csdn.net/weixin_43346403/article/details/128898167

版权

数据库运维-MySQL 专栏收录该内容

143 篇文章 7 订阅

订阅专栏

故障处理：
解决：搭建MGR过程中，涉及到了 Group Replication IP Address Whitelisting，默认情况下，
是无法让本地网络外的连接的访问的，所以在跨机器、网段、机房的情况下，需要设置
group_replication_ip_whitelist
例如：
select * from performance_schema.replication_group_members;
mysql> STOP GROUP_REPLICATION;
mysql> SET GLOBAL group_replication_ip_whitelist="192.168.1.51,192.168.1.52,192.168.1.53";
mysql> START GROUP_REPLICATION;

很多警告：
2022-01-25T08:00:58.132013Z 0 [Warning] Plugin group_replication reported: '[GCS] Unable to handle socket descriptor, therefore refusing connection.'
2022-01-25T08:00:58.132119Z 0 [Warning] Plugin group_replication reported: '[GCS] Invalid IPv4/IPv6 address. Refusing connection!'
2022-01-25T08:00:58.132138Z 0 [Warning] Plugin group_replication reported: '[GCS] Unable to handle socket descriptor, therefore refusing connection.'
2022-01-25T08:00:58.132153Z 0 [Warning] Plugin group_replication reported: '[GCS] Connection attempt from IP address 0.0.0.0 refused. Address is not in the IP whitelist.'

mysql> STOP GROUP_REPLICATION;
mysql> SET GLOBAL group_replication_ip_whitelist="192.168.1.51,192.168.1.52,192.168.1.53,0.0.0.0";
mysql> START GROUP_REPLICATION;

set global group_replication_bootstrap_group=off;
stop group_replication;
start group_replication;
select * from performance_schema.replication_group_members;