group_replication_recovery - Service State OFF
Hi,
On my config, the group_replication_recovery Channel is offline, but all appears to be working just fine.
What is this channel and how meaningful it is? How can i turn it ON? 'Repl' is my replication user, but its not connecting to the db's..
mysql> select * from performance_schema.replication_connection_status\G
*************************** 1. row ***************************
CHANNEL_NAME: group_replication_applier
GROUP_NAME: efbeffc0-0415-4c2c-b9bd-0c9781c52a1e
SOURCE_UUID: efbeffc0-0415-4c2c-b9bd-0c9781c52a1e
THREAD_ID: NULL
SERVICE_STATE: ON
COUNT_RECEIVED_HEARTBEATS: 0
LAST_HEARTBEAT_TIMESTAMP: 0000-00-00 00:00:00
RECEIVED_TRANSACTION_SET: 6cbc047c-d78c-11e7-a899-08002733828a:1,
efbeffc0-0415-4c2c-b9bd-0c9781c52a1e:1-3051:1000081-1000131,
fba2794d-d791-11e7-a8de-08002733828a:1
LAST_ERROR_NUMBER: 0
LAST_ERROR_MESSAGE:
LAST_ERROR_TIMESTAMP: 0000-00-00 00:00:00
*************************** 2. row ***************************
CHANNEL_NAME: group_replication_recovery
GROUP_NAME:
SOURCE_UUID:
THREAD_ID: NULL
SERVICE_STATE: OFF
COUNT_RECEIVED_HEARTBEATS: 0
LAST_HEARTBEAT_TIMESTAMP: 0000-00-00 00:00:00
RECEIVED_TRANSACTION_SET:
LAST_ERROR_NUMBER: 0
LAST_ERROR_MESSAGE:
LAST_ERROR_TIMESTAMP: 0000-00-00 00:00:00
2 rows in set (0.00 sec)
On my logs i get:
(SLAVE)
2017-12-12T10:10:24.539736Z 21 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='172.18.209.31', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2017-12-12T10:10:24.550387Z 21 [Note] Plugin group_replication reported: 'Establishing connection to a group replication recovery donor 6cbc047c-d78c-11e7-a899-08002733828a at 172.18.209.31 port: 3306.'
2017-12-12T10:10:24.551260Z 23 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2017-12-12T10:10:24.554039Z 24 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in log 'FIRST' at position 0, relay log './secondMachine-relay-bin-group_replication_recovery.000001' position: 4
2017-12-12T10:10:24.589381Z 23 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'repl@172.18.209.31:3306',replication started in log 'FIRST' at position 4
2017-12-12T10:10:24.611231Z 21 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and purging the corresponding logs.'
2017-12-12T10:10:24.612501Z 24 [Note] Slave SQL thread for channel 'group_replication_recovery' exiting, replication stopped in log 'binlog.000027' at position 1126
2017-12-12T10:10:24.614285Z 23 [Note] Slave I/O thread killed while reading event for channel 'group_replication_recovery'
2017-12-12T10:10:24.614523Z 23 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'binlog.000027', position 1126
2017-12-12T10:10:24.627724Z 21 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host='172.18.209.31', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''.
2017-12-12T10:10:24.644918Z 0 [Note] Plugin group_replication reported: 'This server was declared online within the replication group'
2017-12-12T10:10:27.945898Z 3 [Note] Aborted connection 3 to db: 'unconnected' user: 'monitor' host: '172.18.208.233' (Got an error writing communication packets)
(MASTER)
2017-12-12T10:10:24.532118Z 0 [Note] Plugin group_replication reported: 'Group membership changed to 172.18.209.31:3306, 172.18.209.34:3306 on view 15130733669263760:2.'
2017-12-12T10:10:24.603586Z 29 [Note] Start binlog_dump to master_thread_id(29) slave_server(2), pos(, 4)
2017-12-12T10:10:24.651110Z 0 [Note] Plugin group_replication reported: 'The member with address 172.18.209.34:3306 was declared online within the replication group'
2017-12-12T10:11:24.606963Z 29 [Note] Aborted connection 29 to db: 'unconnected' user: 'repl' host: '172.18.209.34' (failed on flush_net())