When I attended the Yammer Working Social Tour in Amsterdam I decided to start blogging. So I ended up creating a blog based on WordPress on Windows Azure. In this blogpost I will explain what problems I encountered during the setup of my blog.
I will not advise you to go for WordPress and Azure Websites with SQL Server and the Database Abstraction plugin.
— Eugène Dauphin (@eugenedauphin) September 18, 2014
As you can read in my tweet above, I migrated my WordPress blog from Azure Websites with SQL Server and the Database Abstraction plugin to a Linux Virtual Machine on Azure with Apache, MySQL and PHP. I had too many problems with performance, could not always automatically update to a newer WordPress version, a few plugins did not work at all because of the Database Abstraction plugin. The WordPress 4.0 update did not work and I needed to restore a backup.
You can set WordPress up in minutes, but there is a catch if you choose the wrong template. I found out that your database will be created and hosted by ClearDB. No problem with that, but by default your database is not allowed to be larger than 20MB. Not much for a website. You can upgrade your database to 1GB but this will cost you $9,99 per month. This was a no go for me. I have a €75 euro spending limit on Azure based on my Visual Studio Premium MSDN (MPN) account, why should I pay for my database?
So how do you solve this problem? Easy, just choose the following template from within Azure and you create a WordPress site based on SQL Azure, which will use your spending limit and will not cost you extra money. As described below, this template uses the Database Abstraction plugin.
The next problem I had was the default upload limit in Azure of only 2MB. This can be solved to upload a .user.ini file in the wwwroot folder with the following content: