¿Cómo crear bases de datos MariaDB y MySQL en Azure utilizando la interface gráfica?

How to create a MySQL or MariaDB database in Azure?

Managing databases in the cloud is a crucial skill in today's technology environment. Learning how to set up a MySQL or MariaDB database in Azure can open the door to a world of possibilities. In this guide, we show you how to do it step-by-step from the Azure portal, starting with setting up a MySQL database server.

What are the steps to set up a MySQL server in Azure?

To set up a MySQL server in Azure, you must:

1. Log in to the Azure portal: Go to the Azure portal and search for "Azure database for MySQL".
2. Create a MySQL resource: Click create a new resource and select MySQL server. This will take you to a configuration screen.
3. Complete the basic configuration:
   • Subscription: Make sure you have an active Azure subscription.
   • Resource group: Select an existing resource group or create a new one. For example, it can be "test server".
   • Server name: Choose a unique name, as it will be used to connect tools like MySQL Workbench to the server.
   • Region: Decide the location of the server, considering where the applications that will access the database are located to minimize latency, e.g. "Eastern United States".
4. Choose the MySQL version: You can choose between versions 5.6 (retired), 5.7 and 8.0. Version 5.7 is recommended here.
5. Select the service level: There are three levels:
   • Basic: For workloads with low processing requirements.
   • General Purpose: Balance between compute and storage.
   • Memory Optimized: Ideal for processing-intensive applications.
   To keep costs low, you could select the basic level with a core and 11GB storage.

What to consider when choosing advanced configurations?

Advanced configurations are crucial to the performance and recovery of your database:

• Storage Autogrowth: Allows the database to keep growing beyond the reserved storage, thus avoiding a read-only state.
• Redundancy: You can opt for local or geographic redundancy, ensuring that you can recover your data in case of failures, from the same region or any Azure location.

How to complete the configuration and deployment?

To complete the configuration process:

• Admin user and password: Define an admin user and set a secure password.
• Review and create: Verify the deployment details and proceed to create the server. This process may take a minute or two.

What additional configurations can be managed?

Once the database is deployed:

• Access the detailed configuration: From here, you can stop the database, reset passwords, and configure security options such as firewall rules and SSL.

Final thoughts for advanced users

If you have already mastered these graphical processes, our next class will focus on deploying databases through the Azure command line. We encourage you to continue exploring and amplifying your skills in these crucial tools for effective technology project development and management. The cloud is the limit!