My Oracle Support Banner

How To Create InnoDB Cluster from existing Group Replication and Setup MySQL Router (Doc ID 2259776.1)

Last updated on JANUARY 06, 2025

Applies to:

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

Goal

Learn how to add existed Group Replication into InnoDB Cluster

Used following servers to make an example.

SERVER HOST SERVER IP Usage
testvm1 192.168.74.201 Group Replication
testvm2 192.168.74.202 Group Replication
testvm3 192.168.74.203 Group Replication
TestMachineAnything 192.168.74.220 MySQL SHELL
TestMachineAnything 192.168.74.220 MySQL ROUTER
beta 192.168.74.102 Application

 

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
 1. Check server which one can be writable server or active writer (Primary)
 2. Create User for MySQL SHELL
 3. INSTALL the MySQL SHELL
 4. Connect to writable server via MySQL SHELL then create cluster
 5. Installing MySQL ROUTER
 6. Deploying MySQL ROUTER with '--bootstrap' option
 7. Connection Test using a MySQL ROUTER
References


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