yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm yum list | grep percona yum install percona-xtrabackup ##备份 innobackupex --user=DBUSER --password=DBUSERPASS /path/to/BACKUP-DIR/ #应用备份 innobackupex --apply-log /path/to/BACKUP-DIR #复制到目标库 scp -r /path/to/BACKUP-DIR root@slave_host:/data/ ##停止数据库 /etc/init.d/mysql stop ###恢复备份 innobackupex --copy-back /path/to/BACKUP-DIR 或者 innobackupex --defaults-file=/etc/my.cnf --defaults-group=mysqld1 --copy-back /path/to/BACKUP-DIR chown -R mysql:mysql /path/to/BACKUP-DIR 主从 CHANGE MASTER TO MASTER_HOST='', MASTER_USER='', MASTER_PASSWORD='', MASTER_PORT='' MASTER_LOG_FILE='', MASTER_LOG_POS=;