For what reason should I use a real multi-primary setup?
To be clear, not a multi-writer solution where any node can become the active writer in case of needs, as for Percona XtraDB Cluster (PXC) or Percona Server for MySQL using Group_replication. No, we are talking about a multi-primary setup where I can write at the same time on multiple nodes. I want to insist on this "why?".
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.