Migrate MySQL Apps and Data to Windows Azure

If you have applications running on-premises or in the cloud that store data in MySQL databases, the ClearDB on Windows Azure service can help you eliminate the need to configure, deploy, and manage MySQL. ClearDB is a powerful, fault tolerant database-as-a-service in the cloud for your MySQL powered applications. ClearDB provides zero-administration MySQL on Windows Azure, geographically distributed for high availability, making working with MySQL powered applications in the cloud easier than ever.

Use of the ClearDB service means you can decouple your database layer from your application. After creating a MySQL database on Windows Azure, you will need to update your code to use the connection string for this new database. The application itself can be deployed as a Windows Azure cloud service, hosted on a Windows Azure virtual machine, or continue to run on-premises if required.

There are four different service plans available for the MySQL service on Windows Azure:

ClearDB-on-Azure

You can try out the ClearDB service at no cost via the Mercury service plan. To provision a Mercury database on a Windows Azure web site, log in to the Windows Azure management portal and select New / Compute / Web Site / Create With Database:

Azure-management-portal

Then select “Create a new MySQL database” on the Create Web Site dialog:

Create-Website-Dialog

After setting your connection string and database name, you’ll have a MySQL database up and running in a matter of seconds, ready for testing and development.

For general guidance on migrating applications to Windows Azure, see the MSDN article Migrating Data-Centric Applications to Windows Azure.