|
p;| Address | Port | Connections | Status
-------------------+-----------------+-------+-------------+--------------------
server1 | 192.168.1.201 | 3306 | 4 | Master, Running
server2 | 192.168.1.202 | 3306 | 4 | Slave, Running
-------------------+-----------------+-------+-------------+--------------------
延迟检测：maxscale会对master和slave上replication_heartbeat表的master_timestamp时间戳进行对比，
相减得出差异。这个差异就是MySQL主从同步的延迟值。
[root@wallet01 ~]# mysql -uroot -pabcd.1234
mysql> select * from maxscale_schema.replication_heartbeat;
+-------------+------------------+------------------+
| maxscale_id | master_server_id | master_timestamp |
+-------------+------------------+------------------+
| 0 | 1 | 1544771935 |
+-------------+------------------+------------------+
|