## 主從管理的視圖表 mysql的主從管理信息可以在*performance\_schema*庫中的以replication開頭的表查看，這些表就是我們進行主從管理的系統視圖！ **進入172.30.0.3從數據庫** ~~~ mysql> use performance_schema; Database changed mysql> show tables like 'replication%'; +---------------------------------------------+ | Tables_in_performance_schema (replication%) | +---------------------------------------------+ | replication_applier_configuration | | replication_applier_status | | replication_applier_status_by_coordinator | | replication_applier_status_by_worker | | replication_connection_configuration | | replication_connection_status | | replication_group_member_stats | | replication_group_members | +---------------------------------------------+ 8 rows in set (0.02 sec) ~~~ ## 主從延遲設置 ~~~ # 設置主從延遲 （在docker里面測試沒有效果） # 一個小時后才從主復制到從,注意：要先停止從之后才能設置 mysql> stop slave; mysql> change master to master_delay=3600; mysql> start slave; mysql> select * from replication_applier_configuration \G *************************** 1. row *************************** CHANNEL_NAME: # 鏈路名稱：用來在多鏈路復制時區分不同的鏈路，默認空字符串 DESIRED_DELAY: 3600 # 主從延遲：用來設置復制過程中設置的主從延遲，默認為0不延遲 mysql> select * from replication_applier_status \G *************************** 1. row *************************** CHANNEL_NAME: SERVICE_STATE: ON REMAINING_DELAY: 3496 # 主有變化，還剩多少時間到從 ~~~ ## 多線程復制查看 ~~~ # 多線程復制是控制器的情況 mysql> select * from replication_applier_status_by_coordinator \G # 多線程復制時的線程, 幾行數據代表幾個線程在工作 mysql> select * from replication_applier_status_by_worker \G ~~~ ## 多源復制查看 ~~~ # 查看各個channel的連接配置信息：host、port、user、auto_position等 mysql> select * from replication_connection_configuration \G # 查看各個channel的連接信息 mysql> select * from replication_connection_status \G ~~~ ## 組復制信息查看 ~~~ mysql> select * from replication_group_member_stats \G mysql> select * from replication_group_member \G ~~~