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

Register to attend the Microsoft MVP Virtual Conference


Hi All – I wanted to let you know about a great free event that Microsoft and the MVPs are putting on, May 14th & 15th.  Join Microsoft MVPs from the Americas’ region as they share their knowledge and real-world expertise during a free event, the MVP Virtual Conference.

The MVP Virtual Conference will showcase 95 sessions of content for IT Pros, Developers and Consumer experts designed to help you navigate life in a mobile-first, cloud-first world.  Microsoft’s Corporate Vice President of Developer Platform, Steve Guggenheimer, will be on hand to deliver the opening Key Note Address.

Why attend MVP V-Conf? The conference will have 5 tracks, IT Pro English, Dev English, Consumer English, Portuguese mixed sessions & Spanish mixed sessions, there is something for everyone! Learn from the best and brightest MVPs in the tech world today and develop some great skills!

Be sure to register quickly to hold your spot and tell your friends & colleagues.

The conference will be widely covered on social media, you can join the conversation by following @MVPAward and using the hashtag #MVPvConf.

Register now and feel the power of community!

<

p style=”text-align: center”>

Patch and Switch get Photo bombed at Microsoft Ignite

Here’s the stream from the Microsoft Ignite Edition of Patch and Switch.   Keep your eyes open for some Photo bombing that may (or may not have occurred, those involved refuse to admit it occurred)

I however have found evidence at 28:00 into the show of a Rogue Tilley being spotted in the back end worn by none other than Rick Claus’ Evil Doppelganger!

Proof below in the these pictures obtained SECRETLY from the back rooms!

Joey “Really Kearney?”

PhotoBomb0

Rick’s head twists about and thinks a quick “What the…. ?”

Photobomb1

“Boooommmmbbbbbssss Awaaaaayyyyy!!!!!”

Photobomb2

The truth is finally out!  Rick Claus and EnergizedTech are NOT the same person!

photobomb3

Rick is almost speechless.  “What ANOTHER BOMB?  Find me Pierre! I’ll bet he was up to this!  Somebody get me Volker!”

Photobomb4

But as Rick attempts to press the button to release the trap door to toss the  Doppelganger into the waiting Rancor pit, his nemesis scampers off like Hammy the Squirrel from “Over the Hedge”

Photobomb5

I swear!  This really happened!   Still can’t believe I was THIS CLOSE to being on the show too!

BTW …. This was totally Pierre’s idea !  I swear!  No no… REALLY! IT was ! I had no….

klik