MySQL 8 clone 插件快速重建主从集群

原创三笠丶 2026-01-08

346

前言

今天发现有一套 MySQL 8 数据库主从不同步了，报错如下：

mysql> show slave status \G;
-- 错误内容
Last_Errno: 1032
Last_Error: Coordinator stopped because there were error(s) in the worker(s). The most recent failure being: Worker 1 failed executing transaction 'ANONYMOUS' at master log mysql-bin.003633, end_log_pos 603058578. See error log and/or performance_schema.replication_applier_status_by_worker table for more details about this failure or others, if any.

-- 根据提示消息查询详细报错
mysql> SELECT * FROM performance_schema.replication_applier_status_by_worker WHERE LAST_ERROR_NUMBER = 1032 \G;
-- 错误内容
LAST_ERROR_TIMESTAMP: 2025-09-06 20:08:06.998256
...
LAST_ERROR_MESSAGE: Worker 1 failed executing transaction 'ANONYMOUS' at master log mysql-bin.003633, end_log_pos 603058578; 
Could not execute Update_rows event on table ci_sch***.qrtz_***_triggers; 
Can't find record in 'qrtz_***_triggers', Error_code: 1032; 
handler error HA_ERR_KEY_NOT_FOUND; the event's master log FIRST, end_log_pos 603058578

由于不同步的时间已经很久了，主库的 binlog 已经不存在，所以只能重建从库了，本文使用 MySQL 8 的 clone 插件进行主从重建。

主从重建

安装插件

主从均需安装 clone 插件：

mysql> install plugin clone soname 'mysql_clone.so';
Query OK

mysql> select plugin_name, plugin_status from information_schema.plugins where plugin_name = 'clone';
+-------------+---------------+
| PLUGIN_NAME | PLUGIN_STATUS |
+-------------+---------------+
| clone       | ACTIVE        |
+-------------+---------------+

确保安装完成即可。

配置权限

执行克隆操作需要特定的权限，本地复制和远程复制权限不同：

本地克隆：执行克隆操作的用户需要 BACKUP_ADMIN 权限；
远程克隆：捐赠者（数据源）用户需要 BACKUP_ADMIN 权限；接受者（目标）用户需要 CLONE_ADMIN 权限（该权限隐含了 BACKUP_ADMIN 和 SHUTDOWN 权限）；

主（源端）：

mysql> GRANT BACKUP_ADMIN ON *.* TO 'root'@'%';
mysql> FLUSH PRIVILEGES;

从（目标端）：

mysql> GRANT CLONE_ADMIN ON *.* TO 'root'@'%';
mysql> FLUSH PRIVILEGES;

远程克隆

从库开始克隆：

-- 从库配置参数
mysql> set global clone_valid_donor_list='192.168.31.188:3306';

-- 从库开始克隆
mysql> clone instance from root@'192.168.31.188':3306 identified by 'P@ssw0rd';

克隆过程中，从库可以查询进度：

-- 查看克隆进度
mysql> SELECT 
    stage,
    state,
    CAST(begin_time AS DATETIME) AS "START TIME",
    CAST(end_time AS DATETIME) AS "FINISH TIME",
    LPAD(sys.format_time(POWER(10, 12) * (UNIX_TIMESTAMP(end_time) - UNIX_TIMESTAMP(begin_time))), 10, ' ') AS DURATION,
    LPAD(CONCAT(FORMAT(ROUND(estimate / 1024 / 1024, 0), 0), "MB"), 16, ' ') AS "Estimate",
    CASE 
        WHEN begin_time IS NULL THEN LPAD('%0', 7, ' ')
        WHEN estimate > 0 THEN LPAD(CONCAT(ROUND(data * 100 / estimate, 0), "%"), 7, ' ')
        WHEN end_time IS NULL THEN LPAD('0%', 7, ' ')
        ELSE LPAD('100%', 7, ' ')
    END AS "Done(%)"
FROM performance_schema.clone_progress;

+-----------+-----------+---------------------+---------------------+------------+------------------+---------+
| stage     | state     | START TIME          | FINISH TIME         | DURATION   | Estimate         | Done(%) |
+-----------+-----------+---------------------+---------------------+------------+------------------+---------+
| DROP DATA | Completed | 2026-01-05 15:34:10 | 2026-01-05 15:34:13 |     3.07 s |              0MB |    100% |
| FILE COPY | Completed | 2026-01-05 15:34:13 | 2026-01-05 15:58:13 |       24 m |        347,246MB |    100% |
| PAGE COPY | Completed | 2026-01-05 15:58:13 | 2026-01-05 15:58:13 |  507.57 ms |             18MB |    100% |
| REDO COPY | Completed | 2026-01-05 15:58:13 | 2026-01-05 15:58:14 |   368.4 ms |              0MB |    100% |
| FILE SYNC | Completed | 2026-01-05 15:58:14 | 2026-01-05 15:58:15 |  895.55 ms |              0MB |    100% |
| RESTART   | Completed | 2026-01-05 15:58:15 | 2026-01-05 15:58:21 |     6.47 s |              0MB |    100% |
| RECOVERY  | Completed | 2026-01-05 15:58:21 | 2026-01-05 15:58:23 |     1.64 s |              0MB |    100% |
+-----------+-----------+---------------------+---------------------+------------+------------------+---------+

-- 查看克隆最终状态
mysql> SELECT * FROM performance_schema.clone_status;

+------+------+-----------+-------------------------+-------------------------+--------------------+----------------+----------+---------------+------------------+-----------------+---------------+
| ID   | PID  | STATE     | BEGIN_TIME              | END_TIME                | SOURCE             | DESTINATION    | ERROR_NO | ERROR_MESSAGE | BINLOG_FILE      | BINLOG_POSITION | GTID_EXECUTED |
+------+------+-----------+-------------------------+-------------------------+--------------------+----------------+----------+---------------+------------------+-----------------+---------------+
|    1 |    0 | Completed | 2026-01-05 15:34:09.386 | 2026-01-05 15:58:22.894 | 192.168.31.188:3306 | LOCAL INSTANCE |        0 |               | mysql-bin.004291 |       630818978 |               |
+------+------+-----------+-------------------------+-------------------------+--------------------+----------------+----------+---------------+------------------+-----------------+---------------+

等待克隆完成后，会自动重新启动从库 MySQL 实例。

启动主从复制

从库配置并启动主从复制：

mysql> show variables like '%server_id%';
+----------------+-------+
| Variable_name  | Value |
+----------------+-------+
| server_id      | 2     |
| server_id_bits | 32    |
+----------------+-------+

-- 配置从库
mysql> change master to master_host='192.168.31.188',
master_port=3306,
master_user='repl',
master_password='P@ssw0rd',
master_log_file='mysql-bin.004291',
master_log_pos=630818978;

-- 启动主从同步
mysql> start slave;
Query OK

-- 检查主从同步状态
mysql> show slave status \G;
*************************** 1. row ***************************
               Slave_IO_State: Waiting for source to send event
                  Master_Host: 192.168.31.188
                  Master_User: repl
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mysql-bin.004291
          Read_Master_Log_Pos: 633519126
               Relay_Log_File: mysql-relay-bin.000002
                Relay_Log_Pos: 2697758
        Relay_Master_Log_File: mysql-bin.004291
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB: 
          Replicate_Ignore_DB: 
           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: 633516410
              Relay_Log_Space: 2700684
              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: 1
                  Master_UUID: 0df21031-d536-11ee-a0cd-005056a91cf7
             Master_Info_File: mysql.slave_master_info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: Replica has read all relay log; waiting for more updates
           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: 0
         Replicate_Rewrite_DB: 
                 Channel_Name: 
           Master_TLS_Version: 
       Master_public_key_path: 
        Get_master_public_key: 0
            Network_Namespace: 
1 row in set

可以发现，主从已经恢复正常同步。

写在最后

以前搭建 MySQL 主从都是使用 mysqldump 或者 PXB 备份恢复，耗时耗力。使用 clone 插件，只要符合它的限制条件，将是非常实用便捷的搭建方式。

📚 推荐阅读：DBA 学习之路

如果这篇文章对你有帮助，推荐访问我的 Oracle DBA 系统学习站点，涵盖 100 天完整学习路线：

🔧 Oracle 安装部署 · RMAN 备份恢复 · Data Pump 数据迁移
🏗️ RAC 高可用 · DataGuard 容灾 · 多租户架构
🔍 故障排查 · 升级迁移 · GoldenGate 数据同步

👉 立即访问 ora100.com →

最后修改时间：2026-04-19 15:18:27

「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」

关注作者