Benchmarks

Benchmarking: More Stable Results with CPU Affinity Setting

benchmarking cpu affinity setting

When I run a benchmark and want to measure the CPU efficiency of something, I find it’s often a good choice to run a benchmark program, as well as the database, on the same server. This is in order to eliminate network impact and to look at single-thread performance, to eliminate contention.
Usually, this approach […]

Read more

Need to Connect to a Local MySQL Server? Use Unix Domain Socket!

Unix Socket Domain

When connecting to a local MySQL instance, you have two commonly used methods: use TCP/IP protocol to connect to local address –  “localhost” or 127.0.0.1  – or use Unix Domain Socket.
If you have a choice (if your application supports both methods), use Unix Domain Socket as this is both more secure and more efficient.
How […]

Read more

Evaluating Group Replication Scaling for I/O Bound Workloads

Group Replication Scaling I:O Workload

In this post, I want to evaluate Group Replication Scaling capabilities in cases when we increase the number of nodes and increase user connections. While this setup is identical to that in my post “Evaluating Group Replication Scaling Capabilities in MySQL”,  in this case, I will use an I/O bound workload.
For this test, I […]

Read more

Evaluating Group Replication with Multiple Writers in MySQL

Group Replication Multiple Writers MySQL

In this blog, I want to evaluate Group Replication Scaling capabilities to handle several writers, that is, when the read-write connection is established to multiple nodes, and in this case, two nodes. This setup is identical to my previous post, Evaluating Group Replication Scaling Capabilities in MySQL.
For this test, I deploy multi-node bare metal […]

Read more

Evaluating Group Replication Scaling Capabilities in MySQL

Group Replication Scaling Capabilities in MySQL

In this blog, I want to evaluate Group Replication Scaling capabilities in cases when we increase the number of nodes and increase user connections.
For testing, I will deploy multi-node bare metal servers, where each node and client are dedicated to an individual server and connected between themselves by a 10Gb network.
Also, I will use […]

Read more