If you’ve ever talked to someone who’s done it, the process of sharding MySQL is as awful as its mnemonic cousin sounds.
Yet, plenty of really smart DBAs still go this route. They see it as a necessary evil to scale apps and ensure low latency transactions. The sad fact is we have accepted it. But by accepting it, we have also accepted the baggage it brings. Sharding is never a one-and-done effort. It is a constant battle the system continues to work as it grows.
At Clustrix, we think sharding is like stepping in quicksand. Once you make that step, you are stuck constantly maintaining it. So we built an OLTP database called ClustrixDB that does something much nicer than sharding. We do slicing. And its nicer because you never have to lift a finger. Your apps don’t need to change. And it brings all sorts of goodies including load re-balancing and high availability. Simply put, it’s a smarter way.
If you are trying to decide to shard or not to shard your MySQL database, or if you are just sick of living with sharding, give this webinar a listen. We’ll walk you through how to think about the problem at hand, and how to avoid getting mired in that quicksand down the road by answering these questions:
- Why do DBAs think sharding is the only end-game?
- What are the long-term costs of sharding?
- What is a better alternative to sharding MySQL?
- How real is it? Is it too good to be true?
Click on the other installments below to watch.
About the Presenter
Dave Anselmi is Director of Product Management at Clustrix and brings over 18 years of product management, integration, and project management experience in database technology and e-commerce.
He’s very excited to be at the forefront of pushing the limits of linear scale-out ACID-compliant relational database technology with our clustered database, ClustrixDB.