Microsoft announces the availability of Azure database services for MySQL and PostgreSQL

Microsoft announces the availability of Azure database services for MySQL and PostgreSQL

Microsoft announced the availability of Azure database services for MySQL and PostgreSQL. Azure uses the community versions of these two open source databases as managed services, supports elastic scaling, provides 99.99% SLA, and industry-leading security and compliance.

More and more open source applications are coming to the Azure platform, and Microsoft is also open to support them. Sunil Kamath from the Azure database engine team said:

With the addition of MySQL and PostgreSQL, the relational database blueprint of the Azure platform has expanded. Azure MySQL and Azure PostgreSQL use the same architecture as Azure SQL Database, which has been used on the Azure platform for many years.

Preview versions of Azure MySQL and Azure PostgreSQL were released in May 2017. Since then, Microsoft has made significant improvements in scalability, backup flexibility, security, and industry compliance (such as following ISO, SOC, and HIPAA standards). In addition, these two services also meet the compliance requirements of the General Data Protection Regulation (GDPR) that will be implemented in May this year. However, it should be noted that although the underlying cloud infrastructure meets various compliance requirements, development engineers still have the responsibility to ensure that the applications they develop also meet the requirements-this is also known as the shared responsibility model .

Users can search for these two services on Azure Portal, and specify the information that needs to be created for the database, and then the database can be created. After the database is running, the user can configure the IP address of the client that needs to access the database. In addition, other Azure services can directly access the database without explicitly setting the IP address.

In addition to creating an instance separately, you can also include the database in the Web App, and you can automatically deploy the database instance or the Web App that contains the database instance through the ARM template. Both of these database instances can be managed directly through Cloud Shell, Azure CLI or Azure Portal. Cloud Shell already provides client tools for integrating these two databases. Their built-in backup service can retain data for 35 days, and the backup data can be placed in other physical areas for disaster recovery purposes.

Users who use MySQL or PostgreSQL locally can migrate their local database instance to Azure. They can use tools such as mysqldump or pg_dumps to migrate their local instances to Azure. They can also use Azure Database Migration Service (DMS), which will greatly reduce downtime. This service can ensure that the source database is not affected in any way during the migration. However, this service currently only provides a preview version of MySQL, and the PostgreSQL version will be available later.

Microsoft now provides fully managed MySQL and PostgreSQL database engine services to compete with other cloud providers. For example, AWS provides RDS and Aurora , and Google Cloud Platform provides Google Cloud SQL .

These two database services are available in 22 regions around the world, and the available areas are still increasing. It is expected that the available areas will reach more than 40. The pricing details of the service can be viewed by clicking the link ( Azure MySQL pricing and Azure PostgreSQL pricing). In addition, the features provided by the two database services can be seen in the official documentation ( Azure MySQL documentation and Azure PostgreSQL documentation).

View the original English text : Microsoft Announces General Availability of Azure Database Services for MySQL and PostgreSQL