Tag: database sharding

Tech Talk Series, Part 2: Sharding Complications & Complexities

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 […]

Google Spanner: The Good and the Better

Google’s Impressive New Tech: Cloud Spanner Google just announced their Beta Cloud Spanner, a “horizontally scalable, globally consistent, relational database service.” This impressive hosted technology addresses a long-standing market request: “How can we make our SQL databases scale both writes and reads past a single server?” This is the very […]

Sharding Adds Significant Application Costs

Percona recently published a blog discussing MySQL sharding models for SaaS applications. The blog did a great job highlighting the effort it takes to shard MySQL (e.g. gain write-scale for MySQL SaaS deployments), and discussed understanding both customer data requirements, as well as revenue expectations when designing sharding topologies. But […]

Cyber Monday Tests Limits of Old-School Databases

In the Bill Murray film Groundhog Day, we see a man trapped in the nightmare of the same scenario repeating endless times. At first he fights against it, then he decides to go along with it, and finally despair kicks in. Only until he approaches the problem in an entirely […]

Everything You Need to Know About Scaling MySQL Part 8: Wrapping Up

We have come to the end of the line for our “Everything You Need to Know About Scaling MySQL” series and we hope you have come away with some valuable insight into how to optimize your e-commerce website. For those who may have missed an installment or two—or simply need […]