My Oracle Support Banner

Creating an InnoDB Replica Set from Scratch (Doc ID 2709867.1)

Last updated on DECEMBER 30, 2023

Applies to:

MySQL Database Service - Version N/A and later
MySQL Server - Version 8.0 and later
Information in this document applies to any platform.

Goal

Disclaimer: Starting from v8.0, some terms have been deprecated. Older releases will only use the deprecated terminology, and new releases will only use new terminology. Please see https://dev.mysql.com/doc/mysqld-version-reference/en/ for a complete list of those changes, and in which minor versions it happened. 

Creating an InnoDB Replica Set from scratch, that is, with base installation of two nodes (source and replica).

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
 Requirements
 Create Replica Set
 Configure the instance to be suitable as part of a Replica Set.
 Add NodeB instance to the Replica Set
 
 Confirm the status of the Replica Set
 Adding More Replicas

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