InnoDB ReplicaSet was introduced from MySQL 8.0.19. It works based on the MySQL asynchronous replication. Generally, InnoDB ReplicaSet does not provide high availability on its own like InnoDB Cluster, because with InnoDB ReplicaSet we need to perform the manual failover. AdminAPI includes the support for the InnoDB ReplicaSet. We can operate the InnoDB ReplicaSet using the MySQL shell.
- InnoDB cluster is the combination of MySQL shell and Group replication and MySQL router
- InnoDB ReplicaSet is the combination of MySQL shell and MySQL traditional async replication and MySQL router
Why InnoDB ReplicaSet?
- You can manually perform the switchover and failover with InnoDB ReplicaSet
- You can easily add the new node to your replication environment. InnoDB ReplicaSet helps with data provisioning (using MySQL clone plugin) and setting up the replication.
In this …[Read more]