Documentation Home
MySQL and Windows
Related Documentation Download this Excerpt

MySQL and Windows  /  ...  /  MySQL Applications, Connectors, and Documentation

1.3.2.4 MySQL Applications, Connectors, and Documentation

MySQL Installer provides you with a suite of tools for developing and managing business-critical applications on Windows. The suite consist of applications, connectors, documentation, and samples.

During the initial setup, choose any predetermined setup type, except Server only, to install the latest GA version of the tools. Use the Custom setup type to install an individual tool or specific version. If MySQL Installer is installed on the host already, use the Add operation to select and install tools from the MySQL Installer dashboard.

MySQL Router Configuration

MySQL Installer provides a configuration wizard that can bootstrap an installed instance of MySQL Router 2.1.3 or later to route traffic between MySQL applications and an InnoDB cluster. When configured, MySQL Router runs as a local Windows service. For detailed information about using MySQL Router with an InnoDB cluster, see Routing for MySQL InnoDB cluster.

To configure MySQL Router, do the following:

  1. Set up InnoDB cluster. For instructions on how to configure an InnoDB cluster sandbox on the local host using MySQL Installer, see Section 1.3.2.1, “InnoDB Cluster Sandbox Test Setup”. InnoDB cluster requires MySQL Server 5.7.17 or higher.

    For general InnoDB cluster information, see InnoDB Cluster.

  2. Using MySQL Installer, download and install the MySQL Router application. After the installation finishes, the configuration wizard prompts you for information. Select the Configure MySQL Router for InnoDB cluster check box to begin the configuration and provide the following configuration values:

    • Hostname: localhost by default.

    • Port: The port number of the primary server in the InnoDB cluster. The default is 3310.

    • Management User: An administrative user with root-level privileges.

    • Password: The password for the management user.

    • Classic MySQL protocol connections to InnoDB cluster

      Read/Write: Set the first base port number to one that is unused (between 80 and 65532) and the wizard will select the remaining ports for you.

      The figure that follows shows an example of the MySQL Router configuration screen.

    Figure 1.5 MySQL Router Configuration

    MySQL Router configuration

  3. Click Next and then Execute to apply the configuration. Click Finish to close MySQL Installer or return to the MySQL Installer dashboard.


User Comments
Sign Up Login You must be logged in to post a comment.