Azure Database for MySQL Video
1 page views
190 video views
2024, June 29, Saturday

How to create Azure MySQL Database and how much it costs

Explore in this video the process from creating your MySQL resource in Azure to connecting it to essential tools like Power BI and Azure Data Studio

We'll learn the techniques

:Creation via Azure portal:

Walkthrough to create an Azure MySQL server via Azure

portal:Login to the

Azure

portal

Go to Azure portal and sign in to your account.

Search by MySQL:

In the left navigation pane, click "Create a resource."
In the search bar, type "MySQL" and choose "MySQL Database" from the results.

Fill in the

Basic Settings:

Click "Create" and fill in the basic information such as Subscription, Resource Group, Server Name, and Choice of Username and Password.

Advanced Settings -

Flexible Server:

Choose the "Flexible Server" option for more configuration options.
Configure the MySQL version, choose the region and server availability.

Network and Security Settings:

Configure network settings, such as firewall rules and VNET settings.
Choose backup options and adjust security settings as needed.

Review & Create:

Review

all settings and click "Review + Create".
After validation, click "Create" to provision the MySQL server in Azure.

Detailed Settings

Choice of Region:
- Select the Azure region that best meets your performance and compliance needs.
Job Type:
- Choose between "Hobby" or "Small Business" depending on workload and scalability requirements.
Compute Settings:
- Set the MySQL version, amount of vCores, and amount of memory to meet performance requirements.
Storage:
- Configure the disk size for the database.
Security:
- Configure security settings such as firewall rules, encryption options, and auditing.

Understanding Costs

View Price Estimates:
- Predict costs based on the settings you choose.
Customize Settings:
- Adjust settings, such as the amount of vCores and storage, to see how they affect costs.

Connect to Tools

Azure MySQL with
Power BI:
- Open Power BI and choose "Get Data".
- Select "MySQL Database" as the data source and provide the connection information.
MySQL with
Azure Data Studio:
- Open Azure Data Studio and select "New Connection".
- Choose "MySQL" as the server type and enter the connection details.

These steps provide an overview of the process of creating, configuration, costing, and connecting an Azure MySQL server, enabling advanced analytics with tools such as Power BI and Azure Data Studio.