prometherion on Mon, 05 Jun 2017 12:26:19
I was benchmarking Azure MySQL with sysbench (OLTP) and the results are not so good due to high response time, as following.
approx. 95 percentile: 52.40ms
I noticed that Azure MySQL cannot connect to a Virtual Network (VLAN): there will be a solution to this problem, maybe the VLAN join?
Hong Wang – MSFT on Mon, 05 Jun 2017 16:29:26
Can you share the test configuration you are using, and the baseline server configuration (I assume you use the Azure VM + MySQL as baseline) you use for?
Azure MySQL don't support VNET today, but it is in the roadmap.
prometherion on Tue, 06 Jun 2017 06:46:41
I run the test twice, first one inside a Mesosphere DC/OS Cluster made of Standard D2 VM scale set, second one from the master (Standard D2) to Azure MySQL. Obviously the scale set instances are bounded within a virtual network created by the ACS template.
The results of a MySQL inside the cluster are following:
approx. 95 percentile: 32.70ms
The test configuration is the default one offered by sysbench (OLTP), except for number of threads (8), row size (1,000,000) and read-only mode: I used this docker image in order to avoid test inconsistency (https://hub.docker.com/r/carsonoid/sysbench/).
Hong Wang – MSFT on Thu, 15 Jun 2017 15:13:42
I am sorry for missing your reply. Although I don't think the VLAN is the key factor of the slower response time. We will double check and back to you ASAP.