MySQL 8 Backup Performance 800 databases

Application issues
1

Hi!
I am wondering if there is a way to speed up the Backup process.
We are backing up about 800 single Databases, which we did with a custom script with mysqldump to export it into per database SQL files. This took about 40 minutes to complete. The actual database size is about 30GB combined.
With the Backup tool, it takes more than 2 hours to generate the dumps on the same machine without ZIP or encryption.
Is there a way to speed this up? Like backing up multiple databases at once for example?
It´s not option to split it into multiple jobs as the databases are frequently getting added or deleted.
And i don´t know how to keep the overview of what is backed up or not.

Thank you for any ideas.

2

Hi Stefan_Dettwiler,

We can recommend you create several backup jobs and split your databases. If databases are frequently getting added or deleted you can use the “Exclude databases” option and where specify regular expressions, for example, in one backup job separate out databases that start with the character “a”: “^a” and in another job ^((?! a).)*$

SQLBackupAndFTP
SQLBackupAndFTP501×585 14.6 KB

Thus, you can create multiply backup jobs with specific settings.

Sorry for the inconvenience.

3

Thank you i will give it a try!

4

Hi Stefan_Dettwiler,

Sure, please feel free to contact us on any issues or concerns.