Tag: relational database sharding

tech talk series part 4 wrap up featured image

Tech Talk Series, Part 4 Wrap Up: Achieving High Availability in MySQL

  Last week we presented the final Tech Talk in our Scaling MySQL series titled “How Do You Achieve High Availability in a MySQL Environment?” When discussing high availability, the following questions usually come up first: Do you need it? Why? Great questions. If your system is a transactional one, […]

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

Why Sharding is the Wrong Way to Scale Your Database

In order for your e-commerce platform to live up to its fullest potential, you need a database that will scale. It’s as simple as that. As technology has advanced and e-commerce retailers have more information at their disposal than ever before, traditional MySQL databases have reached their limits. They lack […]

Sharding: In Theory and Practice (Part Five)

  Part Five: The Data Warehouse Welcome to the final installment of this series on database sharding. Following the steps in part two (The Differences Between Algorithmic and Dynamic Sharding) and part three (What’s in a Shard?) of this series, you can achieve a scalable and fault-tolerant architecture, but one […]

Sharding: In Theory and Practice (Part Four)

Part Four: Using Memcached Welcome back to our blog series on database sharding. As I mentioned in part one of this series, memcached was invented at LiveJournal, and its purpose is to reduce the number of redundant reads hitting their databases. LiveJournal observed that 80% of the traffic accesses only […]