MGR停服时长理论测试
【环境信息】
192.168.1.181
192.168.1.182
192.168.1.183
mysql> SELECT member_host,member_port,member_state,member_role,member_communication_stack FROM performance_schema.replication_group_members;
+---------------+-------------+--------------+-------------+----------------------------+
| member_host | member_port | member_state | member_role | member_communication_stack |
+---------------+-------------+--------------+-------------+----------------------------+
| 192.168.1.183 | 3306 | ONLINE | SECONDARY | XCom |
| 192.168.1.182 | 3306 | ONLINE | PRIMARY | XCom |
| 192.168.1.181 | 3306 | ONLINE | SECONDARY | XCom |
+---------------+-------------+--------------+-------------+----------------------------+
3 rows in set (0.00 sec)
