How to Create an Azure Database for MySQL Flexible Server in Azure Portal

by

Creating an Azure Database for MySQL Flexible Server is a straightforward process that offers more granular control and flexibility for your database management. This guide walks you through the steps to set up your server in the Azure portal.

Table of Contents

Step 1: Search for MySQL Flexible Servers

Sign into your Azure portal and search for “Azure Database for MySQL flexible servers” in the top search bar. Select the service from the results and click the Create button.

Step 2: Configure Basic Settings

On the Basics tab, you need to provide the following details:

  • Subscription: Select your active subscription (e.g., Pay-As-You-Go).
  • Resource Group: Choose an existing group or create a new one for your database.
  • Server Name: Enter a unique name for your MySQL server.
  • Region: Choose the region closest to your users (e.g., South India).
  • MySQL Version: Select the desired version (e.g., 8.0).
  • Workload Type: Choose between Small, Medium, or Large based on your needs. For development, “Dev/Test” is often suitable.

Step 3: Compute and Storage Configuration

You can customize the server’s performance by clicking Configure server. Here, you have three tiers:

  1. Burstable: Ideal for workloads that don’t need continuous full CPU performance.
  2. General Purpose: Balanced for most common production workloads.
  3. Memory Optimized: High-performance for memory-intensive applications.

You can also adjust the vCores, Storage size, and IOPS (Auto scale or pre-provisioned).

Step 4: Authentication and Security

Choose your authentication method. The default is MySQL authentication.

  • Admin Username: Set a login name.
  • Password: Create a strong password. It’s recommended to use a password generator for security.

Step 5: Networking Options

In the Networking tab, you can choose how to access your server:

  • Public Access: Allows access via public IP addresses. You can specify which IPs are allowed through firewall rules.
  • Private Access: Connects the server to a Virtual Network (VNet) for enhanced security.

Step 6: Review and Create

Add tags to the resource and review all your configurations. Once satisfied, click Review + Create. Azure will perform a final validation. After validation passes, click Create to begin the deployment.

Step 7: Accessing Your Resource

Once the deployment is complete, go to the resource. You will find essential details like the Server Name, Admin Login Name, and Server Endpoint. From this dashboard, you can manage your server, reset passwords, restart, or upgrade its configuration as needed.

Leave a Comment