Shulou(Shulou.com)06/01 Report--

There is only one status variable for group replication, which still exists in version 8.0.17 and will be discarded in the future. We can use it to see which node is a read-write node in single-master mode.

Mysql: [Warning] Using a password on the command line interface can be insecure.Welcome to the MySQL monitor. Commands end with; or\ g.Your MySQL connection id is 2087Server version: 8.0.17 MySQL Community Server-GPLCopyright (c) 2009-2019 Percona LLC and/or its affiliatesCopyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.mysql > show status like 'group_replication_primary_member' +-- +-+ | Variable_name | Value | +- -+ | group_replication_primary_member | 1fb894d8-e752-11e9-a0a1-00505687032a | +-+- -- + 1 row in set (0.00 sec) group_replication_primary_memberShows the primary member's UUID when the group is operating in single-primary mode. If the group is operating in multi-primary mode, shows an empty string.The group_replication_primary_member status variable has been deprecated and is scheduled to be removed in a future version.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.