question

ZOUAOUISarra-8635 avatar image
0 Votes"
ZOUAOUISarra-8635 asked ·

Connecting web app to mysql database

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

azure-webappsazure-database-mysqlazure-expressroute
· 2
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Can you elaborate further? When you say Azure Express (hybrid), are you referring to Express Route with a hybrid connection to an on-prem database?

0 Votes 0 · ·

Yes exactly. the goal here is to host the database on a local server (in my country)

0 Votes 0 · ·

1 Answer

abeckdev avatar image
0 Votes"
abeckdev answered ·

Hey @ZOUAOUISarra-8635,

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!







· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.