MySQL cold backup and hot backup concept understanding

Source: Internet
Author: User

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)

Related Article

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.