Windows Azure Pack – MySQL Server

In the previous topic, I have configured the Website clouds service in the Windows Azure Pack. However websites usually need a database to store configuration and user data. For example Tech-Coffee is powered by WordPress which needs a MySQL database. So in this topic we will see how to implement the MySQL Servers service on the Windows Azure Pack.

MySQL Server installation and configuration

To host MySQL database, I have created a virtual machine called VMWAP18-MySQL01. On this machine I have downloaded Web Platform Installer (WPI). Next I have Run WPI with run as administrator privilege. Then I have added MySQL Windows X.X component.

Once you have clicked on install, WPI asks you a password for the root account. Type a password and click on Continue.

Next accept the license terms.

There is no other configuration in WPI. Once MySQL is downloaded and installed, click on finish.

To finish, open MySQL command line, log on with root account and execute these commands:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION
FLUSH PRIVILEGES;

NB: If your firewall is activated on your server, don’t forget to create a rule to grant access on port TCP 3306.

Windows Azure Pack configuration

Now that MySQL is installed, we can add the MySQL server to WAP. Connect to the administrator portal and click on MySQL Servers.

First I create a new group called Dharma-MySQL as below:

Once the group is created, I connect to the MySQL Server with the root account. I recommend to not use this account in a production environment.

Once you are connected to the MySQL Server, you can add MySQL Service to a hosting plan.

Include MySQL service to a hosting plan

To add the MySQL service to a hosting plan, go to the plan and click on Add Service.

Select the service that you want to add to the hosting plan. For this example I select MySQL Servers.

And here the MySQL Servers service is added to Dharma plan.

WordPress implementation

Now that MySQL is implemented in the Windows Azure Pack, I’m going to check the working of MySQL from WAP by creating a WordPress website. First I create a website. For more information about websites, read this topic.

Next I create a website called tech-coffee J. I select Create a new MySQL database.

Specify a name for this database and choose the edition (the MySQL Server group name).

Next specify credentials for the database.

Once the site is created, a MySQL database should be created as below:

After having uploaded WordPress on my website storage, I run the WordPress installation. So I specify the MySQL information (sorry for the french language on the below screenshot J):

After the installation I’m connecting to the WordPress admin area. It seems to work J.

About Romain Serre

Romain Serre works in Lyon as a Senior Consultant. He is focused on Microsoft Technology, especially on Hyper-V, System Center, Storage, networking and Cloud OS technology as Microsoft Azure or Azure Stack. He is a MVP and he is certified Microsoft Certified Solution Expert (MCSE Server Infrastructure & Private Cloud), on Hyper-V and on Microsoft Azure (Implementing a Microsoft Azure Solution).

Leave a Reply

x

Check Also

Implement 5-Nine Cloud Security 5.1 in Windows Azure Pack

5-Nine Cloud Security is a security solution for Microsoft Cloud OS and Hyper-V. This solution ...

Windows Azure Pack – Authenticate tenants with AD FS

By default, Windows Azure Pack provides an Authentication site for tenants. This authentication site can ...

Windows Azure Pack – Website gallery issue

I had an issue with the WebSite Gallery in my Windows Azure Pack installation. When ...