Menu
ELECTRONgeek
ELECTRONgeek
List of MySQL Products on Azure

WordPress MySQL Database options on Azure

Posted on March 10, 2019March 14, 2019 by egeek

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
Maintenance
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

Windows-only
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
Microsoft-backed
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?

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Recent Posts

  • Using MySQL In-App on Azure App Service
  • On-prem vs. IaaS vs. PaaS vs. SaaS
  • 1024 x 768 Display Resolution on External Monitor
  • WordPress MySQL Database options on Azure
  • 2019 Toddler Education

Archives

  • July 2020
  • June 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • February 2018
  • July 2017
  • June 2017
  • December 2016

Categories

  • app service
  • Azure
  • mysql in-app
  • Tech
  • Uncategorized
  • windows
  • Wordpress

Tags

1024x768 android app appinit application initialization app not installed app service assistant azure azure app service azure database for mysql configuration display resolution easy mysql import fun game git google play in-app kids microsoft microsoft windows 10 migration mysql mysql in-app password performance php cms plugin repo site extension subsystem linux toddler education virtual machines windows wordpress wordpress buddy wordpress redirection xamarin
©2022 ELECTRONgeek | WordPress Theme by Superb Themes