問題描述

我是三臺主機的, iptables, selinux ,ipv6全關, 第一個節點成功啟動了并且加入group, 但是第二個節點死活加入不了group, 網上目前有幾篇操作手冊, 跟官方都差不多, 應該有人成功過, 不知道自己哪里做的不對

安裝官方第二個節點, 在安裝完插件后, 只需啟動group replication即可

START GROUP_REPLICATION;

第二個節點錯誤日志如下:

2017-01-16T18:09:03.578252Z 0 [Note] Plugin group_replication reported: ’client connected to localhost 33062 fd 69’2017-01-16T18:09:03.578427Z 0 [Note] Plugin group_replication reported: ’connecting to localhost 33062’2017-01-16T18:09:03.578800Z 0 [Note] Plugin group_replication reported: ’client connected to localhost 33062 fd 72’2017-01-16T18:09:03.578977Z 0 [Note] Plugin group_replication reported: ’connecting to localhost 33062’2017-01-16T18:09:03.579081Z 0 [Note] Plugin group_replication reported: ’client connected to localhost 33062 fd 74’2017-01-16T18:09:03.579236Z 0 [Note] Plugin group_replication reported: ’connecting to postgressql1.novalocal 33061’2017-01-16T18:09:03.580815Z 0 [Note] Plugin group_replication reported: ’client connected to postgressql1.novalocal 33061 fd 76’2017-01-16T18:09:33.581699Z 0 [ERROR] Plugin group_replication reported: ’[GCS] Timeout while waiting for the group communication engine to be ready!’2017-01-16T18:09:33.581774Z 0 [ERROR] Plugin group_replication reported: ’[GCS] The group communication engine is not ready for the member to join. Local port: 33062’2017-01-16T18:09:33.581955Z 0 [Note] Plugin group_replication reported: ’state 4257 action xa_terminate’2017-01-16T18:09:33.582007Z 0 [Note] Plugin group_replication reported: ’new state x_start’2017-01-16T18:09:33.582020Z 0 [Note] Plugin group_replication reported: ’state 4257 action xa_exit’2017-01-16T18:09:33.582278Z 0 [Note] Plugin group_replication reported: ’Exiting xcom thread’2017-01-16T18:09:33.582291Z 0 [Note] Plugin group_replication reported: ’new state x_start’2017-01-16T18:09:33.582349Z 0 [Warning] Plugin group_replication reported: ’read failed’2017-01-16T18:09:33.596918Z 0 [ERROR] Plugin group_replication reported: ’[GCS] The member was unable to join the group. Local port: 33062’2017-01-16T18:10:03.553584Z 4 [ERROR] Plugin group_replication reported: ’Timeout on wait for view after joining group’2017-01-16T18:10:03.553730Z 4 [Note] Plugin group_replication reported: ’Requesting to leave the group despite of not being a member’2017-01-16T18:10:03.554294Z 4 [ERROR] Plugin group_replication reported: ’[GCS] The member is leaving a group without being on one.’2017-01-16T18:10:03.554485Z 4 [Note] Plugin group_replication reported: ’auto_increment_increment is reset to 1’2017-01-16T18:10:03.554514Z 4 [Note] Plugin group_replication reported: ’auto_increment_offset is reset to 1’2017-01-16T18:10:03.555996Z 9 [Note] Error reading relay log event for channel ’group_replication_applier’: slave SQL thread was killed2017-01-16T18:10:03.610642Z 6 [Note] Plugin group_replication reported: ’The group replication applier thread was killed’"

my.cnf如下:

[mysqld]user=mysqlbasedir=/usr/local/mysqldatadir=/data/mysqlport=3306socket=/tmp/mysql.sockcharacter-set-server=utf8explicit_defaults_for_timestampserver_id=2gtid_mode=ONenforce_gtid_consistency=ONmaster_info_repository=TABLErelay_log_info_repository=TABLEbinlog_checksum=NONElog_slave_updates=ONlog_bin=binlogbinlog_format=ROWtransaction_write_set_extraction=XXHASH64loose-group_replication_group_name='aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa'loose-group_replication_start_on_boot=offloose-group_replication_local_address='localhost:33062'loose-group_replication_group_seeds='postgressql1.novalocal:33061,localhost:33062,postgressql3.novalocal:33063'loose-group_replication_bootstrap_group= off

問題解答

官網文檔沒有提到的是, 成功啟動第一個node后, 在啟動其他node的時候需要一個命令

set global group_replication_allow_local_disjoint_gtids_join=ON;

為什么要執行, 可以看日志里面有提示, 注意不要光看ERROR的, 這個參數在一個NOTE級別的日志里面說了, 我覺得有點不妥, 起碼是WARN的吧

樓主你好，我也碰到了同樣的問題，請問你解決了嗎？難道GR只能在本機多實例YY著玩？

我也遇到了同樣的問題，跨機器就是玩不轉，所有的參數都做了嘗試，搞不懂為何修改了IP，就不能夠成功加入了，可能是哪里沒有設置到位，我是新司機不懂路子，期待老司機帶帶。。。。

2017-03-17T23:21:26.354663+08:00 0 [Note] Plugin group_replication reported: ’client connected to 127.0.0.1 24902 fd 73’2017-03-17T23:21:26.354787+08:00 0 [Note] Plugin group_replication reported: ’connecting to 127.0.0.1 24902’2017-03-17T23:21:26.354854+08:00 0 [Note] Plugin group_replication reported: ’client connected to 127.0.0.1 24902 fd 75’2017-03-17T23:21:26.355006+08:00 0 [Note] Plugin group_replication reported: ’connecting to 127.0.0.1 24902’2017-03-17T23:21:26.355076+08:00 0 [Note] Plugin group_replication reported: ’client connected to 127.0.0.1 24902 fd 77’2017-03-17T23:21:26.355243+08:00 0 [Note] Plugin group_replication reported: ’connecting to 172.19.58.11 24901’2017-03-17T23:21:26.355522+08:00 0 [Note] Plugin group_replication reported: ’client connected to 172.19.58.11 24901 fd 79’2017-03-17T23:21:56.355981+08:00 0 [ERROR] Plugin group_replication reported: ’[GCS] Timeout while waiting for the group communication engine to be ready!’2017-03-17T23:21:56.356064+08:00 0 [ERROR] Plugin group_replication reported: ’[GCS] The group communication engine is not ready for the member to join. Local port: 24902’2017-03-17T23:21:56.356174+08:00 0 [Note] Plugin group_replication reported: ’state 4257 action xa_terminate’2017-03-17T23:21:56.356202+08:00 0 [Note] Plugin group_replication reported: ’new state x_start’2017-03-17T23:21:56.356208+08:00 0 [Note] Plugin group_replication reported: ’state 4257 action xa_exit’2017-03-17T23:21:56.356823+08:00 0 [Note] Plugin group_replication reported: ’Exiting xcom thread’2017-03-17T23:21:56.356849+08:00 0 [Note] Plugin group_replication reported: ’new state x_start’2017-03-17T23:21:56.356943+08:00 0 [Warning] Plugin group_replication reported: ’read failed’2017-03-17T23:21:56.373558+08:00 0 [ERROR] Plugin group_replication reported: ’[GCS] The member was unable to join the group. Local port: 24902’2017-03-17T23:22:26.348810+08:00 4 [ERROR] Plugin group_replication reported: ’Timeout on wait for view after joining group’2017-03-17T23:22:26.348946+08:00 4 [Note] Plugin group_replication reported: ’Requesting to leave the group despite of not being a member’2017-03-17T23:22:26.348974+08:00 4 [ERROR] Plugin group_replication reported: ’[GCS] The member is leaving a group without being on one.’2017-03-17T23:22:26.349235+08:00 4 [Note] Plugin group_replication reported: ’auto_increment_increment is reset to 1’2017-03-17T23:22:26.349255+08:00 4 [Note] Plugin group_replication reported: ’auto_increment_offset is reset to 1’2017-03-17T23:22:26.349434+08:00 75 [Note] Error reading relay log event for channel ’group_replication_applier’: slave SQL thread was killed2017-03-17T23:22:26.355725+08:00 72 [Note] Plugin group_replication reported: ’The group replication applier thread was killed’