Azure Database Now Has MySQL and PostgreSQL Options -- Redmondmag.com

Azure Database Now Has MySQL and PostgreSQL Options

By Kurt Mackie
03/22/2018

Microsoft this week announced the commercial availability of Azure Database services for both MySQL and PostgreSQL.

The two open source database management systems reached "general availability" status on Azure after having been previews on Azure Database infrastructure since last year. They are currently available in "22 regions worldwide," but Microsoft is planning to expand availability to all Azure regions "in the coming months."

Azure Database on MySQL and Azure Database on PostgreSQL were both described as "community editions" by Sunil Kamath of the Azure Database engineering team in a Microsoft video. Both meet various compliance standards, including HIPAA. Microsoft also is promising compliance with the General Data Protection Regulation (GDPR) when it comes into effect on May 25.

The use of MySQL and PostgreSQL on Azure datacenter infrastructure adds built-in scalability and high availability, plus a 99.99 percent service-level agreement uptime assurance from Microsoft. Both database management systems can scale to 32 "vCores," according to Microsoft's announcement.

Organizations can use a toggle switch in the Azure Portal to connect the database management systems to Azure services, according to a demo by Kamath. PowerShell is built into the Azure Portal for management tasks. It's possible to set backup for 35 days before restoring data, and it's also possible to set up backup in a different Azure region to get data redundancy protections, according to Kamath.

The announcement claimed that existing tools, such as mysqldump and pg_dump (for PostgreSQL), can be used to migrate these databases to Azure datacenters. There's also a "limited preview" available to use the Azure Database Migration Service to move MySQL workloads to Azure infrastructure. Microsoft is promising to add PostgreSQL migration support to that tool, as well. The Azure Database Migration Service is still at the preview stage.

Microsoft's next planned open source addition to Azure Database will be the MariaDB database management system, a MySQL variant. It'll be arriving on Azure in the "coming few months," the announcement indicated. It had been available as a preview since November, which is when Microsoft joined the MariaDB Foundation.

About the Author

Kurt Mackie is senior news producer for 1105 Media's Converge360 group.

Featured

Choosing the Right SSID for Your Network

Attracting attention, whether through a default or funny Wi-Fi name, could lead to a security issue.
Microsoft Outlines Latest Security Efforts at Ignite

In the wake of last year's CrowdStrike incident, Microsoft has worked to publicly rehabilitate its security image through new initiatives and public commitments to improve. That push continued this week at Ignite, where Microsoft announced a handful of new security tools and updates.
Nadella on Copilot: 'Major Platform Shifts Are in the Air'

As should be no surprise, Copilot took center stage during Microsoft CEO Satya Nadella's keynote speech to open Microsoft Ignite 2024.
Azure AI Foundry Revealed at Microsoft Ignite

Microsoft is consolidating its Azure generative AI tools into a unified platform named Azure AI Foundry.
Microsoft Bolsters Fabric at Ignite

While Fabric has improved in the year since its release, there are still some glaring issues with the platform.