My Oracle Support Banner

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

Last updated on JANUARY 07, 2021

Applies to:

MySQL Server - Version 8.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


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