Open In App

Microsoft Azure – Using Flexible Server in Azure Database for MySQL

Improve
Improve
Like Article
Like
Save
Share
Report

Pre-requisite: Azure VM

Azure Database for MySQL is a PaaS implementation of MySQL in the Azure cloud. It provides high availability at no extra charge, as well as scalability as needed, automatic backups, and point-in-time restores. Connection security is provided by the server, which enforces firewall restrictions and, optionally, requires SSL connections. You can define server settings such as lock modes, the maximum number of connections, and timeouts using a variety of server parameters. Azure Database for MySQL is a worldwide database solution that allows you to scale up to huge databases without having to worry about managing hardware, network components, virtual servers, software patches, or other underlying components.

There are two deployment options for Azure Database for MySQL:

  • MySQL in Azure Database Single Server is a fully managed database as a service with predictable performance and scalability. Single servers are ideal for applications that are already running on a single server.
  • MySQL in Azure Database Flexible Server is a fully managed database as a service with predictable performance and scalability. Database management functions and configuration settings are more granularly controlled and flexible with Flexible Server. All new developments or migrations should use the flexible server deployment option.

Below are the steps to deploy Azure Database for MySQL.

Step1. Login to Microsoft Portal. Select Create a Resource and Search Azure Database for MySQL.

Create Resorce

 

Step 2. Select Flexible Server and Click Create.

select db

 

Step 3. In Basic, Select Subscription, resource group, and server details (Server name, Region, MySQL version, Workload type, Storage, Administrator account) according to the requirements. Click Next.

slexible server

 

Step 4. In Networking, select Network connectivity, add firewall rules, Click Next, add tags if required.

network

 

Step 5: Click on Review + Create and verify the configuration and Click Create.

create server

 

Wait for deployment to complete. The newly created Azure Database for MySQL will be available in resources:

resources

 


Last Updated : 03 Apr, 2023
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads