MySQL Forums
Forum List  »  Replication

8.0.4 GR fails to recover: only PRIMARY up
Posted by: Geert Vanderkelen
Date: January 24, 2018 08:50AM

Hey guys,

Yesterday I pulled up a shiny Group Replication cluster thingy. All well. Today I made Ansible rolling upgrade playbook for 8.0.4: lots of issues (which I logged as bugs).

However, a more bigger problem is that with 8.0.4 I can not setup group replication using the Manual's steps. What worked nicely for 8.0.3 fails for 8.0.4. More precisely: the instance coming up can not connect using the recovery channel user with the primary.

The user credentials work. Just not here:

2018-01-24T14:42:31.851748Z 23 [System] [MY-010597] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host='mysqld1', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='mysqld1', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2018-01-24T14:42:31.871048Z 27 [Warning] [MY-010897] 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.
2018-01-24T14:42:31.872966Z 27 [ERROR] [MY-002061] Slave I/O for channel 'group_replication_recovery': error connecting to master 'replicator@mysqld1:3306' - retry-time: 60 retries: 1, Error_code: 2061
2018-01-24T14:42:31.877725Z 23 [ERROR] [MY-011254] Plugin group_replication reported: 'There was an error when connecting to the donor server. Please check that group_replication_recovery channel credentials and all MEMBER_HOST column values of performance_schema.replication_group_members table are correct and DNS resolvable.'

DNS works too. That didn't change.

What is not documented that did change? What we have to do extra?

Options: ReplyQuote


Subject
Views
Written By
Posted
8.0.4 GR fails to recover: only PRIMARY up
3949
January 24, 2018 08:50AM
4139
January 25, 2018 05:12AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.