Azure Database for MySQL provides a fully managed, enterprise-ready, community MySQL database as a service that includes scalability, backups, and high availability.

This article is a basic tutorial on how to create an Azure Database Instance. So without any further ado, let’s delve right into the details! 

Prerequisites

You will require an Azure subscription.

Steps To Create an Azure Database Instance for MySQL 

Follow these steps to deploy Azure databases for MySQL server!  

Step 1: Go to the Azure portal and search for MySQL. 

Step 2: Select the Azure Database for MySQL servers and create a new instance. You can see two options there: Single server and Flexible server. What do they mean? 

• Single Server

Single server is built to handle the majority of database management capabilities, including backups, patching, high availability, and security that comes with minimal user configuration and control. 

• Flexible Server

Flexible server (preview) provides extended flexibility and granular control over database management features and configurations based on user requirements. Currently, it is in preview mode. 

Here we are selecting Single server –> Click on Create.  

Step 3: Under the Project details section, select Subscription and choose the resource group. 

Step 4: Under the Server details section, provide the Server name, Location, and MySQL version. 

Step 5: You can configure your MySQL instance by modifying Compute + storage

Step 6: You will see 3 tiers (Basic, Standard, and Memory-optimized) of MySQL instances. Select one as per your requirements. 

• Basic

Basic Tier is suitable for databases requiring light computing power and moderate I/O performance, such as development or testing databases. 

• General Purpose

General Purpose Tier provides compute capability and memory for average production databases, with scalable I/O throughput. For example, a database used for a web or enterprise application. 

• Memory-Optimized

This Tier can support databases that require speedy transaction processing and many concurrent users, for example, a database used for real-time analytics. 

Step 7: You can also adjust the selected Tier’s vCore, Storage, and Backup Retention Period by scrolling down. 

Step 8: You can also find the estimated price summary from the right side pane. 

Step 9: After modifying everything, click OK.

Step 10: Under the Administrator account section, provide MySQL Admin username and password. 

Step 11: Click Review + Create.

The new MySQL instance will be deployed within a minute.

Wrapping Up

Well, that was all about creating an Azure Database Instance for MySQL. 

At SysAlly, we experiment with Cloud and the most useful information is passed on to the world as blogs. Signup for the updates.

Until later, here’s SysAlly signing off!