Hi, we run a website which has a sale on some days. Usually 5+ days a month.
We are using managed database + a fallback right now with allows us to scale up without any downtime. The downscale process however involves multiple steps.
Create a new lower size database
Export backup from production
Restore backup to new server
Update connection string in new the website config.
The droplets have a resize feature which only resize the CPU and RAM of the droplet. If we could have a similar feature in Managed Database it would be easier to upscale and downscale as required without downtime.