question

MichaelvanOlden-1009 avatar image
0 Votes"
MichaelvanOlden-1009 asked ·

Handling large traffic spikes - Wordpress with Azure Database for MySQL server

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!





azure-webappsazure-database-mysql
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KalyanChanumolu-MSFT avatar image
0 Votes"
KalyanChanumolu-MSFT answered ·

@MichaelvanOlden-1009 Welcome to Microsoft Q&A forums and thank you for your interest in Azure services.
The WordPress solution you installed from Marketplace combines all the required resources into a package that is easy to deploy.
This way you don't have to provision the resources independently and configure them.
Once deployed, you have complete control over the resources and can manage them independently.
You can scale the app and database separately.

Coming to your question on Autoscaling, you can configure the triggers that can scale up or scale down the database.
For instance, when CPU utilization exceeds 70% or when utilization falls below 30%.

Please check the below article for step-by-step instructions

Auto Scale Azure Database for MySQL Using Azure Automation

Do let us know if you have further questions.


If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.

· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you for your response @KalyanChanumolu-MSFT.

Unfortunately, the solution you provided is not as clean as I would like. So, it is not something I would implement. I want the same GUI interface to scale up/scale out that is available with an App Service Plan.

74820-image.png

I am trying to understand what the limitations are for the Azure Database for MySQL product.

Is there a better choice instead of Azure Database for MySQL to use with Wordpress that can automatically handle large traffic spikes?


0 Votes 0 ·
image.png (3.9 KiB)