Categories

Galera Cluster – Understanding the network latency impact

As we have discussed in one of our previous blog posts, Galera is sensitive to network latency. This discussion also comes up quite often in our MySQL consulting engagements. We have thought that it might be interesting to take a look at this in more detail and show you what kind of impact it has. … Continued

Read more...

Vitess – Merging the shards

In the last blog we have split one shard into several smaller ones, to accommodate a significant increase of load on one of the accounts. In this blog we are going to pretend that this condition no longer exists and we want to bring the cluster back to its original shape. If you would like … Continued

Read more...

Vitess – Sharding the shard

In the last blog we ended up with three shards for our newsbtest keyspace. This is great but let’s assume that we quickly have noticed that our problem has not disappeared. One of the shards is generating the majority of the load and it impacts the whole application. How can we deal with such issue? … Continued

Read more...

Galera Cluster – what is it?

MySQL comes in different shapes and sizes. Asynchronous replication, semisynchronous replication, NDB Cluster, Galera Cluster, InnoDB Cluster. We are not even mentioning MariaDB as a separate entity. One of the common questions we hear when delivering MySQL consulting is: what should I use? What are the differences between X and Y? This blog post is … Continued

Read more...

Vitess – Shard the keyspace

Let’s say that we are running out of the write capacity in my primary database. In more simple words, our application executes such a number of writes per second that the database is not able to deal with them. It can be the replication (even multithreaded) that becomes the bottleneck, it can be just a … Continued

Read more...