backup in WHM | Talk Web Hosting

his stupid backup option is to do his job with the basic function in whm.
In DirectAdmin, the administrator can create a backup from each user whenever he wants, or add cron for that, also multiply cron to create multiple backups.
in whmc / cpanel, there is no option for that.
we have a very large server with 1TB of data, so it is not possible to use the cpanel backup system (create a backup from mysql and public_html)
So I decide to use rsync every hour to sync the new files to the second hard drive.

but what about MySQL? How can I backup all mysql databases and put them in / backup / mysql?

Is there another solution for my situation with large files?