Why percona-xtrabackup
We have discussed MySQL Cold Standby, Hot Standby, mysqldump, and hot copy to ensure data consistency. Because mysql cold backup, mysqldump, and mysql hot copy cannot achieve Incremental backup, Incremental backup is used in a large number of actual environments, and percona-
is a MySQL database backup tool provided by Percona and features:(1) The backup process is fast and reliable;(2) The backup process does not interrupt the executing transaction;(3) Can save disk space and traffic based on functions such as compression;(4) Automatic implementation of backup inspection;(5) Fast restore speed.Official link address: http://www.percona.com/software/percona-xtrabackup; You can d
Label:Original address: HTTP://WWW.TUICOOL.COM/ARTICLES/RZRNQ2 Xtrabackup Introduction 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 ser
streams that can be saved directly to a remote machine (useful when the hard disk space is low)The MySQL database itself provides tools that do not support true incremental backups, and binary log recovery is point-in-time (Point-in-time) recovery instead of incremental backups. The Xtrabackup tool supports incremental backups of the InnoDB storage engine and works as follows:(1) Complete a full backup fir
Use the Xtrabackup tool to back up and restore (a required tool for MySQLDBA) bitsCN.com
Xtrabackup------ Necessary tools for MySQL DBA
Note:
1) documents reference http://www.percona.com/docs/wiki/percona-xtrabackup:start
2) mysql version 5.1.50 or later.
1. introduction and installation of
XtraBackup enables MySQL to redo master-slave replication without stopping services
You can use mysqldump to implement MySQL master-slave synchronization without stopping services, but this efficiency is relatively low. XtraBackup is used to achieve this, which is more efficient!
X
database) is still the best cold backup, and the speed is fast, it is also the best way to ensure data consistency, but today this situation does not seem to work, Xtrabackup !!!
2. Learn about Xtrabackup
Xtrabackup:1. fast and reliable backup; 2. uninterrupted transaction processing during Backup; 3. Saving disk space and network bandwidth; 4. Automatic Backup
Tags: mysql xtrabackup backup toolUsing Xtrabackup to make backups of databasesXtrabackup is an open source Backup tool developed by Percona, which differs from the Ibbackup Backup tool. Ibbackup is a paid backup tool, and ibbackup is inferior to xtrabackup in its backup performance. Both Ibbackup and
Original: http://www.drupal001.com/2014/02/percona-xtrabackup-mysql/Xtrabackup IntroductionPercona 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
remote machine (this is useful when the local hard disk space is insufficient)
How Xtrabackup works
* Xtrabackup-the specific principle remains to be studied...* Innobackupex full-Database Backup1. call xtrabackup to back up the innodb tablespace file (this instant image Time1). During the innodb table backup, the database is not locked, external users can conti
Use XtraBackup for MySQL master-slave replication without locking tables
Xtrabackup is an open-source project of percona to implement the innodb Hot Backup function similar to InnoDB's official Hot Backup tool. It can quickly back up and restore MySQL databases. Xtrabackup c
Percona xtrabackup ( PXB) is a backup tool developed by Percona Company for the physical hot standby of MySQL database, supporting MySQL (Oracle), Percona Server and MariaDB, and all open source, is the industry's conscience. Tool SetAfter the package is installed, there are 4 executable files, as follows:usr├── bin│ ├── innobackupex│ ├── xbcrypt│ ├── xbstr
Xtrabackup is an open-source project of percona. It supports hot backup of innodb, XtraDB, and MyISAM (locks the table)The MyISAM storage engine locks tables and is also very depressing because Innodb and MyISAM storage engines are used online, which is a headache !!Xtrabackup is a tool used to back up InnoDB data. It supports online Hot Backup (data read/write is not affected during Backup) and is a good a
environments, modify and implement them on your own.Modify the MySQL configuration file of the master database and slave Database
1. Master
Vim/etc/my. cnf
2. Slave:
Vim/etc/my. cnfServer-id = 2 datadir =/var/lib/mysql install XtraBackup1 and add the source
Yum install
Check whether it is successfully added:
Yum list | grep percona
If the execution is correct, the output information is usually similar:Perc
Introduction to xtrabackup bitsCN.com
Mysql backup method 1. mysqldumpLow efficiency, slow backup and restoration, and any data insertion and update operations will be suspended 2. mysqlhotcopyMysqlhotcopy is used to back up the myisam data table. during the backup process, any data insertion and update operations will be suspended. 3. prepare a slave server for dedicated backup (master-slave mode) 4.
Tags: http os io using strong ar file Data divPercona xtrabackup backup MySQL large database (full and incremental backup) Article directory[Hide]
Xtrabackup Introduction
Xtrabackup Installation
Xtrabackup Tools Introduction
Innobackupex How to use
Tags: innobackupex backup xtrabackup Backup principle backup classified physical backup scriptI. Why a backup is requiredIn a real-world production environment, it is a mistake to delete the operation, the hardware damage will result in the data is not available, this time we need to backup to achieve disaster recovery. Hardware-level redundancy is also required, such as RAID, and it is not a substitute for backup operations, since data is not deleted
Xtrabackup, an Open-source software developed by Percona, is an open source alternative to the InnoDB hot standby tool Ibbackup (fee-based commercial software). The xtrabackup consists of parts: Xtrabackup and Innobackupex, where the Xtrabackup tool is used to back up the tables of the InnoDB and XTRADB engines; The In
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.