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?

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

the feature you want is currently in preview - it is called flexible server for mysql


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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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