Categories

MySQL Architecture – Sharding – How to approach sharding?

In the previous blog post we have started to look at the sharding in MySQL. We have discussed why someone may want to pursue sharding and when it’s a good time for that. In this blog post we will talk about different approaches to sharding. What are the different methods in which you can shard … Continued

Read more...

MySQL Architecture – Sharding – Why shard MySQL database?

With this blog post we would like to start a small series that will focus on sharding in MySQL. If you wonder, should you shard your data? At which point it is a necessity? What are the approaches to sharding the data? How to build the sharded environment? How to design it to minimize the … Continued

Read more...

MySQL Architecture – What to use? MySQL replication or Galera Cluster?

In the past we have written blogs discussing MySQL asynchronous replication and providing basic insights into Galera Cluster. MySQL replication is a well-known, battle-tested solution but also Galera Cluster is a mature, well-tested product. We are quite frequently asked: which one should I choose? Would Galera Cluster work better for me than MySQL replication? This … Continued

Read more...