top | item 18036721

(no title)

misterbowfinger | 7 years ago

Couldn't really parse out the website for what Clustrix actually is. Is it basically a leader node that distributes writes to key-value stores, and then the reads figure out where the data is by a partitioning scheme, with the benefit of MySQL protocol? Similar to CockroachDB?

discuss

order

mr_pickles|7 years ago

It was a fault-tolerant, fully distributed relational database which was compatible with MySQL's variant of SQL. There were no key-value stores involved.

Tables (and indexes) were automatically partitioned and replicated as needed, completely under the covers.

Queries (reads and writes) were distributed to the nodes where the data resided, in parallel.

Scaling the system was as simple as adding new nodes. Data was automatically rebalanced to take advantage of the new capacity.

Failure recovery was automatic too. If a disk or node failed, the data involved would be reconstructed from replicas and moved elsewhere with no interruption in service and no failed transactions.

It was a pretty impressive system, which predated Google Spanner. But, in the early days, you had to run their custom hardware to get it. There was no cloud version.

misterbowfinger|7 years ago

Thanks! Is there a diagram that shows how it works? I'm still having trouble visualizing it.