Can I downscale/upscale my MySQL server automatically?
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/