Percona alternative solutions to MySQL 8.0 InnoDB ClusterSet

MySQL & MariaDB
,
1

I would like to ask about alternative solutions to MySQL InnoDB ClusterSet.

  1. For Group Replication + Asynchronous Replication topology, could elaborate on how this architecture is composed?

  2. Regarding the MySQL Innodb ClusterSet installation of the database and MySQL Router, which version should we choose? Should we use Percona Distribution for MySQL, or recommend a different option?

  3. Can Group Replication + Asynchronous Replication be considered fully equivalent to MySQL InnoDB ClusterSet? If not, what are the key differences we should be aware of?

2

@y840530

  1. For Group Replication + Asynchronous Replication topology, could elaborate on how this architecture is composed?

GR (Group Replication) is a highly resilient, fault-tolerant system that handles data consistency and automatic primary failover. It’s based on a distributed consensus, which ensures virtually synchronous replication and guarantees consistency among the nodes.

A minimum of 3 nodes should be available to maintain a quorum and support failover. Let me share some references where you can further check about the detailed information and setup details.

You can add any asynchronous node as usual by taking mysqldump/xtrabackup or the MySQL clone options.

Regarding the MySQL Innodb ClusterSet installation of the database and MySQL Router, which version should we choose? Should we use Percona Distribution for MySQL, or recommend a different option?

You can use both upstream(Oracle MySQL) OR Percona Distribution for MySQL latest version. The Group Replication (InnoDB ClusterSet) equally supports both. Please remember Percona (MySQL) is a drop-in replacement of upstream (Oracle MySQL) with some extra capabilities and features, so there should be no such functionality issue.

  1. Can Group Replication + Asynchronous Replication be considered fully equivalent to MySQL InnoDB ClusterSet? If not, what are the key differences we should be aware of?

Basically, Innodb Cluster/ClusterSet is a wrapper with an extra layer/tools (MySQL Shell, API/Commands, Group Replication, etc.) to directly set up, configure, and manage clusters. Behind the scenes, Innodb cluster used Group Replication. Innodb ClusterSet, on the other hand, provides a resilient DR/recovery cluster that is connected via one of the DCs (Innodb Cluster) via asynchronous replication.

In short GR vs Innodb Cluster, both are the same. With IC, it would just be a bit easier to manage the task using MySQL Shell (JS/Python functions) or api’s etc.

Let me add a few blog posts about IC setup and usage.

Well, other than GR/Innodb Cluster, you can also consider checking PXC(Galera) :- Percona XtraDB Cluster, which also provides multi-node write capability and synchronous write features.