percona backup

, according to this information, can easily use Backup to redo slave.3. Official documents: Http://www.percona.com/docs/wiki/percona-xtrabackup:startB, what can xtrabackup doOnline (Hot) backup InnoDB, xtradb tables for the entire libraryIncremental backup based on Xtrabackup's last

, partial backup, hot standby for InnoDB storage engine (implemented using MVCC mechanism), but not practical;CP, Tar,rsync and other file system Tools: Physical Backup tool for all storage engines, cold standby, full backup, partial backup;LVM2 snapshot: Almost hot standby, with the help of file system tools to achiev

First, Xtrabackup Simple overview:Percona Xtrabackup is open source free MySQL database hot backup software, it can be InnoDB and XTRADB storage Engine database non-blocking backup (for MyISAM backup also need to add a table lock). Xtrabackup supports all Percona servers, MySQL, mariadb, and drizzle.Xtrabackup Advantag

Use XtraBackup to perform Online Incremental backup and database restoration for MySQL 1. Introduction to Percona Xtrabackup 1. Xtrabackup bin directory file Introduction 1) innobackupex Innobackupex is a symbolic link of xtrabackup. innobackupex still supports all features and syntax as 2.2 version did, but is now deprecated and will be removed in next major release. 2) xtrabackup A binary file compiled by

MySQL backup lock and mysql backup Both logical and physical backups depend heavily on FTWRL (Flush Table With Read Lock) to obtain consistency points ). This lock is highly lethal, because during the lock period, the entire database cannot provide write services externally. In addition, because FTWRL needs to close the table, if there is a large query, it will lead to FTWRL waiting, which leads to a longer

after the backup is restored. Based on this information, you can easily use the backup to redo slave. Xtrabackup: Select the appropriate version. Here, select binary. Extract To the/usr/src/directory, unzip the directory name percona-xtrabackup-2.1.3, enter the bin directory, you can directly use the innobackupex command# Pwd/Usr/src/

1. System Backup Based on the degree of preparation of the backup system, it can be divided into three categories: Cold backup, warm backup and hot backup. 1.1 The cold backup system is not installed or configured to the same or s

[MySQL] innobackupex online backup and recovery (full and incremental) bitsCN.com [MySQL] innobackupex online backup and recovery (full and incremental) Install Statement: The following operations should be performed by mysql users. First, download the source tar package through wget: [Plain] Wget http://www.percona.com/redir/downloads/XtraBackup/LATEST/source/percona