mysql mgr节点无法连接_mysql mgr 一节点状态始终是RECOVERING，但是同步正常 - 墨天轮问答...

mgrb03 参数：

group_replication_local_address= "172.1.1.226:33061"

group_replication_group_seeds= "172.20.3.13:33081,172.20.3.11:33081,172.1.1.226:33061"

mgrb03 netstat结果：复制还连接的是SECONDARY角色的mgrb01

tcp 0 1 172.1.1.226:49624 172.16.0.10:33081 SYN_SENT

tcp 0 0 172.1.1.226:33976 172.1.1.226:33061 ESTABLISHED

tcp 0 0 172.1.1.226:53268 172.20.3.13:3308 ESTABLISHED

tcp 0 1 172.1.1.226:48736 172.30.0.10:33081 SYN_SENT

tcp6 0 0 172.1.1.226:33061 172.1.1.226:33976 ESTABLISHED

tcp6 0 0 172.1.1.226:33061 172.20.3.11:51952 ESTABLISHED

tcp6 0 0 172.1.1.226:3306 172.1.1.145:39326 ESTABLISHED

tcp6 0 0 172.1.1.226:33061 172.18.2.10:51752 ESTABLISHED

docker容器网络映射关系如下：

172.16.0.10:33081 --> 172.20.3.11:33081

172.30.0.10:33081 --> 172.20.3.13:33081

172.18.2.10跟172.20.3.13在同一个机器，映射的0.0.0.0:33081

mgrb01参数:容器与容器之间用的容器内部ip通信

group_replication_local_address= "172.30.0.10:33081"

group_replication_group_seeds= "172.30.0.10:33081,172.16.0.10:33081,172.1.1.226:33061"

mgrb02参数:容器与容器之间用的容器内部ip通信

group_replication_local_address= "172.16.0.10:33081"

group_replication_group_seeds= "172.30.0.10:33081,172.16.0.10:33081,172.1.1.226:33061"