Lesson Learned #123: Testing PrivateLink connection time using Azure Database for MySQL and PHP

This post has been republished via RSS; it originally appeared at: Azure Database Support Blog articles.

Some time ago, I wrote an article about how to improve the connection speed in Azure Database using the best practices. 


We received in the latest days many questions about the privatelink and following, I would like to share with you the results of this connection speed test.


After my test the connection time for every connection was very similar when we have the following configuration:


  • All test have been done in NorthEurope.
  • I installed PHP version - php-7.3.13-Win32-VC15-x64
  • I created a virtual machine and installed a MySQL server v.8.0.18, with a model that allows me to select Accelerated networking.
    • Computer Size: Standard D4s v3 (4 vcpus, 16 GiB memory) and accelerated networking enabled
  • I created an Azure Database for MySQL:
    • MySQL Version: 5.6, Memory Optimized, 8 vCore(s), 1018 GB
    • SSL Enforce status: DISABLED
    • Initial configuration without any parameter modification.


The most important thing using privatelink feature is that the connection will not go through Internet/Azure Backbone, it will use the VNET connection. 


For example, once I've created a privatelink the client computer will obtain an internal IP of this VNET/Subnet not the public one. Please, pay attention if your client computer is not in this VNET/Subnet the IP that you are going to have will be the normal one even if you specified the privatelink FQDN, for example, servername.privatelink.mysql.database.azure.com.





REMEMBER: these articles are REPUBLISHED. Your best bet to get a reply is to follow the link at the top of the post to the ORIGINAL post! BUT you're more than welcome to start discussions here:

This site uses Akismet to reduce spam. Learn how your comment data is processed.