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

Using Configuration Files to Control PowerShell Scripts, Part 2: Building Blocks

Learn how to use PowerShell's GUI capabilities to dynamically create configuration files that enhance script flexibility and usability.
U.S. House Leaders Unveil Bipartisan Strategy for AI Governance and Innovation

On Tuesday, U.S. House Speaker Mike Johnson and Democratic Leader Hakeem Jeffries received the final report from the bipartisan House Task Force on Artificial Intelligence, which outlines essential principles and recommendations to bolster American leadership in AI.
Using Configuration Files to Control PowerShell Scripts, Part 1: The Basics

Learn how to use JSON configuration files to make PowerShell scripts more dynamic, flexible and user-friendly.
Exchange Online Receiving Enhanced Message Trace

Microsoft has announced the public preview of its enhanced Message Trace feature in the Exchange admin center (EAC) for Exchange Online.
Major Microsoft Multifactor Authentication Vulnerability Revealed

A vulnerability in Microsoft’s multifactor authentication (MFA) system has been uncovered by cybersecurity firm Oasis Security, allowing attackers to bypass security measures and access sensitive data across services including Outlook, OneDrive, Teams and Azure.