azure-service-operator icon indicating copy to clipboard operation
azure-service-operator copied to clipboard

Published 20 hours ago • verified publisher icon Azure

User should be able to perform a backup of database

Open mkosieradzki opened this issue 5 years ago • 15 comments
trafficstars

User should be able to perform a backup (and restore) of database using kubernetes-specific toolchain like velero/restic.

mkosieradzki avatar Jun 25 '20 23:06 mkosieradzki

Right now we have the concept of "Actions" like in AzureSqL we have an AzureSQLAction and the only use case right now is to create new admin credentials for the server. This could be expanded to allow backup/restore on an ad hoc basis. What about scheduled backups? I could imagine using Kube CronJobs to our advantage here.

frodopwns avatar Jun 26 '20 05:06 frodopwns

Ideally integration should be done as part of this project: https://github.com/vmware-tanzu/velero-plugin-for-microsoft-azure

However, exposing this SQLActions feature sounds like a really good idea.

mkosieradzki avatar Jun 26 '20 07:06 mkosieradzki

Operations beyond deployment and deletion are a little up in the air currently.

We have

AzureSQLAction

  • roll creds: which resets admin user/pass and updates kube secret (key vault if configured)

Redis

  • reset keys
  • restart server

These have come directly from user requests as I didn't want to get into the habit of churning out features that would not be used.

Please feel free to suggest anything else that comes to mind. I think backups/restores will be among the highest priority here.

frodopwns avatar Jun 26 '20 18:06 frodopwns

This issue has been automatically marked as stale because it has not had activity in 60 days. It will be closed if no further activity occurs. Thank you!

stale[bot] avatar Oct 22 '20 04:10 stale[bot]

Issue still active.

stale[bot] avatar Jul 05 '21 23:07 stale[bot]

The discussion above relates to ASO v1 which is now in maintenance mode.

We don't currently have a way in ASO v2 to do long-running ad-hoc operations, but we do want to support those in the future. We'll revisit this idea once we have a design for those.

theunrepentantgeek avatar Dec 13 '21 21:12 theunrepentantgeek

This issue has been automatically marked as stale because it has not had activity in 60 days.

stale[bot] avatar Apr 19 '22 01:04 stale[bot]

We're still interested in investigating a good way to do this sort of operation

matthchr avatar May 02 '22 23:05 matthchr

Issue still active.

stale[bot] avatar May 02 '22 23:05 stale[bot]

We're still interested in doing this.

super-harsh avatar Aug 29 '22 22:08 super-harsh

Still interested in doing this, but prioritizing GA release of v2.0.0 currently. We would be open to a PR for this for sure.

matthchr avatar Feb 28 '23 00:02 matthchr

Still interested in doing this. We have some support for Azure BackupVaults now, which might actually support this in some way, although they may not as well we'll need to do some reading...

matthchr avatar Oct 02 '23 22:10 matthchr

This may be related to #3736

matthchr avatar Feb 13 '24 00:02 matthchr

No change from the above. We might possibly be able to close this item given that we will support the backup service (hopefully soon), but it's not 100% clear to me that they support the full set of database backups asked about here.

matthchr avatar Mar 11 '24 23:03 matthchr