HotBackup MySQL (mysqlbackup) is it possible? Which parameters?

[siergit]

Hello,

I am using your tool on a software and it works great for a daily backup, when there is no reading/writing.

My application is evolving and we are searching for a Hot Backup solution like "mysqlbackup" is mentioned on https://backup.ninja/news/hot-warm-and-cold-backups-mysql that can make a hour by hour backup during normal reading/writing operation is happening parallelly on the database.

Is it possible?

What parameters or conditions or limitations I should look for?

Any help is welcome,

Congratulations for the current work on this tool,

Regards,
Miguel

[adriancs2]

MySqlBakup.net able to work without the need to take the application down or make it offline. It can runs without locking the tables. I can think of 2 downsides:

1. During the backup process running, the MySQL database might have slower response to user/app request. (Since the database is busy exporting data)
2. Lets say the backup process takes 10 minutes to complete (depending on your database size), any data changes during this time have a high change of not being included in the backup.

For the parameters, you can use the default settings.

My recommendation of workout is to use a MySQL replication that the hot backup can be run on.
So the main primary database serves for user request, and the replication serves for the hot backup. This configuration has lower impact on the primary database performance while the hot backup is running.

[adriancs2]

Here is the performance benchmark that I've done a couple of days ago. The benchmark result can serves as a reference to help you in designing the hot backup solution.
https://github.com/MySqlBackupNET/MySqlBackup.Net/wiki/Performance-Benchmark-(MySqlDump-vs-MySqlBackup)
You can use this library to perform hot backup directly on the production database.