Add Missing Instance To InnoDB Cluster Using Mysqlsh With -- CLONE Option (Doc ID 2742351.1)

Last updated on MARCH 16, 2023

Applies to:

Goal

Want to ensure the following method will not interrupt availability:

---------
JS > cluster.addInstance('replication@grppospd1:24801');
NOTE: A GTID set check of the MySQL instance at 'grppospd1.oracle.com:24801' determined that it is missing transactions that were purged from all cluster members.

Please select a recovery method [C]lone/[A]bort (default Abort):
----------

Would like to use the clone method.

Node 1 is missing, it is the one I am trying to add.
Node 2 is the current RW primary node.
Node 3 is the node I want to clone from.

Version MySQL 8.0.21
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.