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 […]
Challenges with Google’s Cloud Spanner
At this point everyone has heard of Google’s Cloud Spanner. It’s Google’s first database offering that can scale-out write transactions linearly, as well as provide cross-node transactions with ACID guarantees, claiming to solve significant problems that Amazon’s Aurora cannot. But as discussed before, Spanner is able to accomplish that scale […]
Tech Talk Series: Part 2 Wrap Up
This week I presented a Tech Talk on sharding, its complications and complexity. There are many pros and (even more) cons to sharding, which can be summarized with these two questions: Why do some DBAs think sharding is the only end game? Sharding is the only well known way to […]
Why is ACID Cool Again?
Before you get any ideas, we’re talking about good old-fashioned database ACID compliance. ACID is not a new concept to developers. Certainly every DBA knows it, but collectively, the software industry lost its addiction to ACID some time ago. This is because the industry found a new thing to crave: […]
Google Spanner vs Amazon Aurora: Who’ll Get the Enterprise?
Google Spanner versus Amazon Aurora In July 2015, Amazon delivered Aurora, the AWS-only Enterprise RDBMS they’d been claiming since November 2014 would have “5x Enterprise performance at 1/5 the price.” Amazon was making a big play in the MySQL market—they’d recognized that there is a lot of demand for scaling […]