The idea and method of Mysql database Incremental backup, mysql incremental
MySQL database Incremental backup. Before that, modify our database configuration file/etc/my. cnf to enable the bin-log function. Next, I have referenced some methods on the Internet and wrote them
I.
What is full backup, differential backup, and Incremental backup?
Introduction to Backup Types and combined backup solutionsFull backupBacking up all selected folders does not depend on the file archive attribute to determine
, 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 backup of the whole library (InnoDB
MySQL backup and recovery-percona-xtrabackup incremental backup and recovery bitsCN.com article review
In the previous article, we talked about the use of percona-xtrabackup software. This article describes how percona-xtrabackup achieves incremental backup and recovery.
2
Oracle rman backup and RestorationRMAN supports Incremental Backup: databases, tablespaces, and data files.Only used blocks can be backed up as backup setIng between tablespaces and data files: dba_data_files/v $ datafile_headerIn noarchivelog mode, you can use RMAN to back up the read-only and offline tablespaces.Orac
] full]# cp-r/backup/mysql/full/2015-05-07/2015-05-07_18-14-25/ib*/var/lib/mysql/# If the InnoDB data file is placed in a separate directory, it needs to be copied separately[[email protected] full]# chown-r Mysql:mysql/var/lib/mysql # Modify owner, owning group[[Email protected] full]# service MySQL start[[email protected] full]# mysql-u root-p123456789 # Login Database View data has been restoredMariaDB [(None)]> show databases;+--------------------
1. PerconaXtrabackup Overview 1. Xtrabackupbin directory file introduction 1) innobackupexinnobackupex is a symbolic link of xtrabackup. Examples... 1. Percona Xtrabackup introduction
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 C can be used to pre
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 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 e-commerce system architecture related to file
-52-43/
[Root @ local-db opt] # innobackupex -- defaults-file =/etc/my. cnf -- user = root -- password = 123456 -- copy-back/bak/mysql/2015-07-08_18-52-43/
There are two steps for recovery:
The first step is apply-log. to speed up, we recommend that you set -- use-memory. After this step is completed, the backup files under the/bak/mysql/2015-07-08_18-52-43/directory are ready.
Step 2 is copy-back, that is, copy the
Tags: mysql automatic hot standbyPros: Hot backup, no impact on business, incremental backup, remote backup.Purpose: Automatically package backup to remote 10.0.0.111 backup serverPremise:1. Installing XtrabackupYum Install http://www.percona.com/downloads/percona-release/re
---------- Full backup -----------Backup set: block backup used in data filesImage copy: a complete copy of all data files.---------- Incremental Backup -----------A backup of a database that has changed since a specific time poin
] 90409[[email protected] data]# mysql-uroot-pli123456-s/data/3306/mysql.sockmysql> show databases;+--------------------+|Database |+--------------------+|Information_schema | |lichengbing |#数据表恢复成功 |Lilongzi | |MySQL | | Performance_schema |+--------------------+5 rows in Set (0.00 sec)And then simulate the incremental backup.Insert a few rows of data in a new[Email protected] opt]# mysql-uroot-pli123456-s/data/3306/mysql.sock lichengbing
The company's Linux server uses a common desktop and lacks a disaster recovery mechanism. The company stores a large amount of data on this server. Once a fault occurs, the consequences are unimaginable. Therefore, it is necessary to effectively back up important data of this machine. After several days of data collection, I finally compiled my own Linux script to implement a complete monthly backup and daily Incr
During traditional Oracle backup, database files are backed up by copying operating system files. The backup granularity is data files, and the data files may be large, however, it is empty blocks and there is no Oracle data, but because it is a file copy, you need to back up the entire file.
The backup set value of ramn backs up used data blocks and supports
Brief introduction
1 • Concept of full and incremental backups2 • Full backup with mysqldump3 · Using Mysqldump for table structure backup4 • Two methods of full backup recovery5 • Incremental backup with flush logs6 • Increment
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.