重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: MYSQL 8.4 数据库克隆 [打印本页]

作者: 郑全 时间: 2026-3-15 14:04
标题: MYSQL 8.4 数据库克隆
MySQL克隆插件从8.0.17引入，能够提供快速、高效的数据库物理克隆能力，大幅简化数据复制、备份恢复和主从搭建流程。

下面列出简要步骤：

1.授权克隆需要权限
  GRANT CLONE_ADMIN, BACKUP_ADMIN ON *.* TO 'repuser'@'%';

2.安装mysql clone插件
  install plugin group_replication soname 'mysql_clone.so';

3.配置克隆源，数据库从哪里来

  RESET PERSIST;
  SET GLOBAL clone_valid_donor_list = '192.168.133.10:3306';

4.停止复制
STOP GROUP_REPLICATION;

5.执行克隆操作
CLONE INSTANCE FROM 'repuser'@'192.168.133.10':3306 IDENTIFIED BY 'szdb_4U';

6.查看克隆进度
数据克隆完成后，接收方的MySQL服务器实例将自动重启，当看到以下内容时，表示克隆完成

mysql> show binary logs;Restarting mysqld...
2026-03-15T03:32:31.159376Z mysqld_safe Number of processes running now: 0
2026-03-15T03:32:31.169378Z mysqld_safe mysqld restarted

mysql> select stage, state, end_time from performance_schema.clone_progress;
+-----------+-----------+----------------------------+
| stage    | state    | end_time                |
+-----------+-----------+----------------------------+
| DROP DATA | Completed | 2026-03-15 11:29:40.960623 |
| FILE COPY | Completed | 2026-03-15 11:29:44.856267 |
| PAGE COPY | Completed | 2026-03-15 11:29:44.860852 |
| REDO COPY | Completed | 2026-03-15 11:29:44.868506 |
| FILE SYNC | Completed | 2026-03-15 11:29:44.880867 |
| RESTART | Completed | 2026-03-15 11:29:48.106979 |
| RECOVERY  | Completed | 2026-03-15 11:29:48.676772 |
+-----------+-----------+----------------------------+
7 rows in set (0.00 sec)

7.启动组复制
START GROUP_REPLICATION;

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)