MySQL 企业备份执行 MySQL 数据库的热备份操作。该产品设计用于高效且可靠地备份由 InnoDB 存储引擎创建的表。为了完整性,它也可以备份来自 MyISAM 和其他存储引擎的表。MySQL Enterprise Backup performs hot backup operations for MySQL databases. The product is architected for efficient and reliable backups of tables created by the InnoDB storage engine. For completeness, it can also back up tables from MyISAM and other storage engines.
下面的讨论简要概述了 MySQL 企业备份。有关更多信息,请参阅 MySQL 企业备份手册,可在以下网址获取:https://dev.mysql.com/doc/mysql-enterprise-backup/en/。The following discussion briefly summarizes MySQL Enterprise Backup. For more information, see the MySQL Enterprise Backup manual, available at https://dev.mysql.com/doc/mysql-enterprise-backup/en/.
热备份是在数据库运行并且应用程序正在读写数据库时进行的。这种类型的备份不会阻塞正常的数据库操作,并且能够捕获在备份过程中发生的更改。出于这些原因,当您的数据库“成长”时,热备份是非常理想的——当数据量大到备份需要耗费大量时间,并且数据对您的业务非常重要,以至于必须捕获每一个细微的变动,而无需将您的应用程序、网站或网络服务下线。Hot backups are performed while the database is running and applications are reading and writing to it. This type of backup does not block normal database operations, and it captures even changes that occur while the backup is happening. For these reasons, hot backups are desirable when your database “grows up” -- when the data is large enough that the backup takes significant time, and when your data is important enough to your business that you must capture every last change, without taking your application, website, or web service offline.
MySQL 企业备份对所有使用 InnoDB 存储引擎的表进行热备份。对于使用 MyISAM 或其他非 InnoDB 存储引擎的表,它执行“温备份”,在备份期间数据库继续运行,但这些表无法被修改。为了提高备份操作的效率,您可以将 InnoDB 指定为新表的默认存储引擎,或将现有表转换为使用 InnoDB 存储引擎。MySQL Enterprise Backup does a hot backup of all tables that use the InnoDB storage engine. For tables using MyISAM or other non-InnoDB storage engines, it does a “warm” backup, where the database continues to run, but those tables cannot be modified while being backed up. For efficient backup operations, you can designate InnoDB as the default storage engine for new tables, or convert existing tables to use the InnoDB storage engine.