MySQL Database Backup Types and common backup tools (1)
1. Database Backup Type
There are four backup types based on the database size, which are used in different scenarios. The following is a brief introduction:
1.1 full backup
backup. It has the advantage of storing and recovering faster. It is recommended to make a differential backup every day.
1.4 File Backup
A database can consist of many files on a hard disk. If the database is very large and cannot be backed up overnight, you can use a file backup to back up a portion of the databas
the InnoDB data. When InnoDB starts, it checks the data file and the transaction log, and it does a two-step operation:Xtrabackup when backing up, a page by page copy of InnoDB data, and do not lock the table, at the same time, xtrabackup there is another thread monitoring transactions log, once the log changes, the changed log pages copied away. Why the rush to copy away? Because the transactions log file is limited in size, when it is full, it starts from scratch, so the new data may overwrit
Oracle backup tools, file naming formats, rman operations, and mongolerman
I. Common tools:
Recovery Manager: rman can only perform Hot Standby (mount or open state)Oracle Secure BackupUser-managed backup: cp/dd [if =/of =/blocksize =]
Ii. rman naming
The rman name cannot be repeated. % U is definitely not repeated.
%
Oracle backup tools, file naming formats, and rman operations
I. Common tools:
Recovery Manager: rman can only perform Hot Standby (mount or open state)Oracle Secure BackupUser-managed backup: cp/dd [if =/of =/blocksize =]
Ii. rman naming
The rman name cannot be repeated. % U is definitely not repeated.
% C Number of c
Informix is a relational database management system that can be used to develop powerful applications that can run on multiple platforms. Informix Database Dynamic Server (IDS) is the core of INFORMIX database technology products, featuring scalability, scalability, manageability, and efficient operation. Because Informix is mostly used to manage large applications, data backup and recovery is an important task for database administrators. Therefore,
MySQL online backup and recovery tools --> XtraBackup
1 Overview of Xtrabackup principles
Xtrabackup is a tool used to back up InnoDB data. It supports online Hot Backup (data read/write is not affected during Backup) and is a good alternative to InnoDB Hotbackup.
Xtrabackup has two main
Standard UNIX systems provide basic backup tools. Different backup tools are different. Dump, cpio, tar, dd, dump, and restore are usually the best choices. The second is cpio, but it is less friendly than tar; tar is easier to use than dump or cpio. If you want to use tar or cpio to back up rawdevices or perform remot
The basic purpose of a good backup is to be able to recover from some errors:
Man-made mistakes
Disk array or hard drive failure
File system crashes
Data center is corrupted and so on.
So, I've listed some open source software backup tools for everyone.What do you think about when choosing a backup
I. Significance of backup from the perspective of data security, Database Server disks are all RAID, and Mariadb itself also has master-slave and other disaster recovery mechanisms, but they cannot completely replace backup. Disaster Tolerance and high availability can help us effectively cope
I. Significance of backup from the perspective of data security, Datab
Reprint: http://linux.cn/article-4623-weixin.html#rd?sukey= Cbbc36a2500a2e6cb7678c4d38b691a9fa7403b259f898ef85fa4620177de89e521da2071ebd494c71482c97449337f9The basic purpose of a good backup is to be able to recover from some errors:
Man-made mistakes
Disk array or hard drive failure
File system crashes
Data center is corrupted and so on.
So, I've listed some open source software backup
Guide
Backups on personal computers or servers are important to prevent data loss. System administrators need to work on a large amount of enterprise-level data and even data on personal computers every day, so you need to drill down into different backup tools. In this article we will cover 11 top-notch backup tools
xtrabackup------MySQL DBA's Prerequisite tools
Attention:
1) document reference Http://www.percona.com/docs/wiki/percona-xtrabackup:start
2 MySQL to use 5.1.50 version or above.
Introduction and installation of Xtrabackup
1, Xtrabackup is a Percona open source project, can be hot backup InnoDB, xtradb, and MyISAM (Will lock the table), can be considered as a free alternative InnoDB hotbackup.
Percona
rsync Simple
The role of rsync is like the general Linux CP and SCP directive, which can be copied from the source location to the destination location, however, rsync is more efficient than CP and SCP in a copy of the file, and supports both the connection and the devices, as well as the retention of the file's owner, group Group and permissions,
In the first copy of the case, rsync will copy the full file, and then again, the Delta transfer algorithm is used to check the differences between t
Here's a list of some software backup tools that are open source on Linux and Unix-like. What do you consider when choosing a backup tool for an enterprise? Make sure that the software you are deploying has the following characteristics Open source software-you have to choose the software that the source code can be obtained for free and can be modified. Be sure
Xtrabackup is a data backup tool for the InnoDB Storage engine. It supports online Hot Backup (which does not affect Data Reading and Writing during Backup) and is a good alternative to InnoDBHotbackup. xtrabackup has two main tools: xtrabackup and innobackupex. You can only back up tables of InnoDB and XtraDB storage
Article Title: How to choose a Linux backup tool for SMEs. 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.
Many Linux data backup products are constantly adding new features and starting to become more mainstream in the enterprise. Currently, most major storage managemen
database backup work is the key to protect the database, the following article is mainly about the MySQL database backup of some small coup, we all know that using MySQL dump backup database users need relatively small permissions, Only the permissions on select and lock table are sufficient.
so you can create a user who backs up the database, specifically fo
recovery technologies use storage media and certain policies to regularly back up system business data to ensure that data can be recovered as soon as possible during accidental data loss and minimize user losses. It is a very important core technology in the information security discipline.
Backup Technology in Linux
For backup and recovery, Linux provides tools
How do small and medium-sized enterprises choose Linux backup tools? -- Linux Enterprise Application-Linux server application information. For details, refer to the following section. Many Linux data backup products are constantly adding new features and starting to become more mainstream in the enterprise. Currently, most major storage management vendors (such a
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.