MySQL cold backup and hot backup concept understanding

One, cold backup (off, slow, point-in-time recovery)

A cold backup occurs when the database has been shut down properly and provides us with a complete database when it shuts down normally. Cold backup is a statement that copies critical files to another location. Cold backup is the fastest and safest way to back up database information.

Advantages of Cold backup:

1. is a very fast backup method (just copy files)

2. Easy to archive (simple copy)

3. Easy to recover to a point in time (just copy the file back)

4. Can be combined with the archiving method to restore the database "up-to-date state".

5. Low maintenance, high safety.

Disadvantages of cold backup:

1. When used alone, it can only be provided to "a point in time" recovery.

2. In the whole process of implementing the backup, the database must be backed up and not be able to do other work. In other words, during a cold backup, the database must be off state.

3. If disk space is limited, it can only be copied to other external storage devices such as tapes, which can be very slow.

4. cannot be recovered by table or by user.

It is important to note that a cold backup must be done in the case of a database shutdown, and that performing a database file system backup is not valid when the database is in an open state. And after the recovery, be sure to change the database file of the genus and the owner to MySQL.

Second, hot backup (on, fast)

A hot backup is a SQL statement that backs up a database operation in the case of a database run, and you can re-execute the backed-up SQL statement once the database has a problem.

Advantages of hot Backup:

1. Backup at table space or data file level with short backup times.

2. The database can still be used when backing up.

3. Can reach a second level of recovery (to a point in time).

4. Recovery is possible for almost all database entities.

5. Recovery is fast and in most cases resumes when the database is still working.

Disadvantages of hot backup:

1. No mistakes, otherwise serious consequences.

2. If the hot backup is unsuccessful, the resulting results are not available for point-in-time recovery.

3. It is difficult to maintain, so be careful not to allow "failure to end".

Reference:

Https://www.linuxidc.com/Linux/2014-03/98710.htm (the above content is transferred from this article)

MySQL cold backup and hot backup concept understanding (GO)