My Oracle Support Banner

Monitoring Group Replication Member States In InnoDB Cluster Using Performance Schema And MySQL Shell (Doc ID 2982417.1)

Last updated on OCTOBER 31, 2023

Applies to:

MySQL Server - Version 5.7 and later
Information in this document applies to any platform.

Goal

The purpose of this document is to list the meaning of possible states of group replication members (nodes) in InnoDB Cluster and on how to determine which node is the primary by using an SQL query or by using MySQL shell commands.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
 MEMBER_HOST
 MEMBER_STATE
  MEMBER_ROLE
 REFERENCES
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.