Can I downscale/upscale my MySQL server automatically? Is this doable? Since we know the peak times of our platform we are planning to downscale our DB after peak hours then upgrade the specs before the start of peak hours, how can we do this? Like how is RDS doing this?
the feature you want is currently in preview - it is called flexible server for mysql
https://azure.microsoft.com/en-us/pricing/details/mysql/flexible-server/