Hi @Vadim_Yalovets ,
Below is the o/p:
MySQL ********:3306 ssl SQL > \s
MySQL Shell version 8.0.16
Session type: Classic
Connection Id: 30289270
Current schema:
Current user: pmm@********
SSL: Cipher in use: DHE-RSA-AES128-GCM-SHA256 TLSv1.2
Using delimiter: ;
Server version: 8.0.16 Source distribution
Protocol version: classic 10
Client library: 8.0.16
Connection: ******** via TCP/IP
TCP port: 3306
Server characterset: utf8
Schema characterset: utf8
Client characterset: utf8mb4
Conn. characterset: utf8mb4
Compression: Disabled
Uptime: 637 days 25 min 21.0000 sec
Threads: 8 Questions: 161612635 Slow queries: 0 Opens: 4019733 Flush tables: 857 Open tables: 256 Queries per second avg: 2.936
MySQL ******:3306 ssl SQL > SELECT CHANNEL_NAME as channel_name, MEMBER_ID as member_id, MEMBER_HOST as member_host, MEMBER_PORT as member_port, MEMBER_STATE as member_state, MEMBER_ROLE as member_role, MEMBER_VERSION as member_version, CASE WHEN MEMBER_STATE = ‘ONLINE’ THEN 1 WHEN MEMBER_STATE = ‘RECOVERING’ THEN 2 WHEN MEMBER_STATE = ‘OFFLINE’ THEN 3 WHEN MEMBER_STATE = ‘ERROR’ THEN 4 WHEN MEMBER_STATE = ‘UNREACHABLE’ THEN 5 END as member_info FROM performance_schema.replication_group_members WHERE MEMBER_ID=@@server_uuid\G
*************************** 1. row ***************************
channel_name: group_replication_applier
member_id: d5007267-a22f-11e9-8c81-fa163e51af36
member_host: ***********
member_port: 3306
member_state: ONLINE
member_role: PRIMARY
member_version: 8.0.16
member_info: 1
1 row in set (0.0005 sec)
Also, about the agent debug logs, I would’ve attached the complete log here in this case, but unfortunately the portal won’t allow me to do that .
Thanks,
Nikunj