mysqlinnodbmysql-backup

How to take Physical backup for non-enterprise MySQL INNODB engine


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 ?


Solution

  • 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

    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.

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