Add tunnelling to allow querying Cloud Backup snapshots
The Legacy Backups have a feature to allow connecting (tunnelling) to a snapshot to query it. This allows querying a database snapshot which is great for quickly inspecting data in the past for troubleshooting. This would be handy to have for the Cloud Backups. With Cloud Backups instead I now have to download a snapshot, load it temporarily on a cluster and remove it when done.
Deitric
shared this idea
3 comments
-
Trevor
commented
> Cloud Backup restores are extremely fast.
Unfortunately this isn't really true. Restorations for my ~8GB database (which is pretty small) take about 15 minutes to restore, which, in addition to the 15 minutes to provision a new cluster, etc., means waiting around 30-45 minutes just to make a single query, only to realize you need to go back one more day in your snapshots and try again, waiting another 15-30 minutes.
It's also expensive. Every backup restoration gets charged "data transfer fees", which add up fast if you need to dig through more than one snapshot, especially as the database grows. It's just a *little bit* questionable to ask your customers to use an obnoxious, slow, workaround for a feature that should be standard, and then charge them for it.
I really hope the Devs actually work on this, especially since it *used* to work in the legacy backups!
-
Erik
commented
I am happy to hear that you guys are bringing back queryable snapshots! That was an awesome feature in Legacy Backups for quickly retrieving deleted or corrupted documents or examining the state of data at any point in time.
-
Hello,
We are planning on building a new version of queryable for Cloud Backup but not with a tunnel. In the meantime, I would suggest provisioning a new cluster, restoring the backup, do what you need, and then tear it down. Cloud Backup restores are extremely fast. This would be the best way for the time being.
