Intended audience
This article is tested in linux and mysql 4.1.14. After modification, it may be applicable to mysql 4.0, 5.0 and other versions.
This article is applicable to mysql that does not enable replication. If replication is started, you may not need to adopt this backup policy or modify relevant parameters.
Each person may have different backup policies. Therefore, Please modify the policies base
First, the experimental environment
Host Name
Network card IP
Default Gateway
Use
Nfs-server
10.0.0.11
10.0.0.254
Rsync Server Side
web-client01
10.0.0.12
10.0.0.254
Rsync Customer Service Side
web-client02
10.0.0.13
10.0.0.254
Rsync Customer S
CentOS Remote Backup Using rsync
This article provides a quick way to back up the most common things in a typical Web host scenario: website files and database data. We will set up a complete daily backup of the folder of a website and copy the data to a remote server (this can also work on another VPS ). We will also set up an
First, the advantages and disadvantages of rsync
Compared with the traditional CP and tar backup methods, Rsync has the advantages of high security, fast backup, support incremental backup, etc., through
DB2 offline and online full backup, Incremental backup and recovery operations1. Full offline backup1) first, make sure that no user uses DB2:$ Db2 list applications for db sample2) Stop the database and restart it to disconnect all connections:Db2stop forceDb2start3) execute the BACKUP command: Use TSM as the
Usage type: the system load is concentrated in a certain period of time, such as 8 hours during the day, and is usually idle at night. Therefore, data can be backed up at night.
It corresponds to full-Database Backup:
Http://blog.csdn.net/jacson_bai/article/details/39636915
1. env:IP Address: 10.244.171.180/181Oracle Database Oracle 11.2.0.3OS RHEL 5.5Backup toos: rman, Shell, crontab
2. Backup Plan (
Tags: style http color COM uses strongFor many beginners, it is difficult to understand the two concepts of differential and incremental backup, in this article we will explain the specific definitions and differences between incremental backups and differential backups: Definition of differential backup:Backs up data that has changed since the last full
Linux Rsync data Image and backup steps 1: install rsync to download the latest rsync package, the latest package in http://rsync.samba.org/rsync Find it. You can use the rpm Package for installation. I have applied the source code here. For some reason, I prefer to install
.txt34Test.txtSent bytes received 451 bytes 1282.00 Bytes/secTotal size was 0 Speedup is 0.00Method Two: Do not specify the user on the rsync server sideModify the configuration file rsyncd.conf on the rsync server to remove the configuration entries for the authentication account (auth user and Secrets file):# sed-i ' S/auth users/#auth users/;s/secrets file/#secrets file/'/etc/rsyncd.confThe above command
Full backupThe most common and simple backup is to directly use the copy command to copy the version library directory to the backup directory. However, this is not a safe method, because if the version library changes during the copy process, the backup results will be inaccurate and the backup function will be lost,
More official statements
FullA backup of a datafile that has des every allocated block in the file being backed up. A full backup of a datafile can be an image copy, in which case every data block is backed up. it can also be stored in a backup set, in which case datafile blocks not in use may be skipped, according to rules in Oracle database
We can perform full backup for a small number of databases every day, because it does not take much time. However, when the database is very large, we are unlikely to perform a full backup every day, in addition, it is changed to a weekly full backup, and an incremental backup
/web-back/, and open permissions for backup users[Email protected] ~]# mkdir/web-back/[Email protected] ~]# chown backup:backup/web-back/(6) Copy all files under the Web server/boot/directory to the/var/www/html/directory for push testing(7),rsync-avz--delete/var/www/html/[email protected]:/web-back/Command Push testSecond, establish a virtual user on the backup
the introduction Several advanced applications of the WINDOWS2008 server Backup program. Mainly want to include network incremental backup, backup notification, space management and so on.Commercial backup software, in addition to having a nice management interface, also inc
How to use Innobackupex1. Full backup parameters a full backup address is fully backed up to the/data/mysql/back_up/all_testdb_20140612 directoryInnobackupex--user=root--password=123456--no-timestamp/data/mysql/back_up/all_testdb_20140612Now the full backup directory is/data/mysql/back_up/all_testdb_201406122. Incremental
Tags: data manipulation mysql location requires MySQL incremental backup output speed ICA technology shareIn a production environment, the security of data is critical, and any loss of data can have serious consequences. So the database needs to be backed up. Here is an example of a new mysql5.7.First, database backup classification:
From a physical and
Mysql database backup and restoration (binlog-based incremental backup)
1 Overview
1.1 Introduction to incremental backup
Incremental Backup means that after a full
Explore the RMAN_05 Incremental backup link in ORACLE: Explore the RMAN_01 concept in ORACLE http://www.bkjia.com/database/201205/132243.html Explore the basic use of RMAN_02 in ORACLE http://www.bkjia.com/database/201205/132329.html ; Explore ORACLE RMAN_02 consistent backup http://www.bkjia.com/database/201205/132664.html ; Explore ORACLE RMAN_03 non-consistent
# # View data for tables in the current library([email protected]) [Test]>select Count (*) from T_innodb;+----------+| COUNT (*) |+----------+| 0 |+----------+1 row in Set (0.00 sec)# # Performs an insert data operation, which executes after full provisioning([email protected]) [Test]>call addtest (100000,0);# # Perform a full library backup# Backup folder: 2014-06-19_20-53-41# Backup_type = full-backuped#
Rsync Simple and quick configurationRsync enables full-scale and incremental local or remote data backup. One rsync is equivalent to SCP,CP,RM but better than each of them because rsync is such a useful piece of software that many Linux distributions are included.Of course,
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.