Tag: MySQL replication

MySQL Sharding Business Challenges

MySQL sharding comes with challenges. Previously we discussed application and design challenges that MySQL sharding requires. Today we’ll expand on the MySQL sharding business challenges that can result and affect your business flexibility. MySQL applications seeking scale often consider sharding. Sharding is a database architecture strategy in which the data […]

MySQL Replication Options and their Challenges

Previously we discussed replication for MySQL systems.  In this post we will discuss various MySQL replication options. For MySQL, replication is the primary go-to strategy for high availability (HA) and, to some extent, scale. By providing additional copies of the primary database, a MySQL system using replication can withstand the loss […]

Does ClustrixDB use MySQL Replication Between its Nodes?

Here’s a common question we get asked at tradeshows, on customer calls, by analysts, and by our fellow devs and DBAs in the industry. Since this has come up a lot, let’s answer it in detail! TL;DR: ClustrixDB does not use MySQL Replication between nodes ClustrixDB is a true shared-nothing […]

Sharding: In Theory and Practice (Part Three)

Part Three: What’s in a Shard? In the first two posts of this series, I offered a perspective on the origins of database sharding and described the architectural problems with algorithmic sharding that led LiveJournal and TypePad to use dynamic sharding to scale. The next challenge of a sharded architecture […]