Related to a previous article and hands on lab guide on creating a WordPress site in Windows Azure, I have been getting a lot of questions on how to create a second or multiple WordPress sites in Windows Azure. As most have noticed, you can only create one MySQL database when you create your first WordPress site. This is not true. You can have up to 10 individual websites for free in the Free Mode.
If you want to create another individual WordPress site, you first must create another MySQL database. Windows Azure is partnered with ClearDB who hosts the free 20MB MySQL databases that WordPress uses. You can login on ClearDB’s website if you know your subscription user name and password, but the easy way is to navigate to a WordPress site that you have already built and then click on Linked Resources.
On the Linked Resources page, select Manage at the bottom of the page or click on the database name.
A new browser tab will open to your related ClearDB Subscription Account associated with your Windows Azure account. Click on Dashboard to see your overall account and create another database.
Click on Create a new database. You will notice that I have already a couple of databases running.
Select the Free database.
On the next screen, select your region in which you plan on creating the WordPress site in Windows Azure and click Next. Make sure to select the same region in Windows Azure when you go through the steps of creating a new WordPress site.
On the next page, review your order summary and click Create My Free Database!
It will take just a moment to create your new database.
Your summary screen. Click on the ClearDB logo at the top left of the page to go back to your dashboard.
On the dashboard page, make sure to make note of your new database name. At this point, you can close this browser tab, unless you need to create another database or perform other functions.
Now you can switch back to your Windows Azure portal and create a new WordPress website and use the database that you just created.
I hope this helps on creating multiple WordPress websites in Windows Azure. Next article will be on using WordPress Multi-site (network install) in Windows Azure.