Related Documentation Download this Excerpt Group Replication

You have two options to implement a high-availability solution when you install MySQL 5.7.18 or higher (64-bit) using MySQL Installer:

  • Standalone MySQL Server / Classic MySQL Replication (default)

    Select this option to begin the initial configuration of a standalone MySQL server. You can configure multiple servers with classic MySQL Replication manually or use MySQL Shell to configure a production InnoDB cluster.

    Click Next to proceed to the remaining configuration steps. For a description of the configuration options that apply to a standalone MySQL server on Windows, see Section, “Server Configuration with MySQL Installer”.

  • Sandbox InnoDB Cluster Setup (for testing only)

    Select this option to create and configure sandbox InnoDB cluster instances locally for testing. You can configure a sandbox InnoDB cluster to have three, five, seven, or nine MySQL server instances. Use the Reconfigure quick action in the MySQL Installer dashboard to adjust the number of instances in the InnoDB cluster after the configuration has finished.


    Existing instance ports (3310 to 3390), which may have been set for a sandbox InnoDB cluster manually using MySQL Shell, will be deleted by MySQL Installer if you run the sandbox InnoDB cluster test setup.

    As the following figure shows, this step requires that you enter a password for the MySQL root account. The password strength is evaluated when you retype it.

    Figure 5.3 Sandbox InnoDB cluster Test Setup

    Content is described in the surrounding text.

The sandbox InnoDB cluster, named sandboxCluster by default, is available on selected ports. After the configuration executes, click the Summary tab to view the specific ports that apply to your cluster. Sandbox InnoDB cluster configuration entries are stored in the installer_config.xml file.

You can use MySQL Installer to install MySQL Shell, if it is not installed. MySQL Shell enables you to manage the sandbox instances. To connect with the MySQL Shell on port 3310, execute the following command:

mysqlsh root@localhost:3310

MySQL Installer also provides a wizard for configuring MySQL Router to connect to the test InnoDB cluster that was created in this step. For configuration details, see MySQL Router Configuration. To learn more about MySQL Router operations, see Routing for MySQL InnoDB cluster.

User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.