MySQL 5.7数据库多源复制拓扑如下: 1M1 --------+ 2 | 3 | 4 v 5M2 ------->S M1和M2为两个主数据库实例,S为从数据库实例,建立了从M1到S和从M2到S的多源复制。 S上执行: 1SHOW SLAVE STATUS \G 2*************************** 1. row *************************** 3 Slave_IO_State: Waiting for master to send event 4 Master_Host: x.x.x.x 5 Master_User: repl 6 Master_Port: 3306 7 Connect_Retry: 60 8 Master_Log_File: binlog.000106 9 Read_Master_Log_Pos: 15847815 10 Relay_Log_File: relay-bin-m1.000003 11 Relay_Log_Pos: 15684092 12 Relay_Master_Log_File: binlog.000106 13 Slave_IO_Running:……
阅读全文