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.
Step 2. Select Flexible Server and Click Create.
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.
Step 4. In Networking, select Network connectivity, add firewall rules, Click Next, add tags if required.
Step 5: Click on Review + Create and verify the configuration and Click Create.
Wait for deployment to complete. The newly created Azure Database for MySQL will be available in resources: