Best way to automatically backup mysql?

Question

MySQL

Hello everyone, there is a question of finding the best way to backup for mysql

Can you suggest a way to automatically backup and after the backup is downloaded to a regular computer using ftp or in any convenient way

Tasks to consider

• Server CentOS 7
  
• Ability to work through ISPmanager
  
• Protected operation of the backup handler
  
• Automatic backup by CRON
  
• The backup should not interfere with the operation of the site so that users can continue working without noticing it
  
• The amount of data can reach up to 10GB in the database
  
• Download to a regular computer + the ability to upload to the cloud
  

Answer 1

backup with a regular bash script , push
the script into cron
after the backup is done - using rclone copy to ftp or cloud or anywhere in fact

Answer 2

Everything depends on the initial conditions.
If the conditions are "I passed by here, show me which buttons to press," then the solutions proposed above are most likely suitable. But on a more or less normal site (permanent entry in the database, transactions) the condition "The backup must not interfere with the operation of the site" will not be fulfilled.
In this case, you need to use percona
xtrabackup "the ability to work through ISPmanager".
The first is some kind of incomprehensible nonsense, but I just don’t know about the second. I have never used this garbage and do not recommend it to anyone.

Answer 3

mysqldump if you need a sql dump, otherwise you can just copy the directory with the databases