News

Azure Database Now Has MySQL and PostgreSQL Options

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

  • Microsoft Hires Movial To Build Android OS for Microsoft Devices

    Microsoft has hired the Romanian operations of software engineering and design services company Movial to develop an Android-based operating system solution for the Microsoft Devices business segment.

  • Microsoft Ending Workflows for SharePoint 2010 Online Next Month

    Microsoft on Monday gave notice that it will be ending support this year for the "workflows" component of SharePoint 2010 Online, as well as deprecating that component for SharePoint 2013 Online.

  • Why Windows Phone Is Dead, But Not Completely Gone

    Don't call it a comeback (because that's not likely). But as Brien explains, there are three ways that today's smartphone market leaves the door open for Microsoft to bring Windows back to smartphones.

  • Feature Update Deferral Mix-Up in Windows 10 Version 2004 Further Explained

    Microsoft last week described the confusion it is attempting to avoid by removing the client graphical user interface (GUI)-based controls to defer Windows 10 feature updates, starting with version 2004.

comments powered by Disqus

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.