User should be able to perform a backup of database

[mkosieradzki]

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

[frodopwns]

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.

[mkosieradzki]

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.

[frodopwns]

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.

[stale]

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]

Issue still active.

[theunrepentantgeek]

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.

[stale]

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

[matthchr]

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

[stale]

Issue still active.

[super-harsh]

We're still interested in doing this.

[matthchr]

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]

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]

This may be related to #3736

[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.

[theunrepentantgeek]

No change from the above.