Mysqldump and LVM logical volume Snapshot

Common Data Backup Types and tools
Mysqldump Backup Tool
Use LVM logical volume Snapshot Backup
#####################################
Common Data Backup Types and tools

I won't say much about the importance of data ......, Common Data Backup types are divided based on different backup properties and requirements. They are: based on whether the business is online, based on physical and logical, based on the backup range, the following is a simple example of literacy:
Depends on whether the business is online

Hot Backup: read/write operations are not affected
Warm backup: only read operations can be performed
Cold backup: offline backup and read/write operations cannot be performed
Based on physical and logical

Physical backup: directly copying data files, fast (completed at the file system level, without the involvement of the mysql process), poor portability.
Logical backup: exports data to a text file, which is slow (requires mysql process parameters). It has good portability and lacks the floating point precision, so it is easy to use the text processing tool.

Based on the backup range

Full backup: Back up all data
Incremental Backup: only the data changed after the last full backup or Incremental backup is backed up (it occupies more space than Incremental backup, but it is convenient to restore)
Differential backup: only the data changed since the last full backup is backed up.
Here we use a picture to illustrate the differences between Incremental backup and differential backup more intuitively:

Full + increment (long restoration time, complex, and small footprint)
Completely + difference (short restoration time, simple, large footprint)
There are no constraints between them, such as full online physical backup ......

In addition, you should often test whether the backup data is available and develop an emergency restoration solution .........

The backup objects include data, configuration files, binary logs, transaction logs, etc ......

The functions and performance of each backup tool are as follows:

 

Using mysqldump in Linux to back up a MySQL database as an SQL File

Use mysqldump in Linux to regularly back up MySQL Databases

Mysqldump missing-q Parameter causes MySQL to be killed by oom

1 2 3 Next Page