MySQL Forums
Forum List  »  InnoDB clusters

mysql 8 innodb cluster
Posted by: Talia Leibovich
Date: October 21, 2018 09:42AM

Hi,
I configured mysql 8 innodb cluster with router for test envirement
It works fine
I didnt use it for a while and today I found out when running this query:

select MEMBER_ID, MEMBER_HOST, MEMBER_PORT, MEMBER_STATE,
IF (
global_status.VARIABLE_NAME IS NOT NULL, 'PRIMARY', 'SECONDARY') AS MEMBER_ROLE
FROM
performance_schema.replication_group_members
Left JOIN performance_schema.global_status on global_status.VARIABLE_NAME = 'group_replication_primary_member'
AND global_status.VARIABLE_VALUE = replication_group_members.MEMBER_ID
ORDER BY MEMBER_HOST;

server 1 UNREACHABLE SECONDARY
server 2 ONLINE SECONDARY
server 3 UNREACHABLE PRIMARY

I tried to restart the mysql
and than the status of each server become:
MEMBER_HOST, MEMBER_PORT, MEMBER_STATE, MEMBER_ROLE, MEMBER_VERSION
'server 1', '3306', 'OFFLINE', '', ''

Try to :
dba.rebootClusterFromCompleteOutage('cl_test');
but getting this output:
Dba.rebootClusterFromCompleteOutage: The current session instance does not belong to the cluster: 'cl_test'

Any idea how to fix it?

Thanks
Talia



Edited 1 time(s). Last edit at 10/21/2018 09:43AM by Talia Leibovich.

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql 8 innodb cluster
42
October 21, 2018 09:42AM


Sorry, only registered users may post in this forum.

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.