Hi.
We have a onPrem mySQL database that is on a non-public (private endpoint). We would like to replicate the data in this DB to Azure.
I have tried using a Azure database for mySQL but this did not work presumably because of the following perquisite.
from : https://docs.microsoft.com/en-us/azure/mysql/concepts-data-in-replication#limitations-and-considerations
Ensure the the source server has a public IP address, the DNS is publicly accessible, or has a fully qualified domain name (FQDN).
Any suggestion on how i can go about doing this. i have an ExpressRoute setup between the onPrem and Azure Resource group.
Is this possible to do with Azure database for MySQL ? does this require any additional network config? will single server work or do i need to try flexible server.
As a last option i can consider installing mySQL on a Azure VM that is on a private network but this is not the preferred route. hence the question.
Any suggestions would be very much appreciated