如何为非企业版MySQL INNODB引擎进行物理备份 [英] How to take Physical backup for non-enterprise MySQL INNODB engine

问题描述

根据文档，如果您使用的是MYISM，则应该可以对MySQL进行物理备份.即复制数据文件. 但是，为了对INNODB Engine进行物理备份"，您需要MysqlEnterprise. 我目前不在使用MySQL Enterprise，数据库大小为100GB. 我不想使用mysqldump，但想进行物理备份.有办法实现吗?

According to documentation, if you are using MYISM, it should be possible to take physical backup of MySQL. i.e. copying data files. But in order to take "Physical Backup" for INNODB Engine, you need MysqlEnterprise. I am not using MySQL Enterprise at the moment and have Database of size 100GB. I do not want to use mysqldump but want to do a physical backup. Is there a way to achieve this ?

推荐答案

Percona XtraBackup是免费的开放源代码，并且可以与使用InnoDB的MySQL及其衍生版本免费，开放源代码一起使用.

Percona XtraBackup is free and open-source, and works with free, open-source distributions of MySQL and its derivatives that use InnoDB.

https://www.percona.com/software/mysql-database/percona-xtrabackup

与Percona Server for MySQL结合使用时，Percona XtraBackup可提供当前可用的唯一真正的非阻塞在线，实时的交易系统实时备份.

When used in combination with Percona Server for MySQL, Percona XtraBackup provides the only true non-blocking online, real-time backup of transactional systems currently available.

实际上，Percona XtraBackup也可以与MySQL Community Edition一起很好地工作.

In fact Percona XtraBackup works fine with MySQL Community Edition too.

这篇关于如何为非企业版MySQL INNODB引擎进行物理备份的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！