Measuring Percona Server for MySQL On-Disk Decryption Overhead

Percona Server for MySQL 8.0 comes with enterprise-grade total data encryption features. However, there is always the question of how much overhead — or performance penalty — comes with the data decryption. As we saw in my networking performance post, SSL under high concurrency might be problematic. Is this the case for data decryption?

To measure any overhead, I will start with a simplified read-only workload where data gets decrypted during read IO.

How Network Bandwidth Affects MySQL Performance

Network is a major part of a database infrastructure. However, often, performance benchmarks are done on a local machine where a client and a server are collocated — I am guilty of this myself. This is done to simplify the setup and to exclude one more variable (the networking part), but with this, we also miss looking at how network affects performance.

The network is even more important for clustering products like Percona XtraDB Cluster and MySQL Group Replication. Also, we are working on our Percona XtraDB Cluster Operator for Kubernetes and OpenShift, where network performance is critical for overall performance.