Tolerating MySQL restarts while xtrabackup in progress

MySQL & MariaDB Percona XtraBackup
,
1

Is there any way to tolerate MySQL restarts while xtrabackup in progress? like some wait time something that will not break the process.

2

Unfortunately there is no such thing. I am curious what is your use case for that?

2 Likes
3

use case is like, we have scripts which takes daily backups and if someone restarts MySQL without checking if backup in progress they may break the backup of that day.

4

A few things here:

  1. That’s the job of the person restarting mysql. If you have that power, then it is your responsibility to make sure the restart won’t impact other operations.

  2. Only the “DBA” should be able to restart MySQL, and the DBA should know about the backup process.

  3. How often are you restarting MySQL? Most mysql servers have MONTHS of uptime. Restarting MySQL is not a common task and not something that needs to be happening daily, or even weekly. If you are doing this, then you are managing your MySQL incorrectly and/or have some other issue at hand that need to be fixed.

5

I agree with you, please ignore. Just wanted to check if there is a feature for it

6

I don’t know of any database system out there that can support backups through a restart. Most backup tools for any RDBMS need to maintain contact with the database itself to monitor/track changes and when you stop the database, you lose that. MySQL certainly supports backing up while being stopped, but not during a restart.

1 Like