4

[disclaimer] I'm not new to databases but totally novice about replication and cluster ...

As you may know Mysql made available a new functionality : MySql Group Replication.

Is anyone can explain me the fundamental difference between such architecture and a cluster ? any major functionality existing only one of both ? node fault tolerance ? capability to come back to live status ? Every advise is welcome ...

Thanks

4

Group Replication vs Galera (aka PXC)

Group Replication is only months old; Galera has been around for years. Once GR establishes its worth (which I think it will), the answer may be something like this...

They are very similar. Both do an excellent job of HA -- any single node crashing can be recovered from, usually automatically. Both provide a high degree of read scaling. GR promises to provide more write scaling.

Without knowing your requirements, and your tolerance for various things, I cannot advise on which way to go. Perhaps 90% of MySQL/MariaDB/Percona users on this forum do not use any form of Replication. So, the first question is, do you need any Replication solution?

The architectures are different, but the goals are similar. That is, "there is more than one way to skin a cat".

Fault tolerance, in my opinion, is achievable only if you are willing to put nodes in at least 3 separate geographic locations (think flood/tornado/earthquake/etc). Both allow for that. I use the rule of surviving any single-point-of-failure, and include "datacenter" as a point-of-failure.

GR is a significant improvement over Oracle's previous offering, Fabric.

Since you did not mention Sharding, I did not mention it.

MySQL Cluster

The term "MySQL Cluster" is confusing; technically it refers to "NDB Cluster", which is significantly different than "Group Replication" aka "InnoDB Cluster".

NDB is discussed briefly by Ibrahim, but I would not go so far as to say "best solution ever".

NDB was originally a telco application for very reliable handling of telephone switching. MySQL, Oracle, and SeveralNines have enhanced it _to be somewhat closer to a general RDBMS. It retains its high reliability.

I would limit the use of NDB to applications that need the specific features that it provides.

Advice

For someone starting in the database world with MySQL, I would go with a non-replicated InnoDB-based dataset. When replication / HA / scaling are needed, consider Group Replication or Galera. Move to NDB only if it fits your application better.

| improve this answer | |
  • Thanks for your answer. Let's wait and see for a probation period ... – tdaget Jan 29 '17 at 20:37
  • @tdaget - It's been more than 2 years, and GR has not stumbled. (Fabric died.) – Rick James Apr 27 '19 at 14:31
2
  • you have these various options:

    • A single node without replication:
      • one master who handle the read/writes, if the master goes down you are dead.
    • A single node with one or more replication nodes: Mysql Normal Replication

      • one master who handle the writes.
      • one or more replica that can help in READ operations but can't help in WRITE.
      • if the master goes down, you can pick up one of the replica nodes to become the master.
      • downtime will be the time required to start the replica as master.
    • A multi-master with group replication: MYSQL Group Replication

      • more than one master node that can help with the write operation.
      • all the group nodes help with the READ operation.
      • changes are synced to other nodes and handle conflicts automatically.
      • if one of the masters goes down you still alive.
      • you are dead only if all the masters goes down.
    • A cluster:
      • the best solution ever.
      • you have:
        • data nodes
        • Application nodes/MYSQLD
        • management nodes
      • data are synced in synchronous mode.
      • auto-sharding
      • parallel writes without any conflicts.
| improve this answer | |
  • Some references will help you: 1.Group Replication 2. MYSQL Cluster – Ibrahim Albarki Apr 5 '17 at 15:28
  • @RDFozz I tried to do so, but u must have high rank to add more than 2 links in the answer, my rank is low so I added them as a comment.๐Ÿ˜€๐Ÿ˜Š – Ibrahim Albarki Apr 5 '17 at 19:32
  • The link "2 MySQL Cluster" dates back to 2011, and refers to NDB. – Rick James Aug 22 '18 at 19:38
  • @Rick Mysql cluster mentioned in my answer is the mysql NDB Cluster, and yes maybe the link is not recent, but I don't know any explanation so far more efficient than the mentioned slides. – Ibrahim Albarki Aug 23 '18 at 20:07

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.