Connecting web app to mysql database

Question

Hello, is it possible to connect an azure web app to an azure mysql database that is hosted on Azure Express (hybrid) ? because I see that the only possibility to do that is to get an Azure SQL database and not MySQL database

Answer 1

Hey @ZOUAOUI Sarra ,

from my perspective it looks like you want your Application, hosted in Azure App Service, to access some on prem resources, in your case a MySQL Server. The connection between your on prem environment and the cloud is already established via Azure Express Route and you also want to leverage the existing express route for your project.

In order to connect an Azure Web App with another (non Azure PaaS Service) you usually need to work with some kind of vNet (virtual Azure Networks) integration. This allows you to "connect" your Azure App Service to a vNet.

In your case I would suggest that you take a look at a feature which is called "Regional VNet Integration".

Using regional VNet Integration enables your app to access:

• Resources in a VNet in the same region as your app.
• Resources in VNets peered to the VNet your app is integrated with.
• Service endpoint secured services.
• Resources across Azure ExpressRoute connections.
• Resources in the VNet you're integrated with.
• Resources across peered connections, which includes Azure ExpressRoute connections.
• Private endpoints

You will find a tutorial on how to set up this integration in the Documentation.

I hope that helps!