percona-xtrabackup备份恢复mysql

2019-12-24

Percona XtraBackup is an open-source hot backup utility for MySQL - based servers that doesn’t lock your database during the backup.

超过50G的数据库,mysqldump会导致table锁,用户无法读取写入.
It can back up data from InnoDB, XtraDB, and MyISAM tables on MySQL 5.1 [1], 5.5, 5.6 and 5.7 servers, as well as Percona Server with XtraDB

#yum -y install percona-xtrabackup-24-2.4.17-1.el7.x86_64.rpm
#tar
#xtrabackup --backup --target-dir=/mnt/data/all/ --user=root --password=123456 --socket=/tmp/mysqld.sock
#innobackupex is the symlink for xtrabackup
#After Percona XtraBackup 2.3 release the recommend way to take the backup is using the xtrabackup script.
innobackupex --decompress --remove-original /jesong/mysql
innobackupex --defaults-file=/jesong/mysql/backup-my.cnf --apply-log /jesong/mysql
#xtrabackup --prepare --apply-log-only --target-dir=/mnt/data/all/
#xtrabackup --copy-back --target-dir=/jesong/mysql

chown -R mysql.mysql /var/lib/mysql
~

#percona-backup-for-mongodb
XtraDB存储引擎是由Percona开发的一款MySQL数据库的高性能存储引擎,其目的是用来代替InnoDB存储引擎,可用于需要更高性能的环境。
XtraDB是MariaDB和Percona Server数据库的存储引擎,旨在作为InnoDB的直接替代品,MariaDB 10.1使用Percona的XtraDB为默认存储引擎。

Percona Backup for MongoDB
Percona Server为 MySQL 数据库服务器进行了改进,在功能和性能上较 MySQL 有着很显著的提升。

分类:数据库 | 标签: |

相关日志

评论被关闭!