How to Create Azure Database for MySQL Server in Microsoft azure.

Azure Database for MySQL is a relational database service in the Microsoft cloud based on the MySQL Community Edition (available under the GPLv2 license) database engine, versions 5.6, 5.7, and 8.0.

Azure Database for MySQL delivers:

  1. Built-in high availability.
  2. Data protection using automatic backups and point-in-time-restore for up to 35 days.
  3. Database engine to keep the service secure and up to date.
  4. Predictable performance, using inclusive pay-as-you-go pricing.
  5. Elastic scaling within seconds.
  6. Cost optimization controls with ability to stop/start server.

 

  • Login to azure portal
  • Click on All Services.
  • Select Azure Databases for MySQL Server.

 

Fig 1

 

  • Click on Create.

 

Fig 2

 

  • Select  an option Azure Database for MySQL database deployment.
  • If Select Single Server then click on Create option.

 

Fig. 3

 

  • On Basics tab provide the following values:-

 

  • Subscription: An Azure subscription grants you access to Azure services.
  • Resource group name: A resource group is a collection of resources.
  • Provide the Server name.
  • Select Data Source (Set the backup for MySQL server).
  • Select Location & MySQL Version.
  • Select compute + Storage plan as per requirements.
  • Provide the Administrator details like admin username & password.
  • Click on Next Additional Settings.

 

Fig. 3Fig. 4

 

  • At Additional settings,Add a second layer of encryption for your data using a different encryption algorithm which gives additional data protection
  • Click on Tags.

 

Fig. 5

 

  • On Tags Tab provide the tag name and value for Azure Database for MySQL Server.
  • Click Next on Review + Create.

 

Fig. 6

 

  • If you get a message “Validation passed”.
  • Then click on Create.

 

Fig.7

 

  • After some time, you will see a message as “Your deployment is ready”.
  • Click on “Go to resources” & You can see that the Azure Database for MySQL Server is there with the name we provide.

 

Leave a Reply