Shulou(Shulou.com)05/31 Report--

What are the 15 suggestions on database backup and recovery? in order to solve this problem, this article introduces the corresponding analysis and answer in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

Overview

Data is the lifeblood of an Internet company, the security of the database and the integrity of the record are very important, so we need to be proficient in data backup and recovery, which is also a professional skill that a qualified operation and maintenance DBA must have.

Here are some suggestions for database backup.

Mysql backup proc

1. Make a backup on the secondary replication server.

2. Stop data replication during backup to prevent inconsistencies between data dependencies and foreign key constraints.

3. After completely stopping MySQL, back up from the data file.

4. If you use MySQL dump for backup, back up the binary log at the same time-make sure that the replication process is not interrupted.

5. Do not trust backups of LVM snapshots-inconsistent data may be created and problems may arise in the future.

6. Make a backup for each table, which makes it easier to restore a single table-if the data is independent of other tables.

7. Specify the-opt parameter when using mysqldump.

8. Check and optimize the table before backup.

9. Temporarily disable foreign key constraints to improve the speed of import.

10. Temporarily disable uniqueness checking to improve the speed of import.

11. After each backup, calculate the size of database / table data and indexes and monitor their growth.

12. Use scheduled task (cron) scripts to monitor errors and delays copied from the library.

13. Back up data regularly.

14. Test the backed-up data regularly.

15. Execute MySQL monitoring: Monitis Unveils The World's First Free On-demand MySQL Monitoring.

The answers to the 15 suggestions on database backup and recovery are shared here. I hope the above content can be of some help to you, if you still have a lot of doubts to be solved. You can follow the industry information channel for more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.