WordPress on Windows Azure–Don’t Use MySQL

I would say about 6 months or so ago (maybe more, maybe less) I sat down and decided to migrate EnergizedTech.com and PowerShell.ca to WordPress on Azure.  

I had been using a hosted WordPress.com site for years since spaces.live.com migrated to the platform and was quite happy with it.   Then when my site was hit by multiple spam requests and my current provider began CHARGING me for those hits I began to review my options.

The first option would have been just to point everything to ye110wbeard.wordpress.com.   But then I thought about ALL of those links that still get regular searches on Google.  

“Oh, crud” at which point I began looking into migrating all the content from my Previous movable Type to WordPress site.   This involved FTP to pull my image structure over (pretty easy), a little custom PowerShell to re-build my hard links (Not too nasty) and building a custom URL to match my old links.

The site ran great until about May at which point I could no longer log in.   The site was still live but I just could NOT login and access my content.   In addition I was receiving these persistent emails from ClearDB about my database being at it’s limit.

So some quick research later, Microsoft does NOT host the MySQL, it was handed to another company called ClearDB that does NOT leverage your Azure credits.

“Ugh!” was my first statement.   The cost was not particularly nasty ($3 a month) but it was the principal of running my websites 100% by just leveraging all this Azure credit I had at my disposal.

The temporary workaround was to spin up a VM with MySQL on it, use the following article to repoint it to the Hosted MySQL after I dumped the MySQL DB and uploaded it to the new instance on my VM.  Connecting a new MySQL Database to an existing Azure …

Once pointed I was online again and able to export my content directly in WordPress.

But I was missing something, High Availability (Which you DO incidentally get from ClearDB)

This was silly.   MSSQL on Azure is Highly Available.  That was “Free” within my Azure Credits budget.   If only there was a way to spin up WordPress on Azure with MSSQL.   

Fortunately there *IS*.  I stumbled across this reference on the Internet which allows you to create an Azure WordPress instance while leveraging MSSQL using the “Project Nami for WordPress” from this article on “Visual Studio Adventure”

Following these instructions I was able to spin up a New WordPress instance with MSSQL as the target Database, Migrate my Domains and content and get up and running.

Honest MySQL is a great solution but within Azure I think Microsoft should have either hosted it themselves or arranged some kind of credit program with ClearDB.

But I’m happy now with my Website and MSSQL in Highly available mode Smile

Sean
The Energized Tech

Leave a Reply