ubuntu 16.04 上的 Mysql master 到 master 组复制

Question

我使用以下链接将 mysql master 配置为主控组复制 https://www.digitalocean.com/community/tutorials/how-to-configure-mysql-group-replication-on-ubuntu-16-04

我使用上面的链接连接了两个不同的服务器。第一个服务器已连接。但第二个服务器未连接，出现错误

我使用mysql> START GROUP_REPLICATION;此命令用于配置第二个服务器。但我收到以下错误日志

2018-02-07T11:58:01.707051Z 0 [Note] Plugin group_replication reported: 'connecting to 11.0.0.35 33061'
2018-02-07T11:58:11.715442Z 0 [Note] Plugin group_replication reported: 'Timed out while waiting for connection to be established! Cancelling connection attempt. (socket= 78, error=0)'
2018-02-07T11:58:11.715470Z 0 [Warning] Plugin group_replication reported: 'select - Timeout! Cancelling connection...'
2018-02-07T11:58:11.715479Z 0 [Note] Plugin group_replication reported: 'Connecting socket to address 11.0.0.35 in port 33061 failed with error 115 - Operation now in progress.'
2018-02-07T11:58:11.715515Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 11.0.0.35:33061 on local port: 33061.'
2018-02-07T11:58:11.715524Z 0 [Note] Plugin group_replication reported: 'connecting to 11.0.0.35 33061'
2018-02-07T11:58:21.725696Z 0 [Note] Plugin group_replication reported: 'Timed out while waiting for connection to be established! Cancelling connection attempt. (socket= 78, error=0)'
2018-02-07T11:58:21.726394Z 0 [Warning] Plugin group_replication reported: 'select - Timeout! Cancelling connection...'
2018-02-07T11:58:21.726406Z 0 [Note] Plugin group_replication reported: 'Connecting socket to address 11.0.0.35 in port 33061 failed with error 115 - Operation now in progress.'
2018-02-07T11:58:21.726442Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 11.0.0.35:33061 on local port: 33061.'
2018-02-07T11:58:21.726451Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error connecting to all peers. Member join failed. Local port: 33061'
2018-02-07T11:58:21.726558Z 0 [Note] Plugin group_replication reported: 'state 4338 action xa_terminate'
2018-02-07T11:58:21.726578Z 0 [Note] Plugin group_replication reported: 'new state x_start'
2018-02-07T11:58:21.726582Z 0 [Note] Plugin group_replication reported: 'state 4338 action xa_exit'
2018-02-07T11:58:21.728254Z 0 [Note] Plugin group_replication reported: 'Exiting xcom thread'
2018-02-07T11:58:21.728263Z 0 [Note] Plugin group_replication reported: 'new state x_start'
2018-02-07T11:58:21.728310Z 0 [Warning] Plugin group_replication reported: 'read failed'
2018-02-07T11:58:21.736534Z 0 [ERROR] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 33061'
2018-02-07T11:58:21.736559Z 0 [Note] Plugin group_replication reported: 'Destroying SSL'
2018-02-07T11:58:21.736565Z 0 [Note] Plugin group_replication reported: 'Success destroying SSL'
2018-02-07T11:58:21.736713Z 2 [Note] Plugin group_replication reported: 'auto_increment_increment is reset to 1'
2018-02-07T11:58:21.736720Z 2 [Note] Plugin group_replication reported: 'auto_increment_offset is reset to 1'
2018-02-07T11:58:21.736822Z 7 [Note] Error reading relay log event for channel 'group_replication_applier': slave SQL thread was killed
2018-02-07T11:58:21.738636Z 4 [Note] Plugin group_replication reported: 'The group replication applier thread was killed'

请任何人帮我解决这个错误

Answer 1

会是 SELinux 吗？

您可以尝试通过编辑/etc/selinux/config 来禁用 SELinux并将以下行:SELINUX=enforcing 更改为:SELINUX=disabled

重新启动系统并重试。