Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Feature Request: Allow for backups to be created that are safe to upgrade MySQL with #13448

Closed
dbussink opened this issue Jul 6, 2023 · 0 comments · Fixed by #13449
Closed

Comments

@dbussink
Copy link
Contributor

dbussink commented Jul 6, 2023

Feature Description

In vtbackup it's possible to use the -restart_before_backup flag to force a restart of MySQL with innodb_fast_shutdown=0. This way the backup that is created is safe to also use for upgrading MySQL. When upgrading MySQL, it's necessary to not use fast shutdown as the new version might have a different on disk format.

In Backup / BackupShard commands though through vtctld, it's not possible to specify a similar flag. This means that backups created through that method couldn't be safely used for upgrades.

Request here is to have a flag available for those backup methods as well so it's possible to create a safe to upgrade backup.

Use Case(s)

Useful when upgrading MySQL in a Vitess cluster, especially when doing it in an automated fashion for a large number of databases.

@dbussink dbussink added Type: Feature Needs Triage This issue needs to be correctly labelled and triaged Component: Backup and Restore and removed Needs Triage This issue needs to be correctly labelled and triaged labels Jul 6, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant