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
update only
TOPG maintain the original attributes of the file, such as the owner, time parameters
--progress refers to the display
--delete means that if this file is deleted by the server side, then the client also deletes the file accordingly, maintaining true consistency
Root is User name
@192.168.100.150 for server IP
:: The following RSYNCD is the Certified module name
/home/test directory name for backup to local
--password-file=/etc/rsync.secr
, 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
Powerful rsync website automatic backup tool
Rsync is a data image backup tool in unix-like systems-remote sync. A Fast Incremental Backup Tool, Remote Sync, supports local replication or synchronization with other SSH and
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;+--------------------
Tags: two times error remote path Oca/etc/images City ExampleEight weeks two sessions (January 30)10.28 Rsync Tools Introduction10.29/10.30 rsync Common Options10.31 rsync sync via sshI. Introduction of RSYNC ToolsLinux system has a lot of data backup tools, commonly used is
-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
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
Server Information)
Server configuration file (/etc/rsyncd. conf). This file does not exist by default. Please create it.
The procedure is as follows:
# Touch/etc/rsyncd. conf # create rsyncd. conf, which is the configuration file of the rsync server.# Touch/etc/rsyncd. secrets # create rsyncd. secrets, which is the user password file.# Chmod 600/etc/rsyncd. secrets # Set the File Attribute of the rsyncd. secrets password file to root and set the p
1.rsync Introduction"Rsync is a data-mirroring backup tool for Linux systems. Use the Quick Incremental Backup tool Remote Sync can be synchronized remotely, support local replication, or synchronize with other SSH, Rsync hosts2.r
---------- 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
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
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
The password file format is simple, and the Rsyncd.secrets content format is:
User name: Password
What we rsyncd.secrets in the example is similar to the following: In the document, some systems do not support long passwords and try to set them.
Easylife:keerRoot:mike
Chown Root.root rsyncd.secrets #修改属主chmod rsyncd.secrets #修改权限
Note: 1, will rsyncd.secrets this password file file attribute to root owned, and permissions to set to 600, otherwise can not
simple, and the Rsyncd.secrets content format is:
User name: Password
What we rsyncd.secrets in the example is similar to the following: In the document, some systems do not support long passwords and try to set them.
Easylife:keerRoot:mike
Chown Root.root rsyncd.secrets #修改属主chmod rsyncd.secrets #修改权限
Note: 1, will rsyncd.secrets this password file file attribute to root owned, and permissions to set to 600, otherwise can not backup success! For sec
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.