Welcome to the Microsoft Q&A Platform. Thank you for reaching out & I hope you are doing well.
You were interested in the recommended way to connect to your MySQL Server in a VNet.
- You confirmed you are using : Private Network Access for Azure Database for MySQL - Flexible Server
- You were also wondering if Azure Bastion Native Client can be used to achieve this
I was able to find the documentation for connecting privately to a Server in VNET.
I also reached out internally wrt SQLProxy and HAProxy and below is the response from them,
"Like ProxySQL or HAProxy, Heimdall etx, Proxies sit between the mysql client and mysql server, they don't eliminate the need of mysql client,certain mysql clients also have connection pooling features such as JDBC, HikariPool, JBoss, etc,proxies can be installed on the same linux vm hosting application and running mysql client or on a seperate VM in between app and mysql server
Proxies are optional but recommended for workloads that can generate random spikes of connections and/or the customer wants to direct reads and writes to different servers using proxy in between than making the multiple connection strings in application"
Refer: [https://techcommunity.microsoft.com/t5/azure-database-for-mysql-blog/connecting-efficiently-to-azure-database-for-mysql-with-proxysql/ba-p/1279842](https://techcommunity.microsoft.com/t5/azure-database-for-mysql-blog/connecting-efficiently-to-azure-database-for-mysql-with-proxysql/ba-p/1279842)
Wrt, Azure Bastion Native Client
- Azure Bastion Native connection can only provide RDP and SSH connectivity to VMs in Azure
- It cannot be used for accessing Azure Database for MySQL though it is in a VNET (as this is a PaaS service integrated into VNET and not a VM on it's own)
Thanks,
Kapil
Please don’t forget to close the thread by clicking "Accept the answer" wherever the information provided helps you, as this can be beneficial to other community members.