In Azure Portal > Under [+ CREATE A RESOURCE], there is a pre-built 'WordPress' resource plan that will create:
- App Service Plan
- App Service
- Azure Database for MySQL server
Our typical web traffic is 1,000 visitors/minute. However, we do see occasional spikes of 30,000 visitors/minute.
(1) Will this Azure Database for MySQL auto-scale to handle massive traffic spikes? Is auto-scaling fully managed?
(2) I'm concerned that I don't have the ability to 'scale up' or 'scale out' the database. But, do I actually need to do this? Or, will Azure Database for MySQL* handle all this automatically? Should I create a MySQL instance with its OWN app service plan that will allow me to scale it?
(3) What actually happens to the database when I 'scale up' and/or 'scale out'? Does the database also scale?
Thank you in advance for your help!