MySQL主從切換流程圖

+-----------------+     +-----------------+
|  主數據庫服務器           |     |  從數據庫服務器   |
+-----------------+     +-----------------+
|                          |
查看主庫狀態                     |
|                          |
+---------------+           |
|  SHOW MASTER STATUS |           |
+---------------+           |
|                          |
獲取二進制文件名和位置                |
|                          |
V                          V
+-----------------+     +-----------------+
|    停止寫操作 (FLUSH TABLES WITH READ LOCK)  |     |   停止IO線程 (STOP SLAVE)    |
+-----------------+     +-----------------+
|                          |
V                          V
+-----------------+     +-----------------+
|      復制二進制文件及日志記錄          |     | 執行切換命令 (CHANGE MASTER) |
+-----------------+     +-----------------+
|                          |
V                          V
+-----------------+     +-----------------+
|       切換讀取操作 (UNLOCK TABLES)       |     |     啟動IO線程 (START SLAVE)   |
+-----------------+     +-----------------+
|                          |
完成主從切換                     |
|                          |
V                          V
+-----------------+     +-----------------+
|     主數據庫服務器           |     |  從數據庫服務器   |
+-----------------+     +-----------------+