Documentation Home
MySQL and Windows
Related Documentation Download this Excerpt

MySQL and Windows  /  ...  /  InnoDB Cluster Sandbox Test Setup InnoDB Cluster Sandbox Test Setup

You have two options to implement a high-availability solution when you install MySQL Server 5.7.17 or higher 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 1.0.9 or higher to configure a production InnoDB cluster.

    For a description of the server configuration options that apply to a standalone MySQL server on Windows, see Section, “Server Configuration”.

  • InnoDB Cluster Sandbox Test Setup (for testing only)

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

    Figure 1.3 InnoDB Cluster Sandbox Test Setup

    MySQL Installer options for an InnoDB cluster sandbox test setup.

The InnoDB cluster sandbox, 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.

You can use MySQL Installer to install MySQL Shell 1.0.9, 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:

shell> 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
Sign Up Login You must be logged in to post a comment.