逻辑备份的最大优点是对于所有存储引擎都可以用同样的方法来备份,是目前中小型系统最常使用最简单的备份方式。本小节将主要介绍 MySQL 的逻辑备份。 1. 什么是逻辑备份 简单的说,逻辑备份就是将数据库中的数据备份为文本文件,备份文件可以查看和编辑。针对中小型系统,逻辑备份要来的简单高效。
1.1 Backup and Recovery Types This section describes the characteristics of different types of backups. Physical (Raw) Versus Logical Backups Physical backups consist of raw copies of the directories and files that store database contents. This type of backup is suitable for large, important datab...
XtraBackup分为开源版本和商业版本(Percona XtraBackup),两者功能类似。 以Percona XtraBackup为例,进行完全备份的命令如下: innobackupex --user=[username] --password /path/to/backup/directory 1. 恢复操作需要先准备备份文件,使其处于可恢复状态: innobackupex --apply-log /path/to/backup/directory 1. 然后停...
The text data of the logical backup is very easy to compress. JuiceFS will use the current state-of-the-art Zstandard compression algorithm to compress and save the data by default. It has very good write performance (up to 300MB/s) and is much faster than mydumper's compression function....
With MySQL, physical backups are performed by the MySQL Enterprise Backup product, and logical backups are performed by the mysqldump command. These techniques have different characteristics in terms of size and representation of the backup data, and speed (especially speed of the restore operation)...
Logical MySQL backup tool Mydumper 0.9.1 now available The new Mydumper 0.9.1 version, which includes many new features and bug fixes, is now available. You can download the code fromhere. A significant change included in this version now enables Mydumper to handle all schema objects!! So ...
The Operator does logical backups, querying Percona XtraDB Cluster for the database data and writing the retrieved data to the backup storage. The backups are done using thePercona XtraBackuptool. The Operator allows doing backups in two ways: ...
数据灾备(DBS)可满足MySQL数据库的异地备份、长期归档、单表恢复等需求。本文介绍如何使用DBS实现RDS MySQL的自动备份及数据恢复。 创建备份计划 具体操作,请参见创建备份计划。 说明 购买时,选择数据库类型为MySQL,并选择备份方式为逻辑备份。 如需了解DBS在备份和恢复MySQL数据库时的具体粒度...
relay_log_recovery=1slave-parallel-type=LOGICAL_CLOCKslave-parallel-workers=16 master配置 代码语言:javascript 代码运行次数:0 运行 AI代码解释 # Binary Logging.sync_binlog=1log-bin=mysql-bin binlog_format=mixed binlog_row_image=minimal gtid_mode=on ...
可能的值有 "logical": 逻辑冷备, "physical": 物理冷备。示例值:physical BackupId Integer 备份子任务的ID,删除备份文件时使用示例值:1000 Status String 备份任务状态。可能的值有 "SUCCESS": 备份成功, "FAILED": 备份失败, "RUNNING": 备份进行中。示例值:SUCCESS FinishTime String 备份任务的完成时间...