Innodb cluster- unable to add new instance.
I am trying to evaluate Innodb cluster on Ubuntu 16.04 EC2 instance within same region.
Cluster has been created successfully but while adding new instance to cluster it give below error.
Cluster.addInstance: WARNING: Not running locally on the server and can not access its error log.
ERROR:
Group Replication join failed.
ERROR: Error joining instance to cluster: 'x.x.x.x:3306' - Query failed. MySQL Error (3092): The server is not configured properly to be an active member of the group. Please see more details on error log.. Query: START group_replication (RuntimeError).
While checking the error log, i found :
[ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to x.x.x.x:13306 on local port: 13306.'
2018-03-08T12:16:28.531931Z 0 [Note] Plugin group_replication reported: 'connecting to x.x.x.x 13306'
2018-03-08T12:16:28.532763Z 0 [Note] Plugin group_replication reported: 'client connected to x.x.x.x.x 13306 fd 88'
2018-03-08T12:16:28.532816Z 0 [Note] Plugin group_replication reported: 'Trying to connect using SSL.'
2018-03-08T12:16:28.632234Z 0 [Note] Plugin group_replication reported: 'Error connecting using SSL 2000114 114.'
I have already opened 13306 port also, as well as ufw service has been stopped.
Any help would be appreciated.
Subject
Views
Written By
Posted
Innodb cluster- unable to add new instance.
3617
March 08, 2018 06:35AM
1085
March 16, 2018 06:19PM
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.