mysql 8 innodb cluster

[Talia Leibovich]

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.