Microsoft loves Open Source … but not only Open Source Operating Systems … so we can also find a bunch of Open Source Database Offerings in Microsoft Azure.
The most important ones are directly covered by Microsoft as “Azure Database” Services for:
MySql
PostgreSQL
MariaDB
Redis
Those databases are around in Azure for quite a while. For example, have a look at a post from 2018 where Microsoft announced the MariaDB preview and updates to MySQL and PostgreSQL.
Let’s have a look into those services.
Azure Database for MySQL
One of the most popular open source database systems is MySQL. it is available everywhere. If you have a contract with a hoster, you go to any cloud platform or you play around in your own world… MySQL is around.
In Azure you have two options to run MySQL. You could either spin up a VM and install you DB in there, or you use the Azure Database PaaS Service.
The Service comes with:
99,99% SLA
automatic OS and MySQL patching
backup capability
Advanced Threat Protection
performance recommendations
Right now MySQL in Azure is available in Version 5.6, 5.7 or 8.0.
The pricing is aligned on the vCore model and also supports the purchase of Azure Reservations. It comes in a basic, general purpose and high memory performance class.
Based on the selected performance tier and instance size there are some limitations that apply. For example there is a limit for the max ammount of connections that are allowed. Starting at 50 with a basic 1vCore tier … going up to 20.000 in a general purpose 64 vCore tier.
Also there are some technical limitations that are listed in the Microsoft Docs.
Azure Database for PostgreSQL
Another well known open source database systems is PostgreSQL. It is also available in most cloud providers and we see a lot of implementations in on-prem scenarios as well.
In Azure you have two options to run PostgreSQL. You could either spin up a VM and install you DB in there, or you use the Azure Database PaaS Service.
The Service comes with:
99,99% SLA
automatic OS and PostgreSQL patching
backup capability
Advanced Threat Protection
Single Server or Hyperscale design
Right now PostgreSQL in Azure is available in Version 9.5, 9.6. 10 or 11
The pricing is aligned on the vCore model and also supports the purchase of Azure Reservations. It comes in a basic, general purpose and high memory performance class.
Based on the selected performance tier and instance size there are some limitations that apply. For example there is a limit for the max ammount of connections that are allowed. Starting at 55 with a basic 1vCore tier … going up to 1.900 in a general purpose 64 vCore tier.
Also there are some technical limitations that are listed in the Microsoft Docs.
Azure Database for MariaDB
The youngest member in the open source database systems on Azure is MariaDB.
In Azure you have two options to run MariaDB. You could either spin up a VM and install you DB in there, or you use the Azure Database PaaS Service.
The Service comes with:
99,99% SLA
automatic OS and MariaDB patching
backup capability
Advanced Threat Protection
performance recommendations
Right now MariaDB in Azure is available in Version 10.2 and 10.3.
The pricing is aligned on the vCore model and also supports the purchase of Azure Reservations. It comes in a basic, general purpose and high memory performance class.
Based on the selected performance tier and instance size there are some limitations that apply. For example there is a limit for the max ammount of connections that are allowed. Starting at 50 with a basic 1vCore tier … going up to 20.000 in a general purpose 64 vCore tier.
Also there are some technical limitations that are listed in the Microsoft Docs.
One important known issue I would like to share with you:
MariaDB server instance displays the incorrect server version after connection is established. To get the correct server instance engine version, use the select version(); command.
Azure Cache for Redis
Redis will get its own article later in this series. So for now, let’s just have a look into the description:
Azure Cache for Redis is based on the popular software Redis. It is typically used as a cache to improve the performance and scalability of systems that rely heavily on backend data-stores. Performance is improved by temporarily copying frequently accessed data to fast storage located close to the application. With Azure Cache for Redis, this fast storage is located in-memory with Azure Cache for Redis instead of being loaded from disk by a database.
What else?!
Besides the official Microsoft offers for open source databases, there are plenty of services in the Azure Marketplace. For example you can find:
Also this week there were many news around Microsoft Azure! Here as always the overview for you: Public preview: SAP S/4HANA events are now available on Azure Event Grid Forrester Total Economic Impact study: Azure Arc delivers 206 percent ROI over 3 years General availability: Azure Sphere OS version 22.10 Generally available: Azure Communication Services…
Also this week there were many news around Microsoft Azure! Here as always the overview for you: Generally available: SFTP support for Azure Blob Storage Leverage SFTP support for Azure Blob Storage to build a unified data lake Azure Virtual WAN simplifies networking needs General availability: Azure Premium SSD v2 Disk Storage General availability: OpenTelemetry…
Also this week there were many news around Microsoft Azure! Here as always the overview for you: Generally available: Kusto Trender Public preview: Enhanced soft delete for Azure Backup Public preview: Multi-user authorization for Backup vaults Public preview: Immutable vaults for Azure Backup General availability: Azure NetApp Files application volume group for SAP HANA Generally…
Also this week there were many news around Microsoft Azure! Here as always the overview for you: Scalable management of virtualized RAN with Kubernetes Cost optimization using Azure Migrate Public preview: Azure Firewall Basic Generally available: Query Store hints Azure SQL Database, Azure SQL Managed Instance Azure Firewall Basic now in preview Microsoft and INT…
Also this week there were many news around Microsoft Azure! Here as always the overview for you: Public preview: Policy analytics for Azure Firewall General availability: ExpressRoute FastPath support for Vnet peering and UDRs Strengthen your security with Policy Analytics for Azure Firewall Ensure zone resilient outbound connectivity with NAT gateway Azure SQL—General availability updates…
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here:
Cookie Policy
Leave a comment