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?– danblackFeb 26, 2021 at 11:08
-
How many hours long is the spike? Is it at a predictable time? Is it mostly readonly traffic?– Rick JamesFeb 27, 2021 at 1:13
-
@danblack mostly read/write transactions. no, application can not handle read/write split. MySQL 5.7 sir– JRAMar 2, 2021 at 9:51
-
@RickJames around 4-5 hours from 9am until 2pm only on weekdays. Very minimal traffic after that timeline.– JRAMar 2, 2021 at 9:54
Add a comment
|
1 Answer
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/
answered Feb 26, 2021 at 9:51
-
Still, their PaaS offerings is very costly for a startup company. We are planning to do this on their Azure VM.– JRAFeb 26, 2021 at 10:20