Plugin group_replication reported: '[GCS] Connection attempt from IP address ::ffff:10.57.19....

2019/12/05 17:41
阅读数 52

Plugin group_replication reported: '[GCS] Connection attempt from IP address ::ffff:10.57.19.100 refused. Address is not in the IP whitelist.'

版本:8.0.18-commercial MySQL Enterprise Server

背景:跨机房搭建MGR 错误:异地机房CHANGE MASTER 后,START GROUP_REPLICATION 后,报如下错误,说是找不到白名单。

日志:

2019-10-09T14:35:32.591140+08:00 53 [System] [MY-010597] [Repl] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2019-10-09T14:36:06.768370+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connection attempt from IP address ::ffff:10.57.19.100 refused. Address is not in the IP whitelist.'
2019-10-09T14:36:06.867763+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connection attempt from IP address ::ffff:10.57.19.100 refused. Address is not in the IP whitelist.'
2019-10-09T14:36:06.967265+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connection attempt from IP address ::ffff:10.57.19.100 refused. Address is not in the IP whitelist.'
2019-10-09T14:36:07.066621+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connection attempt from IP address ::ffff:10.57.19.100 refused. Address is not in the IP whitelist.'
2019-10-09T14:36:07.166006+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connection attempt from IP address ::ffff:10.57.19.100 refused. Address is not in the IP whitelist.'
2019-10-09T14:36:07.265440+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connection attempt from IP address ::ffff:10.57.19.100 refused. Address is not in the IP whitelist.'
2019-10-09T14:36:07.382907+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connection attempt from IP address ::ffff:10.57.19.100 refused. Address is not in the IP whitelist.'
2019-10-09T14:36:07.482255+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connection attempt from IP address ::ffff:10.57.19.100 refused. Address is not in the IP whitelist.'
2019-10-09T14:36:07.582483+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connection attempt from IP address ::ffff:10.57.19.100 refused. Address is not in the IP whitelist.'
2019-10-09T14:36:07.739480+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Connection attempt from IP address ::ffff:10.57.19.100 refused. Address is not in the IP whitelist.'
2019-10-09T14:37:02.567084+08:00 0 [Warning] [MY-011499] [Repl] Plugin group_replication reported: 'Members removed from the group: dbmspredb304:1521'
2019-10-09T15:03:13.691845+08:00 0 [Warning] [MY-011499] [Repl] Plugin group_replication reported: 'Members removed from the group: dbmspredb304:1521'
2019-10-09T15:05:50.623489+08:00 0 [Warning] [MY-011499] [Repl] Plugin group_replication reported: 'Members removed from the group: dbmspredb304:1521'

解决:搭建MGR过程中,涉及到了 Group Replication IP Address Whitelisting,默认情况下,是无法让本地网络外的连接的访问的,所以在跨机器、网段、机房的情况下,需要设置group_replication_ip_whitelist

例如:

mysql> STOP GROUP_REPLICATION;
mysql> SET GLOBAL group_replication_ip_whitelist="10.57.19.100,10.243.194.191,10.243.194.192";
mysql> START GROUP_REPLICATION;
展开阅读全文
打赏
0
0 收藏
分享
加载中
更多评论
打赏
0 评论
0 收藏
0
分享
返回顶部
顶部