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?

JRA
  • 59
  • 8
  • What's the read/write and can your application handle read/write split? Which MySQL version? – danblack Feb 26 '21 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 '21 at 01:13
  • @danblack mostly read/write transactions. no, application can not handle read/write split. MySQL 5.7 sir – JRA Mar 02 '21 at 09:51
  • @RickJames around 4-5 hours from 9am until 2pm only on weekdays. Very minimal traffic after that timeline. – JRA Mar 02 '21 at 09:54

1 Answers1

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/

Stephen Morris - Mo64
  • 3,506
  • 5
  • 16
  • Still, their PaaS offerings is very costly for a startup company. We are planning to do this on their Azure VM. – JRA Feb 26 '21 at 10:20