Normal State of MySQL Replication Group

The following example shows a MySQL replication group with three members:

mysql-set-0-0.mysql-svc-2.default.svc.cluster.local
mysql-set-1-0.mysql-svc-0.default.svc.cluster.local
mysql-set-2-0.mysql-svc-1.default.svc.cluster.local

Running the following commands should yield the same results:

kubectl exec mysql-set-0-0 -- mysql -uroot -pchangeme -e "SELECT * FROM performance_schema.replication_group_members;"
kubectl exec mysql-set-1-0 -- mysql -uroot -pchangeme -e "SELECT * FROM performance_schema.replication_group_members;"
kubectl exec mysql-set-2-0 -- mysql -uroot -pchangeme -e "SELECT * FROM performance_schema.replication_group_members;"

Example output:

CHANNEL_NAME    MEMBER_ID   MEMBER_HOST MEMBER_PORT MEMBER_STATE
group_replication_applier   070f57ea-e271-11ea-bca7-ce95fa60e6f7    mysql-set-2-0.mysql-svc-2.default.svc.cluster.local 3306    ONLINE
group_replication_applier   836c7441-e270-11ea-b6fa-4ea77323e96f    mysql-set-0-0.mysql-svc-0.default.svc.cluster.local 3306    ONLINE
group_replication_applier   c7ae2e67-e270-11ea-ba2b-ea4a486569d2    mysql-set-1-0.mysql-svc-1.default.svc.cluster.local 3306    ONLINE

The above output show all three members are online.