WordPress MySQL Database options on Azure

Azure has a plethora of products and can be confusing to the first-time customer. This post will cover a popular MySQL database options for WordPress when hosting on Azure.

ProductDatabase TypePROsCONsRecommendation
IaaS (Virtual Machines)MySQL on Virtual MachineFull control of MySQL Server
Multitude of VM options
Multitude of VM options

VM cost
If you enjoy/don’t mind server maintenance
PaaS (App Service)MySQL In-App (Windows only)Easy to enable

Free withWindows web app

Not production-ready
App cannot scale horizontally
Shares resources with web app
Requires additional configuration for MySQL port umber
For development or 1-instance situations
DBaaSAzure Database for MySQLProduction-ready
Easy to upgrade
Supports app scaling
DB CostFor production websites receiving constant traffic

These are the three main database options when hosting WordPress on Azure. I have tried all of them. I prefer the Azure DB for MySQL for production-ready scenarios the best. Microsoft maintains the database and you don’t have to worry about patching, security fixes, etc.

If you are on budget, MySQL In-App is great for getting started in development scenarios.

Those with DB/Admin/Webmaster experience may prefer the Virtual Machines option. They are all good and offer their advantages and disadvantages.

What about you? Which database type do you prefer on Azure for WordPress?