using rsync to backup

Rsync backup is very convenient. You only need to install it and do not need to configure anything. However, it takes a long time to get lazy. How can I use rsync without entering a password? There are many methods on the Internet, and SSH-keygen is the most convenient. However, it seems inconvenient for me to use it. It seems that there is only one password conf

Article Title: remote automatic backup using scripts in Linux. Linux is a technology channel of the IT lab in China. Includes basic categories such as desktop applications, Linux system management, kernel research, embedded systems, and open source. Considering that data is backed up on the local machine, once the machine's hard disk fails, the data cannot be taken out. Remote manual data

Article Title: Linux Remote Automatic Backup using scripts. Linux is a technology channel of the IT lab in China. Includes basic categories such as desktop applications, Linux system management, kernel research, embedded systems, and open source. Considering that data is backed up on the local machine, once the machine's hard disk fails, the data cannot be taken out. Remote manual data

-file parameters of the same xtrabackup --apply-logencapsulation of the--prepare parameters for Xtrabackup --copy-backdatadir to copy the backup data file to the MySQL server when doing data recovery; --remote-host=hostnamethe backup data is stored on the process server via SSH; --stream=[tar]back up the file output format, using TAR4IBD in tar, which can be

doing the data recovery;--remote-host=hostnameThe backup data is stored on the process server via SSH;--stream=[tar]Back up the file output format, using TAR4IBD in tar, which is available in the Xtarbackup binary file. If you have specified--stream=tar at the time of backup, the directory where the Tar4ibd file is located must be in $path ( Because TAR4IBD is u

, and the data in the chronology is read-only and not written (historical payment information is no longer modified), only the current chronology data is read and written Each time the database is fully prepared takes too long, more than 20 hours, and the database restore operation takes longer, more than 30 hours How to optimize the design of this database and backup recovery system, can make backup, resto

recovery policies need to be developed based on the actual situation. What data does MySQL Backup need to back up? It mainly includes data, configuration files, binary logs, and transaction logs.II. Introduction of backup tools: 2.1 MySQL backup tools: Mysqldump: Logical backup tool, MyISAM (temperature), InnoDB (hot

cbbackupThe tool is a flexible backup command that enables you to back up local data and remote nodes and different combinations of data that involve your cluster:Single node single bucketsAll buckets on a single nodeA single buckets on the entire clusterAll buckets on the entire clusterBackups can copy files directly on a separate node, or they can be saved to a backup location by connecting to a remote c

How to handle archived log files and RMAN log files when using rman backupI went to a customer yesterday to deploy RMAN backup. when I ran the shell script, I was prompted that I could not find the archive log, because the customer only performed EXPDP logical export backup for the database before, in addition, the archive of the previous day is automatically del

tools: Cp: Cold backup Lv: logical volume snapshot function, which can achieve almost hot backup. The backup process is as follows: Mysql> flush tables;Mysql> LOCK TABLES Create a snapshot: Release the lock and then copy the data.2.3 Third-party tools: Ibbackup: A commercial tool that provides fast backup and s

Tags: ROC data file tables str end time related show Binlog hostInstalling xtrabackup using RPM packages # # Install dependent Packages Yum Install Perl Perl Perl perl-dbd-MySQL rsync # # installs LIBEV4 package -ivh libev4-4.15-7.1. x86_ 64.rpm # # installs Percona-xtrabackup -ivhpercona-xtrabackup--2.4. 4-1. el6.x86_64.rpm Create a MySQL account for the backup