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: Azure Machine Learning – Public Preview for September Preview: Save Azure Backup Recovery Services Agent (MARS) passphrase to Azure Key Vault Preview: Cross Region Restore (CRR) for Recovery Services Agent (MARS) using Azure Backup Generally available: Azure Ultra…
Also this week there were many news around Microsoft Azure! Here as always the overview for you: Azure Load Testing now supports uploading large files as ZIP Move Azure Load Testing resources across resource groups and subscriptions Generally available: Azure Premium SSD v2 Disk Storage is now available in more regions Public Preview: Azure Container…
Also this week there were many news around Microsoft Azure! Here as always the overview for you: Generally Available: Azure Monitor VM Insights using Azure Monitor Agent Azure Firewall Single-Click Upgrade and Downgrade is now in general availability Azure Firewall: Explicit Proxy is now in public preview Public Preview: Azure Log Alerts support for Azure…
Also this week there were many news around Microsoft Azure! Here as always the overview for you: Quick create Azure Front Door endpoints for Azure Storage accounts General Availability: AzAcSnap 9 — Azure Application Consistent Snapshot tool updates Update type on your application insights troubleshooting guides by 31 March 2024 Public preview: Rate-limit rules for…
Also this week there were many news around Microsoft Azure! Here as always the overview for you: Public Preview: Custom NFSv4.1 ID Domain in Azure NetApp Files Public Preview: Azure Elastic SAN Updates: Private endpoints & shared volumes Generally Available: SDK type bindings in Azure Functions Generally Available: Kubernetes 1.27 support in AKS Generally available:…
Datenschutz & Cookies: Diese Website verwendet Cookies. Wenn du die Website weiterhin nutzt, stimmst du der Verwendung von Cookies zu.
Weitere Informationen, beispielsweise zur Kontrolle von Cookies, findest du hier:
Cookie-Richtlinie
Leave a comment