Category: CLUSTRIX

Feed: Clustrix Blog. Author: Dave Anselmi. Recently we’ve started to dig into the internals of ClustrixDB, specifically How ClustrixDB Accomplishes Horizontal Scaling of Both Writes & Reads Without Sharding. Next, we dug into the details of the multi-patented ClustrixDB Rebalancer. This time we will discuss the ClustrixDB Query Evaluation Model. ClustrixDB is a MySQL-compatible distributed RDBMS that provides linear scale out of both writes and reads, while maintaining relational semantics, including ACID transactionality and referential integrity. Typically MySQL workloads are only able to scale out both writes and reads if sharding is used. Sharding is the strategy of partitioning your ... Read More

Feed: Clustrix Blog. Author: Dave Anselmi. In this blog we will focus on how ClustrixDB performs query optimization. One of the reasons ClustrixDB exists is because multiple people had asked our founders if RDBMSs can scale out. One of our founders had previously created a scale-out NoSQL database, and he was up for the challenge. Specifically, the ClustrixDB RDBMS had to provide linear scale out of both writes and reads, maintaining relational semantics including ACID transactionality and referential integrity, without sharding and its complications. As described before, ClustrixDB is able to to linearly scale out via a combination of the ... Read More

Feed: Clustrix Blog. Author: Dave Anselmi. ClustrixDB is a MySQL-compatible ACID RDBMS that linearly scales out both writes and reads. Clustrix has created many architectural innovations over the years that have made this possible. This week we will focus on one of these innovations, the ClustrixDB Rebalancer, that automatically distributes and balances data across nodes while ensuring high availability. Before we go into the details, let’s put this into context. With last week’s blog, we started exploring how ClustrixDB accomplishes horizontal scaling of both writes and reads without sharding. Why is this important? Because other MySQL scaling strategies have challenges with ... Read More

Feed: Clustrix Blog. Author: Dave Anselmi. When people come up and ask, “Oh, so ClustrixDB is yet another MySQL-compatible database. What makes you different?” we have a terrific answer, and it’s all about horizontal scaling: ClustrixDB is the only MySQL compatible database that linearly scales-out both write and read queries. By horizontal scaling we mean each additional node added to a ClustrixDB cluster adds both linear write and read horizontal scale. This is significantly different from what MySQL can provide — as a single-node master architecture, MySQL can have multiple read slaves added, potentially providing at best only linear read ... Read More

Feed: Clustrix Blog. Author: Dave Anselmi. Here it comes again: the big Amazon showcase flash sale. You’d have to live under a rock not to notice every site vying to grab attention for the “best list of Prime deals!” It’s all massive exposure, but that cuts both ways: Amazon’s site has to handle all the traffic it’s creating. Ostensibly a “big sale day,” Prime Day is really designed to drive $99 yearly subscription membership fees. No matter how deep the discount, nor how many “free” video, music, audio, books, etc. that are offered, Amazon is willing to spend big money ... Read More

Feed: Clustrix Blog. Author: Dave Anselmi. MySQL Sharding DevOps Challenges: Data Maintenance, Infrastructure, & HA Previously we’ve discussed application and design challenges for MySQL sharding, and some of the corresponding business challenges that can result, affecting your business flexibility. But what about MySQL sharding DevOps challenges? For reference, here’s a quick précis about MySQL sharding: MySQL sharding is the strategy of partitioning your MySQL application workload across multiple different MySQL database servers, allowing queries and data CRUD operations to fan out. This works around MySQL’s single write-master architecture, providing the ability to scale out both writes and reads, albeit with ... Read More

Feed: Clustrix Blog. Author: Dave Anselmi. 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 workload is partitioned across multiple separate MySQL RDBMS servers. This kind of partitioning across separate servers allows MySQL applications to scale out writes as well as reads. And that’s not trivial; write scale isn’t something that read slaves or master-master solutions can provide to ... Read More

Feed: Clustrix Blog. Author: Dave Anselmi. The Challenges of Sharding MySQL MySQL databases are sharded for the best of reasons. At some point the MySQL workload needs to scale, and scaling RDBMSs is hard (Clustrix’s unofficial motto!). Adding read scale to RDBMSs is straightforward via replication. But adding write scale? That’s the real trick, and herein lies some of the challenges of sharding MySQL. After scaling up your MySQL instance to the largest instance available, and adding several read slaves, what’s the next step? Multi-master solutions can add additional write scale, but only for separate applications; each application must write ... Read More

Feed: Clustrix Blog. Author: Dave Anselmi. Sharding MySQL Business Challenges MySQL sharding comes with challenges. Previously we discussed application and design challenges that sharding MySQL requires. Today we’ll expand on the sharding MySQL 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 workload is partitioned across multiple separate MySQL RDBMS servers. This kind of partitioning across separate servers allows MySQL applications to scale out writes as well as reads. And that’s not trivial; write scale isn’t something that read slaves or master-master ... Read More

Feed: Clustrix Blog. Author: Dave Anselmi. 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 of the master database by promoting the slave to be the new master, and updating the application endpoints. In addition, replication can provide scale by providing additional read-only copies of the database for the application to leverage. This offloads application read requests from the ... Read More