Azure Database for MySQL: Single Server

Overview

Azure Database for MySQL - Single Server provides resilient and scalable MySQL database capabilities to drive your application development and deployment on Azure. It offers multiple compute and storage tiers to help you scale your database independently of your virtual machines. This service is built on the MySQL community edition, ensuring compatibility and ease of migration.

Single Server is ideal for:

New cloud-native applications
Applications requiring easy migration from on-premises MySQL
Workloads where a single, dedicated database instance is sufficient
Development and testing environments

Key Features

Managed Service

Azure handles most of the database management tasks, including patching, backups, and high availability, allowing you to focus on your application.

Scalability

Scale compute and storage resources up or down as your needs change, with minimal downtime. Choose from General Purpose and Memory Optimized pricing tiers.

Security

Leverage Azure's robust security features, including network isolation with Virtual Networks, firewall rules, transparent data encryption, and integration with Azure Active Directory.

High Availability

Built-in high availability options ensure your database remains accessible even in the event of an infrastructure failure.

Performance

Optimized for high performance with features like in-memory caching and various pricing tiers to match your workload demands.

Getting Started

Creating an Azure Database for MySQL - Single Server instance is straightforward. You can use the Azure portal, Azure CLI, PowerShell, or ARM templates.

Quickstart: Create an Azure Database for MySQL - Single Server using Azure CLI

Here's a sample command to create a basic server:

az mysql server create \
    --resource-group myresourcegroup \
    --name myservername \
    --location westus2 \
    --admin-user myadmin \
    --admin-password  \
    --sku-name B_Gen5_1 \
    --tier Basic \
    --version 5.7
                

Replace placeholders like `myresourcegroup`, `myservername`, `westus2`, and `` with your specific values.

Once your server is created, you can connect to it using your preferred MySQL client or application.

Explore Tutorials Deploy Now

Pricing Tiers

Azure Database for MySQL - Single Server offers three pricing tiers to meet your application's performance and budget needs:

Basic: Cost-effective option for development and testing, and small workloads.
General Purpose: Balanced compute and memory for web and business applications.
Memory Optimized: High memory to support memory-intensive workloads like in-memory analytics.

Learn more about the detailed pricing and features for each tier in the official Azure pricing page.