Differential backup: Back up data based on full backup. Because the tar command cannot implement differential backup, this article explains how to use the dump and restore commands. Of course, the dump and restore commands can also implement full backup and Incremental
Tags: SFDsDay05I. Data backup and recovery-incremental and incremental recoveryA.binlog Log description (binary file): one of the types of log files used by the MySQL database service. Logs a SQL command other than a query. Not enabled by default Queries for SQL include: Select desc Show Command not queried: Insert update delete create drop grant revoke B. Enable
Brief introduction
For the choice of Linux as an application platform for small and medium-sized enterprises or Web sites, often face how to achieve remote Data backup or Web site mirror image of the problem, although there are commercial backup and mirror products to choose from, but these products are often too expensive prices. So how to use free software to efficiently implement remote
Rsync is very powerful, here are the parameters I used to do a directory backup with rsync:rsync -ruPi -plEt /home/op/photo/ /remote_backup/photo/ --dry-run-R Loop Directory-U update mode, synchronizing only the updated-P equals--partial--progress, shows Progress, and supports breakpoint continuation-I displays the synchronization details for each file, see the--itemize-changes section below-P Reserved Perm
Using Rman to implement incremental database recovery based on SCN is a common method of repairing gap in DG. In fact, this method can also use the conventional incremental recovery, through manual control, to achieve a certain specific business requirements of the database (special Data Migration). The main approach is to get the data files of the backup minimum
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
Full Backup and restore
These scripts are examples on the rsync Website:
1. Incremental backup of data to the central server every seven days
#! /Bin/sh
# This script does personal backups to a rsync backup server. You will end up# With a 7-day rotating Incre
username landing, try rsync-a max@144.16.251.213::test test
Iv. some scripts to learn from
These scripts here are examples of rsync sites:
1, every seven days the data to the central server to do incremental backup
#!/bin/sh
# This script does personal backups to a rsync
Xtrabackup_log, applies the submitted transaction information changes to the INNODB data or tablespace, and rolls back uncommitted transactions
(2) Incremental backup principle
Incremental backups are mainly by copying pages with changes in the InnoDB (the LSN is greater than the LSN number in xtrabackup_checkpoints). Incr
Recently, I have studied the incremental synchronization of files, focusing on the differential encoding of files, because this is actually the core of file synchronization. Rsync in Linux is the most widely usedAlgorithmBut this algorithm has its own defect, that is, when two files are completely irrelevant, the efficiency of differential encoding is very low and almost unacceptable!
With this problem, I
You can first use Rpm-qa |grep rsync to see if rsync is installedLet's talk about the Rsyns configuration process.I. Configuring the server SideFirst edit the/etc/rsyncd.conf content as follows:uid = nobody #进行备份的用户nobody为任何用户gid = nobody #进行备份的组 nobody为任何组use chroot = no #不使用chrootmax connections = 10 #最大连接数log file = /var/log/rsyncd.log #日志文件[rsyncd] # 这里是认证的模块名path = /home/test/ #参与同步的目录ignore errors # 可
max@144.16.251.213: Test test
4. Some useful scripts
These scripts are examples on the rsync Website:
1) Incrementally back up data to the central server every seven days
#! /Bin/sh
# This script does personal backups to a rsync backup server. You will end up# With a 7-day rotating Incremental
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
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.