Windows Azure Development Select MySQL or SQL Database

Windows http://www.aliyun.com/zixun/aggregation/13357.html ">azure currently does not directly provide MySQL database services, but there is a collaboration with CLEARDB to provide MySQL Database service, or use the Windows Azure virtual machine (Windows Server or Linux Server) service to establish your own MySQL server.

In the PHP program to connect to the MySQL database, you can directly use the mysqli_* (MySQL Improvement Extensions) series (Mysql_* series of APIs in a future version to be removed) APIs or Pdo_mysql, in Both APIs are directly available in the PHP execution environment on Windows Azure.

Use the MySQL service provided by Cleardb

Currently a Windows Azure subscription account can use a MySQL database service provided by CLEARDB, and Cleardb also provides MySQL database services worldwide based on Windows Azure's data center, allowing you to Windows Azure Services can also be available while Windows Azure and Cleardb currently collaborate with the program as an introductory Mercury program (refer to this page), depending on the use of the situation can be at any time in the Cleardb of the Web page to upgrade the dosage.

With this collaboration, you can create a MySQL database directly when you create a Windows Azure Web site service (or install a Web package that requires MySQL):

The MySQL database provided by Cleardb can be built directly on the Windows Azure management interface

If you want to use more MySQL databases, you can purchase them in the Windows Azure Store, in addition to the Cleardb purchase (Taiwanese users are not yet open). However, due to the MySQL database service provided by CLEARDB, the SLA (service level) often mentioned in the cloud service is subject to the CLEARDB condition.

As for the database management, you can choose familiar MySQL management tools, online to the leased MySQL database for management.

Use virtual machines to set up MySQL server

After you use the services provided by Windows Azure virtual machines to set up Windows Server or Linux server, you can decide which version of MySQL to install, but for the MySQL server, Or the service level of a virtual machine (for example, having to set up more than two virtual machine entities, and establishing a availability set to ensure high availability) or security requires a little more effort.

Using SQL database Databases

Windows Azure provides a SQL database server that allows users to select a new database only in the background, without having to set up or manage SQL servers on their own, and to charge everything according to usage. In addition, Windows Azure itself provides an interface for managing SQL database online (in Silverlight), providing developers the right to manage SQL database directly through a Web page, as well as support for managing SQL Server SQL Server Management Studio software for management.

To connect to the SQL Database service in a PHP application, you can directly use the step-by-step teaching on the Apis,windows Azure product page of the SQLSRV or Pdo_sqlsrv library: "how to Access Windows Azure SQL Database from php".

In addition, instructions on the SQLSRV and Pdo_sqlsrv APIs can refer to the pages on MSDN: "microsoft Drivers for PHP for SQL server".

Using other database systems

In addition to MySQL and SQL Database, Windows Azure also works with Oracle to build virtual machines with Oracle Database installed directly on Windows Azure:

With Oracle's official Oracle database, it is possible to use standard Oracle management tools to manage the database, and the PHP application interface can be connected using OCI8 APIs.