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
I. Preface:
After the database server is set up, the first thing we need to do is not to consider which MySQL-carried servers should be running on the server that supports the database.ProgramBut how to recover to the last normal state after the
This section describes automatic database backup and restoration methods after database destruction. Here, we use mysqlhotcopy and define a Shell script to implement automatic database backup. In addition, the entire process of automatic data backup
Create an automatic backup scriptHere, in order to make the database tutorial backup and recovery meet our actual requirements, use a Shell script that meets the requirements to automate the entire backup process.[Root @ CentOS ~] # Vi mysql
When the database server is established, the first thing we need to do is not to consider what MySQL-enabled programs are running on this database-supporting server, but how to recover to the last normal state after the database has been compromised,
Original address: HTTP://WWW.TUICOOL.COM/ARTICLES/RZRNQ2Xtrabackup 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
Percona xtrabackup backup MySQL (full backup and incremental backup)Xtrabackup IntroductionPercona Xtrabackup is an open source, free MySQL database hot backup software that can back up non-blocking databases for InnoDB and XTRADB storage engines
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 table lock). Xtrabackup supports all
MySQL automatic backup and restoration method after Database destruction 12th page bitsCN.com
I. preface:
After the database server is set up, the first thing we need to do is not to consider which MySQL-initiated programs should be run on the
Establish an automatic backup scriptHere, in order to make the database tutorials backup and restore meet our actual requirements, use a qualifying shell script to automate the entire backup process.[Root@centos ~]# vi mysql Tutorial-backup.sh← set
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.