Tag: MySQL sharding

MySQL Sharding DevOps Challenges

MySQL Sharding DevOps Challenges: Data Maintenance, Infrastructure, & HA Previously we’ve discussed application and design challenges for MySQL sharding, and some of the corresponding business challenges that can result, affecting your business flexibility. But what about MySQL sharding DevOps challenges? For reference, here’s a quick précis about MySQL sharding: MySQL […]

MySQL Sharding Business Challenges

MySQL sharding comes with challenges. Previously we discussed application and design challenges that MySQL sharding requires. Today we’ll expand on the MySQL sharding business challenges that can result and affect your business flexibility. MySQL applications seeking scale often consider sharding. Sharding is a database architecture strategy in which the data […]

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

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

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