/rsyncd.conf #创建配置文件, add the following code
Log file =/var/log/rsyncd.log #日志文件位置, which automatically generates this file when you start rsync, without having to create it in advance
Pidfile =/var/run/rsyncd.pid #pid文件的存放位置
Lock file =/var/run/rsync.lock #支持max connections parameter
Secrets file =/etc/rsync.pass #用户认证配置文件, which saves the user name and password, which is later created
MOTD file =/etc/rsyncd. MOTD #
] 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
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
Incremental backup in the slave database can prevent data loss caused by misoperation of the master database.
Ensure that the backup slave database and master database are in synchronization status at any time.
Ii. Backup Policy Selection for production scenarios
1. Small and Medium Enterprises
Full
First, rsync basic configuration and introduction1. What is rsync?rsync (rsync-a Fast, Versatile (general), remote (and local) file-copying tool An open source, fast, versatile tool that enables full and incremental simultaneous local or remote data
Instance method for mysql automatic incremental backup (local backup and remote backup) bitsCN.com
1. local backupCompile an automatic backup script:Vim/var/lib/mysql/autobakThe content is as follows:Cd/data/home/mysqlbakRq = 'date + % Y % m % d'/Usr/local/mysql/bin/mysqldum
Set in cron and execute at every Monday (full backup every Monday, Incremental backup for the rest of the time)
# Vi backup. Sh
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->#! /Bin/bash
# Define
Dayofweek = 'date "+ % u "'
Today = 'date "+ % Y % m % d "'
Sour
First, the basic introduction of rsync1. What is rsyncRsync is an open source, fast, multi-functional, incremental local goods remote data mirroring synchronous backup of excellent tools, rsync use and unix,linux,windows and other platforms2, the characteristics of rsync1) Support for copying special files2) can have exclude specified file or directory3) can main
] ... rsync://[[email protected]]host[:P ort ]/SRC [DEST]There are six different modes of operation for Rsync, which corresponds to the above six command formats:
Copy the local file. This mode of operation is initiated when both the SRC and des path information do not contain a single colon ":" delimiter. Such as:rsync -a /data /backup
Use a remote
First, use the percona-xtrabackup tool to perform full backup of the database, and then perform Incremental backup of the data after each database data update.
First, use the percona-xtrabackup tool to perform full backup of the database, and then perform Incremental
Rsync is a very powerful tool, and its commands have many feature options, and we'll analyze all of its options below. The command format for Rsync can be the following six: rsync [OPTION] ... SRC DEST rsync [OPTION] ... SRC [User@]host:dest rsync [OPTION] ... [user@] HOST:S
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
Mysql daily backup and incremental backup script bitsCN.com
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
The following articles mainly describe the correct operation steps for offline and online full backup, Incremental backup, and recovery of DB2, the following is a detailed description of the correct operation steps for DB2 offline and online full backup, Incremental
Backup and restore server (Linux) files (in T) and database (MYSQL) due to job requirements. Initially, full backup and restore was achieved through code. The advantage of this is that the entire backup and restore process can be controlled to ensure data security. But the disadvantage is also obvious: low efficiency, long operation time, the server stored in a l
Nine Incremental backups
With incremental backups, RMAN allows users to back up only blocks of data that have been modified since the last incremental backup. Incremental backups have the following somewhat:
(1) Less use of disk or tape
(2) Reduce network broadband requir
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.