Azure Database for MariaDB

Azure Database for MariaDB Overview

Azure Database for MariaDB is a fully managed relational database service based on the open‑source MariaDB community edition. It provides built‑in high availability, automated backups, scaling, and security.

Fully managed service – no hardware or OS maintenance
Enterprise‑grade security and compliance
Auto‑scale compute and storage
Integrated monitoring with Azure Monitor
Global replication with read replicas

Getting Started

Log in to the Azure portal.
Create a new MariaDB server via Create a resource → Databases → Azure Database for MariaDB.
Configure compute tier, storage, and networking.
Set up firewall rules to allow client IPs.
Connect using your preferred tool (MySQL Workbench, Azure Data Studio, etc.).

mysql -h <servername>.mariadb.database.azure.com -u <adminUser>@<servername> -p

Key Concepts

Compute and Storage

Compute is measured in vCores; storage is provisioned in GB. Both can be scaled independently without downtime.

Backup & Restore

Automated backups are taken every 5 minutes and retained for up to 35 days. Use az mariadb server restore to restore to a point in time.

High Availability

Built‑in HA provides 99.99% uptime SLA with automatic failover within a region.

Performance Tuning

Use the performance tuning guide to optimize queries, indexes, and server parameters.

Enable query_cache_type for read‑heavy workloads.
Adjust innodb_buffer_pool_size to 70‑80% of memory.
Monitor slow queries via performance_schema.

API & SDKs

Manage MariaDB resources programmatically using Azure CLI, PowerShell, or REST API.

# Azure CLI example
az mariadb server create \
    --resource-group MyResourceGroup \
    --name mymariadbserver \
    --location eastus \
    --admin-user adminuser \
    --admin-password MyP@ssw0rd \
    --sku-name B_Gen5_2

Azure Docs