就一台服务器，mysql数据库想实现自动备份，如何设计？

Answer 1

Use crontab to regularly execute a backup script mysqldump command

Answer 2

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...

Answer 3

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.

Answer 4

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