Detailed explanation of MySQL 5.7 MGR single master determination master node method

Detailed explanation of MySQL 5.7 MGR single master determination master node method

Our bank's MGR will be launched at the end of the year. I have to read the official documents and do tests every day. I insist on writing a small knowledge point every day. Is there anyone who wants to learn together?

MySQL 5.7 MGR single master determines which is the primary node. We can judge by the member ID and then confirm it in combination with the read_only parameter.

[root@localhost ~]# mysql -uroot -p -P 3306 -h 127.0.0.1
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 857246
Server version: 5.7.26-29-log Percona Server (GPL)

Copyright (c) 2009-2019 Percona LLC and/or its affiliates
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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 wrapper

Connection id: 857246
Current database:  
Current user: [email protected]
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.7.26-29-log Percona Server (GPL)
Protocol version: 10
Connection: 127.0.0.1 via TCP/IP
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 39 days 8 hours 53 min 39 sec

Threads: 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.01 sec)

mysql> 

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.

You may also be interested in:
  • How to configure MGR single master and multiple slaves in MySQL 8.0.15
  • What are the advantages of MySQL MGR?
  • Detailed explanation of mysql MGR single-master and multi-master mode switching knowledge points
  • mysql 8.0.18 mgr installation and its switching function
  • MySQL 8.0.18 uses clone plugin to rebuild MGR implementation
  • Common problems and solutions during MySQL MGR construction

<<:  Detailed steps for setting up the network for the virtual machine that comes with win10 (graphic tutorial)

>>:  A simple method to deal with the tabBar at the bottom of WeChat applet blocking content

Recommend

Detailed steps to build a file server in Windows Server 2012

The file server is one of the most commonly used ...

CSS HACK for IE6/IE7/IE8/IE9/FF (summary)

Since I installed the official version of IE8.0, ...

Vue custom directive details

Table of contents 1. Background 2. Local custom i...

CSS Summary Notes: Examples of Transformations, Transitions, and Animations

1. Transition Transition property usage: transiti...

Description of the hr tag in various browsers

Generally, we rarely meet HR, but once we do, it c...

Nginx high concurrency optimization practice

1. Necessity of Tuning​ I have always been reluct...

JS achieves five-star praise effect

Use JS to implement object-oriented methods to ac...

How is MySQL transaction isolation achieved?

Table of contents Concurrent scenarios Write-Writ...

How to recover files accidentally deleted by rm in Linux environment

Table of contents Preface Is there any hope after...

How to change the website accessed by http to https in nginx

Table of contents 1. Background 2. Prerequisites ...

mysql uses stored procedures to implement tree node acquisition method

As shown in the figure: Table Data For such a tre...

Detailed explanation of Vue3 life cycle functions and methods

1. Overview The so-called life cycle function is ...