mysql-utilities工具体验(二)
g : Yes
Slave_SQL_Running : Yes
Replicate_Do_DB :
Replicate_Ignore_DB : mysql
Replicate_Do_Table :
Replicate_Ignore_Table :
Replicate_Wild_Do_Table :
Replicate_Wild_Ignore_Table :
Last_Errno : 0
Last_Error :
Skip_Counter : 0
Exec_Master_Log_Pos : 151
Relay_Log_Space : 819
Until_Condition : None
Until_Log_File :
Until_Log_Pos : 0
Master_SSL_Allowed : No
Master_SSL_CA_File :
Master_SSL_CA_Path :
Master_SSL_Cert :
Master_SSL_Cipher :
Master_SSL_Key :
Seconds_Behind_Master : 0
Master_SSL_Verify_Server_Cert : No
Last_IO_Errno : 0
Last_IO_Error :
Last_SQL_Errno : 0
Last_SQL_Error :
Replicate_Ignore_Server_Ids :
Master_Server_Id : 131
Master_UUID : 4d89ad1d-bc12-11e2-87e9-080027338857
Master_Info_File : mysql.slave_master_info
SQL_Delay : 0
SQL_Remaining_Delay : None
Slave_SQL_Running_State : Slave has read all relay log; waiting for the slave I/O thread to update it
Master_Retry_Count : 86400
Master_Bind :
Last_IO_Error_Timestamp :
Last_SQL_Error_Timestamp :
Master_SSL_Crl :
Master_SSL_Crlpath :
Retrieved_Gtid_Set :
Executed_Gtid_Set :
Auto_Position : 1
# ...done.
[root@mysql56-master home]#
3. mysqlrplshow. 显示主从的架构。
[sql]
[root@mysql56-master home]# mysqlrplshow --master=root:root@192.168.1.131:3306 --discover-slaves-login=root:root -v
# master on 192.168.1.131: ... connected.
# Finding slaves for master: 192.168.1.131:3306
# Replication Topology Graph
192.168.1.131:3306 (MASTER)
|
+--- 192.168.1.132:3306 [IO running: Yes] - (SLAVE)
|
+--- 192.168.1.133:3306 [IO running: Yes] - (SLAVE)
[root@mysql56-master home]#
4. mysqlfailover. 监视主从健康状态。
[sql]
[root@mysql56-master home]# mysqlfailover --master=root:root@192.168.1.131:3306 --discover-slaves-login=root:root
# Discovering slaves for master at 192.168.1.131:3306
# Discovering slave at 192.168.1.132:3306
# Found slave: 192.168.1.132:3306
# Discovering slave at 192.168.1.133:3306
# Found slave: 192.168.1.133:3306
# Checking privileges.
MySQL Replication Failover Utility
Failover Mode = auto Next Interval = Tue May 14 12:27:56 2013
Master Information
------------------
Binary Log File Position Binlog_Do_DB Binlog_Ignore_DB
mysql56-master-bin.0 151 mysql
GTID Executed Set
None
Replication Health Status
+----------------+-------+---------+--------+------------+-------------------------------------------+
| host | port | role | state | gtid_mode | health |
+----------------+-------+---------+--------+------------+-------------------------------------------+
| 192.168.1.131 | 3306 | MASTER | UP | ON | OK |
| 192.168.1.132 | 3306 | SLAVE | UP | ON