You are here

Sharding solutions

Once in a year or so we get a request of a customer about MariaDB/MySQL sharding solutions. So here we have a list of sharding solutions we are currently aware of:

What does it need for Schema sharding

  • Metadata database: Where you record which customer schema is located in which shard (with a locking mechanism).
  • Your application connector or a "sharding facility" must do the (re-)direction.
  • A re-sharding mechanism for "load balancing".
  • A good Monitoring per schema and per shard so you know which schema causes more load and which shard is soon overloaded.

See also our blog post: Sharding do-it-yourself.