Recently I am looking for an application level Sharding solution for MySql, and come across Mysql Fabric, but after some investigation, I find it was already announced to be end of life. It seems Mysql Fabric is not suggested to use any more. If so, my questions are,

  1. Is Mysql Fabric ever a mature tool for production usage?
  2. Are there any successful examples of using Mysql Fabric for sharding?
  3. Is there any specific reason Mysql Fabric is no longer maintained since 2017?
  4. What could be alternatives?
  • You might want to take a look at Vitess - an impressive pedigree and user base and part of the CNCF. – Vérace Apr 20 '19 at 16:44
  • Thanks @Vérace! Seems promising and I will have a look. – Wayne Wang Apr 21 '19 at 14:49

In my opinion, Fabric was doomed because it had a single-point-of-failure, namely the 'fabric node'. Otherwise, it was probably considered mature.

The replacement: Group Replication (InnoDB Cluster). This has a robust design that seems to have no major holes. Galera Cluster (built into MariaDB and PXC, add-on for Oracle's MySQL) competes head-to-head with it and is more mature; there are advocates on both sides.

Group Replication (and Galera) have valid solutions for HA (High Availability) in that they use multiple servers and can recover from any single server failure. (This, of course, requires geographical disbursement of the servers.)

Group Replication is becoming mature and has only one flaw (arguably minor): It has no built-in way to handle the "critical read" problem. (This is where a user writes something to the database, but the subsequent SELECT does not see it because it is sent to a different server.)

I am not prepared to address "sharding" in GR. Clustrix is a 3rd party that claims to have a very good sharding solution. What do you expect from "application level Sharding"? And is Sharding, not HA, your main goal?

Perhaps you saw this? Mysql Group replication vs Mysql Cluster

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.