content_image/849194.jpg
The advanced-configuration options include: 

• Server ID 

Set the unique identifier used in a replication topology. If binary logging is enabled, you must specify a server ID. The default ID value depends on the server version. For more information, see the description of the server_id  system variable. 

• Table Names Case 

You can set the following options during the initial and subsequent configuration the server. For the MySQL 8.0 release series, these options apply only to the initial configuration of the server. 

•Lower Case 

Sets the lower_case_table_names  option value to 1 (default), in which table names are stored in lowercase on disk and comparisons are not case-sensitive. 

•Preserve Given Case 

Sets the lower_case_table_names  option value to 2, in which table names are stored as given but compared in lowercase. 

## Apply Server Configuration 

All configuration settings are applied to the MySQL server when you click Execute . Use the Configuration Steps  tab to follow the progress of each action; the icon for each toggles from white to green (with a check mark) on success. Otherwise, the process stops and displays an error message if an individual action times out. Click the Log  tab to view the log. 

When the installation completes successfully and you click Finish , MySQL Installer and the installed MySQL products are added to the Microsoft Windows Start menu under the MySQL  group. Opening MySQL Installer loads the dashboard where installed MySQL products are listed and other MySQL Installer operations are available. 

## MySQL Router Configuration with MySQL Installer 

MySQL Installer downloads and installs a suite of tools for developing and managing business-critical applications on Windows. The suite consists 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 8.0 to direct traffic between MySQL applications and an InnoDB Cluster. When configured, MySQL Router runs as a local Windows service. 

<img src='content_image/849194.jpg'>

## Note 

You are prompted to configure MySQL Router after the initial installation and when you reconfigure an installed router explicitly. In contrast, the upgrade operation does not require or prompt you to configure the upgraded product. 

