0

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?

4
  • What's the read/write and can your application handle read/write split? Which MySQL version?
    – danblack
    Commented Feb 26, 2021 at 11:08
  • How many hours long is the spike? Is it at a predictable time? Is it mostly readonly traffic?
    – Rick James
    Commented Feb 27, 2021 at 1:13
  • @danblack mostly read/write transactions. no, application can not handle read/write split. MySQL 5.7 sir
    – JRA
    Commented Mar 2, 2021 at 9:51
  • @RickJames around 4-5 hours from 9am until 2pm only on weekdays. Very minimal traffic after that timeline.
    – JRA
    Commented Mar 2, 2021 at 9:54

1 Answer 1

0

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/

1
  • Still, their PaaS offerings is very costly for a startup company. We are planning to do this on their Azure VM.
    – JRA
    Commented Feb 26, 2021 at 10:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.