Just wondering if there was any updated benchmarking of mysql ssl performance. The post: SSL Performance Overhead in MySQL is fantastic but could use testing with modern cryptography, I would think the performance hit would be like 10%, if any.
Hi @jasons - thank you for posting, and welcome to the Percona Forums!
I don’t have a link to share but I can comment anecdotally - I have an ongoing engagement with a Percona Customer regarding profiling of the TLS overhead with ProxySQL 2, and our regressions showed a 9%-13% performance hit (vs non-TLS) depending on the cipher selected.
Our next optimization was to look at whether we can buy our way to better performance, so since this Customer is already on AWS, we looked at the new ARM-based Graviton2 instance types, but they weren’t keen to recompile for this arch, as Percona isn’t at this time offering builds for ARM.
We’re still in the testing phase, but the z1d instance type (high frequency Xeon) is looking to offer a significant speedup over the traditional r5d that they use for the database.
Next up to benchmark are the C5a AMD compute-optimized instance types. I don’t think these will have the same impact as the z1d but we’ll see…
When the engagement concludes in April I’m planning to write up a blog post. Thanks for raising this question!
Thank you very much for the response, I haven’t considered ProxySQL at all, but will look into it… The write-up sounds interesting! I look forward to it.