Azure Database for MySQL - Mini Project: Build & Apply

Azure Database for MySQL Setup and Configuration

📖 Scenario: You are setting up a simple Azure Database for MySQL server for a small business application. This database will store customer information securely and allow the application to connect and query data.

🎯 Goal: Build an Azure Database for MySQL server with basic configuration, including resource group, server creation, firewall rule, and database creation.

📋 What You'll Learn

Create a resource group named myResourceGroup in the eastus region.

Create an Azure Database for MySQL server named mymysqlserver with admin username mysqladmin and password MyP@ssw0rd123.

Set the server version to 5.7 and configure the SKU to B_Gen5_1.

Add a firewall rule named AllowMyIP to allow access from IP 0.0.0.0 to 255.255.255.255.

Create a database named mydatabase on the MySQL server.

💡 Why This Matters

🌍 Real World

Setting up a managed MySQL database in Azure is common for web applications, mobile apps, and backend services that require reliable and scalable data storage.

💼 Career

Cloud engineers and database administrators often need to provision and configure managed database services like Azure Database for MySQL to support application development and deployment.

1

Create the Resource Group

Write the Azure CLI command to create a resource group named myResourceGroup in the eastus region.

Azure

# Your Azure CLI command here to create the resource group

Hint

Use az group create with --name and --location options.

2

Create the MySQL Server

Write the Azure CLI command to create an Azure Database for MySQL server named mymysqlserver in resource group myResourceGroup with admin username mysqladmin, password MyP@ssw0rd123, server version 5.7, SKU B_Gen5_1, and location eastus.

Azure

az group create --name myResourceGroup --location eastus
# Your Azure CLI command here to create the MySQL server

Hint

Use az mysql server create with all required parameters.

3

Add a Firewall Rule

Write the Azure CLI command to add a firewall rule named AllowMyIP to the MySQL server mymysqlserver in resource group myResourceGroup allowing access from IP 0.0.0.0 to 255.255.255.255.

Azure

az group create --name myResourceGroup --location eastus
az mysql server create --resource-group myResourceGroup --name mymysqlserver --admin-user mysqladmin --admin-password MyP@ssw0rd123 --sku-name B_Gen5_1 --version 5.7 --location eastus
# Your Azure CLI command here to add the firewall rule

Hint

Use az mysql server firewall-rule create with the correct parameters.

4

Create the Database

Write the Azure CLI command to create a database named mydatabase on the MySQL server mymysqlserver in resource group myResourceGroup.

Azure

az group create --name myResourceGroup --location eastus
az mysql server create --resource-group myResourceGroup --name mymysqlserver --admin-user mysqladmin --admin-password MyP@ssw0rd123 --sku-name B_Gen5_1 --version 5.7 --location eastus
az mysql server firewall-rule create --resource-group myResourceGroup --server mymysqlserver --name AllowMyIP --start-ip-address 0.0.0.0 --end-ip-address 255.255.255.255
# Your Azure CLI command here to create the database

Hint

Use az mysql db create with the correct parameters.

Practice

1. What is the main purpose of Azure Database for MySQL?

easy

A. To provide a managed MySQL database service in the cloud

B. To create virtual machines for running MySQL manually

C. To store files and documents in the cloud

D. To host websites without databases

Solution

1. Step 1: Understand Azure Database for MySQL service

   It is a managed service that runs MySQL databases in the cloud, handling maintenance tasks.

2. Step 2: Compare options with service purpose

   Only To provide a managed MySQL database service in the cloud describes a managed MySQL database service, others describe unrelated services.

3. Final Answer:

   To provide a managed MySQL database service in the cloud -> Option A

4. Quick Check:

   Managed MySQL service = To provide a managed MySQL database service in the cloud [OK]

Hint: Managed means Azure handles database tasks for you [OK]

Common Mistakes:

• Confusing database service with virtual machines
• Thinking it stores files like blob storage
• Assuming it hosts websites directly

2. Which of the following is the correct way to create a new Azure Database for MySQL server using Azure CLI?

easy

A. az mysql server new --resource-group MyGroup --name MyServer --location eastus --admin-user admin --admin-password MyPass123

B. az sql server create --resource-group MyGroup --name MyServer --location eastus --admin-user admin --admin-password MyPass123

C. az mysql server create --resource-group MyGroup --name MyServer --location eastus --admin-user admin --admin-password MyPass123

D. az mysql create server --resource-group MyGroup --name MyServer --location eastus --admin-user admin --admin-password MyPass123

Solution

1. Step 1: Identify correct Azure CLI command syntax

   The correct command to create a MySQL server is az mysql server create.

2. Step 2: Check options for correct command and parameters

   az mysql server create --resource-group MyGroup --name MyServer --location eastus --admin-user admin --admin-password MyPass123 uses the correct command and parameters. Options A, B, and C use incorrect commands or syntax.

3. Final Answer:

   az mysql server create --resource-group MyGroup --name MyServer --location eastus --admin-user admin --admin-password MyPass123 -> Option C

4. Quick Check:

   Correct CLI command = az mysql server create --resource-group MyGroup --name MyServer --location eastus --admin-user admin --admin-password MyPass123 [OK]

Hint: Use 'az mysql server create' to create MySQL server [OK]

Common Mistakes:

• Using 'az sql' instead of 'az mysql'
• Incorrect command order or missing 'server'
• Using 'new' or 'create server' incorrectly

3. Given this Azure CLI command output snippet after creating a MySQL server:

{
  "name": "myserver",
  "location": "eastus",
  "userVisibleState": "Ready",
  "version": "5.7"
}

What does the userVisibleState value indicate?

medium

A. The server is currently being deleted

B. The server is ready to use

C. The server is paused

D. The server is in an error state

Solution

1. Step 1: Understand 'userVisibleState' meaning

   This field shows the current status of the MySQL server as seen by the user.

2. Step 2: Interpret the value 'Ready'

   'Ready' means the server is fully set up and available for connections.

3. Final Answer:

   The server is ready to use -> Option B

4. Quick Check:

   'Ready' means usable server = The server is ready to use [OK]

Hint: 'Ready' means server is active and usable [OK]

Common Mistakes:

• Confusing 'Ready' with 'Paused' or 'Deleting'
• Assuming 'Ready' means error or maintenance
• Ignoring the status field meaning

4. You tried to connect to your Azure Database for MySQL server but got a connection error. Which of the following is the most likely cause?

medium

A. The MySQL version is outdated

B. The database name is missing in the connection string

C. The server is located in a different Azure region

D. The server firewall rules do not allow your client IP

Solution

1. Step 1: Identify common connection error causes

   Firewall rules blocking client IP is a frequent cause of connection failures.

2. Step 2: Evaluate other options

   MySQL version or region mismatch usually do not cause connection errors. Missing database name causes different errors.

3. Final Answer:

   The server firewall rules do not allow your client IP -> Option D

4. Quick Check:

   Firewall blocking IP = The server firewall rules do not allow your client IP [OK]

Hint: Check firewall rules to allow your IP address [OK]

Common Mistakes:

• Ignoring firewall settings
• Blaming MySQL version for connection issues
• Assuming region affects connectivity directly

5. You want to ensure your Azure Database for MySQL server automatically scales compute resources during peak hours and reduces them at night to save cost. Which Azure feature should you use?

hard

A. Use the 'Flexible Server' deployment option with auto-scaling enabled

B. Enable the 'Auto-scaling' feature in the server configuration

C. Configure the server with the 'Burstable' pricing tier

D. Manually change the server SKU daily using Azure CLI scripts

Solution

1. Step 1: Understand scaling options in Azure Database for MySQL

   The Flexible Server deployment supports auto-scaling features for compute resources.

2. Step 2: Evaluate options for auto-scaling support

   Use the 'Flexible Server' deployment option with auto-scaling enabled correctly identifies Flexible Server with auto-scaling. Burstable tier does not auto-scale. Manual scripts are not automatic. 'Auto-scaling' feature is not a direct setting in standard server.

3. Final Answer:

   Use the 'Flexible Server' deployment option with auto-scaling enabled -> Option A

4. Quick Check:

   Flexible Server supports auto-scaling = Use the 'Flexible Server' deployment option with auto-scaling enabled [OK]

Hint: Use Flexible Server for built-in auto-scaling [OK]

Common Mistakes:

• Confusing Burstable tier with auto-scaling
• Thinking manual scripts are automatic
• Assuming 'Auto-scaling' is a simple toggle in all servers