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

Michael van Olden 6 Reputation points
2021-03-04T22:19:36.17+00:00

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 App Services
Azure App Services
A feature of Azure App Service used to create and deploy scalable, mission-critical web apps.
4,339 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
446 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. KalyanChanumolu-MSFT 8,251 Reputation points Microsoft Employee
    2021-03-05T04:00:41.123+00:00

    @Michael van Olden 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.