Thursday, July 06, 2017

MySQL Sharding Business Challenges

DZone Database Zone
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 workload is partitioned across multiple separate MySQL RDBMS servers. This kind of partitioning across separate servers allows MySQL applications to scale out writes as well as reads. And that’s not trivial; write scale isn’t something that read slaves or master-master solutions can provide to MySQL applications seeking scale. Read on for details about the MySQL sharding business challenges.

No comments:

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...