Mysql backup method summary, mysql backup Summary

Mysql backup method summary, mysql backup Summary

Different DBAs for Mysql backup have different preferences!

I will first list the following methods:

1. Use mysql's automatic dump tool, and use Shell to execute crontab;

2. XtraBackup (it has been quite popular in recent years)

About: http://www.percona.com/doc/percona-xtrabackup/intro.html
Installation: http://www.percona.com/doc/percona-xtrabackup/installation/yum_repo.html
Note: Both innodb and MyISAM Hot Standby are supported. MyISAM needs to lock the table.

3. automysqlbackup

Download link http://sourceforge.net/projects/automysqlbackup? Source = dlp
A simple and easy-to-use tool can back up MYSQL Databases every day, every week, every month. Supports encryption.
It can automatically delete outdated backup packages.

The biggest purpose of backup is recovery. Therefore, no matter what method you use, I personally recommend that you perform regular recovery!