Xtrabackup and innobackupex Hot Backup MySQL DataXtrabackup and innobackupex Hot Backup MySQL Data 1. xtrabackup introduction and backup principles Description: Xtrabackup is an open-source software developed by percona. It can quickly back up and
Directory Classification of backups Physical Backup and logical backup Hot and cold backup Full Backup and Incremental backup More content Full backup and Recovery Import and export databases in SQL statement format Export data in SQL statement
In order to ensure data security, the data needs to be backed up regularly. There are a number of ways to backup, and the effect is different. Once there is an error in the data in the database, you need to use the backed-up data for restore
This article is based on the Dbaplus community on the 104th issue of the online sharing.Original: http://dbaplus.cn/news-11-1267-1.htmlInstructor IntroductionFeng YuPoint-and-melt Network Advanced DBA
Oracle OCM, MySQL OCP;
Currently
Mysql Backup Tools Xtraback full-volume and incremental testingXtrabackup is an open source project for Percona, can be hot backed up InnoDB, XtraDB, and MyISAM (Will lock the table)Official website
Mysql-12-mysql backup and recovery, mysql-12-mysql backup
1. Database Backup
Backup = copy and management to prevent data loss and record user operation records. The most effective backup is to back up the IT architecture.
Principles:
(1) databases
Copy Address: Https://www.linuxyw.com/download/xtrabackup.pdf http://www.linuxyw.comemail:[email protected] Xtrabackup to MySQL database backup and restore this document, just a simple study of the next, for the database full and ready to
MYSQL database automatic local remote dual-backup MYSQL incremental backup to build a high-security E-commerce website (automatic local/remote dual-backup of website files and databases) architecture diagram
We will continue to introduce the
First, Xtrabackup Introduction
A, Xtrabackup is what
Xtrabackup is a tool for data backup of InnoDB, which supports online hot backup (without affecting data reading and writing during backup), is a good substitute for the commercial Backup tool
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.