Downgrade Option for Managed Databases
complete
W
Whitney Jutzin
marked this post as
complete
With the release of Autoscaling for storage, we have also globally released manual scale downs for Managed Databases. When needed, you are able to reduce your storage amount to better match your workload. When scale down requests are made, we validate the remaining space will be able to support operations without risking cluster stability.
This was announced in the latest changes:
https://docs.digitalocean.com/products/databases/#latest-updates
W
Whitney Jutzin
Merged in a post:
Allow to resizing down MySQL database
Shahrun Nadzree
Right now theres no option to resizing down the managed MySQL database. Previously we can do it using doctl but that has been disabled. This is very useful for us as we only will upgrade during peak season.
Photo Viewer
View photos in a modal
W
Whitney Jutzin
Merged in a post:
Allow Postgres Downscaling
Andrii Chaika
Right now, you can pick only instances with SSD size >= from the current one.
The issue is that sometimes you need more CPU, sometimes you need more RAM. If you ever happened to use Space optimized droplets there is no way you can scale back for reasonable money. You may need less CPU at one point in time. There are lots of scenarios when you really need it.
My proposal is to allow downscaling of instances automatically.
Right now you can achieve it by creating a new smaller DB and migrating all data from the old one.
I think it can be fairly easily implemented in a managed manner (just create a new, smaller instance, migrate data, destroy old instance)
You may put a condition that the new instance must have enough space to accommodate current disc usage +30% for safety reasons.
W
Whitney Jutzin
Merged in a post:
Allow downgrading Postgres databases to smaller disk
Andrii Chaika
My database uses 10% of disk. I was using higher tier because of high load I experienced in the past. I want to downgrade it to lower tier but it is not possible.
DigitalOcean supports live migration between databases. I want you to allow downgrading database if there is enough disk space on lower tier.
For example I have 580GB with 10% disk utilization. I want to downgrade to 240GB instance. It has plenty of space.
You can put a limit for example that the database size must be less than 80% of total disk space of lower tier.