mysql5.7 mgr功能_详解MySQL 5.7 MGR单主确定主节点方法

曾经终败给现在 2022-10-27 02:46 15阅读 0赞

我们行MGR年底要上线了，每天都要看官方文档学习，做测试，坚持每天写一个小知识点，有想一起学习的么~

MySQL 5.7 MGR单主确定主节点是哪个，我们可以通过成员ID来判断，然后结合read\_only参数来确认。

\[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)

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: root@127.0.0.1

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;

\+---------------------------+--------------------------------------+-------------+-------------+--------------+

\+---------------------------+--------------------------------------+-------------+-------------+--------------+

\+---------------------------+--------------------------------------+-------------+-------------+--------------+

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>

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持脚本之家。

mysql5.7 mgr功能_详解MySQL 5.7 MGR单主确定主节点方法

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 mysql组复制脑裂_【MySQL】MySQL MGR组复制搭建（单主及多主模式）

相关 mysql57审计功能开启

相关【MySQL】——MySQL 5.7 MGR(单主模式)

相关 mgr未同步 mysql_MySQL MGR 有哪些优点

相关 mysql5.7 mgr功能_详解MySQL 5.7 MGR单主确定主节点方法

相关 MGR单主模式搭建

相关 MySQL group replication MGR 单主/多主模式搭建

相关 ProxySQL+MGR单主

相关 MySQL MGR如何查找主节点

相关 MySQL MGR 单主模式下单点故障时的节点角色切换规则