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?

WordPress Assistant for Azure App Service on Windows

App Service Assistant is a WordPress plugin that provides details on important settings and configuration. This can be helpful to troubleshoot WordPress issues. Information such as current theme, theme path, WP defines, plugins, php_errors.log (if enabled), debug.log (if enabled), user.ini, app settings.

Installing this plugin is a cinch! Just follow the steps below to get it activated and running in your WordPress application.


Plugins > Add new

Search for: app service assistant

Click Activate

How to use:

From settings menu, select “App Service Assistant”

Sample screenshot:

Location of Log File – AppAssistant.html is saved in the D:\home\LogFiles directory.

Feedback / Suggestions – Email msangapu@outlook.com