Azure Services Part 5 — Azure Database for MySQL server integration with Azure Services

This article has been written as a partial requirement for the course : SENG 41283 : Distributed and Cloud Computing. The main areas discussed here are :

• setting up a sample environment in Azure cloud platform
• the cloud infrastructure setup for a simple web application using the available services in Azure

Azure Database for MySQL server

Azure Database for MySQL is easy to set up, manage, and scale. It automates the management and maintenance of your infrastructure and database server, including routine updates, backups, and security.

With this article let’s see how I integrate Azure DB for my PHP application.

In my project,

• I need to capture the doctor appointment booking details in order to accept or reject the appointments.
• I need to capture doctor availability
• Capture user information so on.

To create the server I usedAzure Database for MySQL servers.

For my project I allowed two IP addresses.

Then I connected server and created the datadase and tables. (I used heidiSQL)

Connecting the App to Azure Database

Now that we have the web app, a database and tables created, we need to make a connection between the two of them.

In order to configure SSL connectivity, you need to download SSL certificate from here.

The database and the application are now connected and the tables will be updated when the user make a doctor appointment.

References —

MySQL Database - Fully-Managed Service | Microsoft Azure

Azure Database for MySQL documentation

Thank You!