Cold backup (off, slow, point-in-time restore) Cold backup occurs when the database has been shut down properly and provides us with a complete database when it shuts down properly. Cold backup is a way of copying critical files to a different location. Cold backup is the quickest and safest way to back up database information.
Advantages of Cold backup:
1. is a very fast backup method (just copy the file)
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 "latest state" of the database.
5. Low maintenance, high safety.
Disadvantages of cold backup:
1. When used alone, it can only provide a recovery at a point in time.
2. In the process of implementing a backup, the database must be backed up without any other work. In other words, the database must be closed during a cold backup.
3. If disk space is limited, it can only be copied to other external storage devices such as tape, which can be slow.
4. You cannot restore by table or by user.
It is worth noting that cold backups 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 open. And after the restoration must be the database file of the group and owners to MySQL.
hot Backup (on, fast) Hot backup is the SQL statement that backs up database operations when the database is running, and you can rerun the SQL statements that are backed up when a database problem occurs.
Benefits of Hot Backup:
1. Can be backed up at the table space or data file level for short backup time.
2. The database is still available for backup.
3. Can reach a second level recovery (revert to a point in time).
4. Almost all database entities can be recovered.
5. Recovery is quick and, in most cases, restored when the database is still working.
Disadvantages of hot backup:
1. There is no mistake, otherwise the consequence is serious.
2. If a hot backup is unsuccessful, the resulting results are not available for point-in-time recovery.
3. Because it is difficult to maintain, so be particularly careful, do not allow "failure to end".
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.
