详解MySQL 5.7 MGR单主确定主节点方法
我们行MGR年底要上线了,每天都要看官方文档学习,做测试,坚持每天写一个小知识点,有想一起学习的么~
MySQL5.7MGR单主确定主节点是哪个,我们可以通过成员ID来判断,然后结合read_only参数来确认。
[root@localhost~]#mysql-uroot-p-P3306-h127.0.0.1 mysql:[Warning]Usingapasswordonthecommandlineinterfacecanbeinsecure. WelcometotheMySQLmonitor.Commandsendwith;or\g. YourMySQLconnectionidis857246 Serverversion:5.7.26-29-logPerconaServer(GPL) Copyright(c)2009-2019PerconaLLCand/oritsaffiliates Copyright(c)2000,2019,Oracleand/oritsaffiliates.Allrightsreserved. OracleisaregisteredtrademarkofOracleCorporationand/orits affiliates.Othernamesmaybetrademarksoftheirrespective owners. Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement. mysql>status -------------- mysqlVer14.14Distrib5.7.26-29,forLinux(x86_64)usingEditLinewrapper Connectionid:857246 Currentdatabase: Currentuser:root@127.0.0.1 SSL:Notinuse Currentpager:stdout Usingoutfile:'' Usingdelimiter:; Serverversion:5.7.26-29-logPerconaServer(GPL) Protocolversion:10 Connection:127.0.0.1viaTCP/IP Servercharacterset:utf8mb4 Dbcharacterset:utf8mb4 Clientcharacterset:utf8 Conn.characterset:utf8 TCPport:3306 Uptime:39days8hours53min39sec Threads:4Questions:4989552Slowqueries:731837Opens:930Flushtables:1Opentables:924Queriespersecondavg:1.466 -------------- mysql>SHOWSTATUSLIKE'group_replication_primary_member'; +----------------------------------+--------------------------------------+ |Variable_name|Value| +----------------------------------+--------------------------------------+ |group_replication_primary_member|59d7f183-b8f6-11e9-863b-005056875165| +----------------------------------+--------------------------------------+ 1rowinset(0.00sec) mysql>select*fromperformance_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| +---------------------------+--------------------------------------+-------------+-------------+--------------+ 3rowsinset(0.00sec) mysql>showvariableslike'%read_only'; +-----------------------+-------+ |Variable_name|Value| +-----------------------+-------+ |innodb_read_only|OFF| |read_only|OFF| |super_read_only|OFF| |transaction_read_only|OFF| |tx_read_only|OFF| +-----------------------+-------+ 5rowsinset(0.01sec) mysql>
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持毛票票。