My Oracle Support Banner

How To Deploy MySQL InnoDB Cluster With Multiple Writable Instances (Multi Primary Group Replication Mode) Using MySQL Shell (Doc ID 2337732.1)

Last updated on NOVEMBER 28, 2022

Applies to:

MySQL Server - Version 5.7 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.

MySQL Shell (mysqlsh) can make multi primary mode as giving a "{multiPrimary:true, force:true}" argument when create a cluster. However this method is not explained well in manual.

Let's see how to make a multi primary mode via mysqlsh.

Note: this document is not for when a Group Replication needs to be adopted.

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
 If you already use single-primary mode
 If you did not set it to single primary mode or have fresh servers
References


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