就一台服务器,mysql数据库想实现自动备份,如何设计?
巴扎黑
巴扎黑 2017-04-17 16:32:49
0
4
659
巴扎黑
巴扎黑

reply all(4)
小葫芦

Use crontab to regularly execute a backup script mysqldump command

小葫芦

As long as the automatic backup is implemented, it doesn’t matter, even if your working computer backs up the server’s MySQL once a day

But to be more rigorous, you must back up the server. If it is a cloud server, the server itself will have a snapshot, so you can worry less. If you host the server yourself, the server hardware must be equipped with a raid card, otherwise it will be more difficult to ensure data security

Another backup tool is recommended. The physical backup solution of Alibaba Cloud RDS is also based on this implementation
http://mysql.taobao.org/month...

阿神

It depends on your own definition of "backup", whether it is a quick recovery or a business that cannot be stopped.
Completely two different things. The question is too general.

巴扎黑

Write a scheduled script to regularly back up to Qiniu or other servers
For specific design, please refer to Zhang Ge’s blog, Zhang Ge provides a variety of ways

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template