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

Our bank MGR will be online at the end of the year, every day we have to read official documents to study, do tests, and insist on writing a small knowledge point every day. Do you want to study together?

MySQL 5.7MGR determines which master node is, which can be determined by member ID, and then confirmed by read_only parameters.

[root@localhost] # mysql-uroot-p-P 3306-h 127.0.0.1mysql: [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 857246Server version: 5.7.26-29-log Percona Server (GPL) Copyright (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 > status-mysql Ver 14.14 Distrib 5.7.26-29, for Linux (x86'64) using EditLine wrapperConnection id: 857246Current database: Current user: root@127.0.0.1SSL: Not in useCurrent pager: stdoutUsing outfile:''Using delimiter: Server version: 5.7.26-29-log Percona Server (GPL) Protocol version: 10Connection: 127.0.0.1 via TCP/IPServer characterset: utf8mb4Db characterset: utf8mb4Client characterset: utf8Conn. Characterset: utf8TCP port: 3306Uptime: 39 days 8 hours 53 min 39 secThreads: 4 Questions: 4989552 Slow queries: 731837 Opens: 930 Flush tables: 1 Open tables: 924 Queries per second avg: 1.466-mysql > SHOW STATUS LIKE 'group_replication_primary_member' +-- +-- + | Variable_name | Value | +- -+-+ | group_replication_primary_member | 59d7f183-b8f6-11e9-863b-005056875165 | +-- -+ 1 row in set (0.00 sec) mysql > select * from performance_schema.replication_group_members +-+ | CHANNEL_NAME | MEMBER_ ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | +-- +-- -+ | group_replication_applier | 500dd0aa-b8f6-11e9-85ba-005056875a61 | 196.55.7.37 | 3306 | ONLINE | | group_replication_applier | 59d7f183-b8f6-11e9-863b-005056875165 | 196.55.7.36 | 3306 | ONLINE | | group_replication_applier | 69e1c26d-b8f6-11e9-91c1-00505687032a | 196.55.7.38 | 3306 | ONLINE | +- -+-+ 3 rows in set (0.00 sec) mysql > show variables like'% read_only' +-- +-+ | Variable_name | Value | +-- +-+ | innodb_read_only | OFF | | read_only | OFF | | super_read_only | OFF | | transaction_read_only | OFF | | tx_read_only | OFF | +-- -+-+ 5 rows in set (0.01sec) mysql >

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

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.