MySQL Router Install (Windows)
Firewall
Firewall
TODO
8.0 Recommended Install
8.0 Recommended Install
Use the "MySQL Installer for Windows". Do NOT use the MySQL Router specific MSI file
NOTE: If your target server does not have internet access, do not use the "web" MSI Installer
Bootstrapping is completed automatically.
The "MySQL Router" Windows Service should have been automatically been configured and have a status of "Running".
## MySQL Classic protocol
- Read/Write Connections: localhost:6446- Read/Only Connections: localhost:6447
## MySQL X protocol
- Read/Write Connections: localhost:6448- Read/Only Connections: localhost:6449
- Read/Write Connections: localhost:6446- Read/Only Connections: localhost:6447
## MySQL X protocol
- Read/Write Connections: localhost:6448- Read/Only Connections: localhost:6449
8.0 Alternate Install
Note that I haven't yet been able to get MySQL Router running properly as a service using this method. Oracle support directed me to use the recommended method above instead.8.0 Alternate Install
MSI Installer8.0.25 - V1009210.01.zip8.0.27 - V1018010-01.zip
Configure Router
Run as administrator from a command promptConfigure Router
mysqlrouter --bootstrap icadmin@node1:3306
The bootstrap process is a specific way of running MySQL Router, which does not start the usual routing and instead configures the mysqlrouter.conf file based on the metadata. (2)On Windows, if mysqlrouter is not in your path, the full path will be something like: C:\"Program Files"\MySQL\"MySQL Router 8.0"\bin\mysqlrouterC:\"Program Files"\MySQL\"MySQL Router 8.0"\bin\mysqlrouter --bootstrap icadmin@node1
In the example above we also omit the port. The default is 3306.# Bootstrapping system MySQL Router 8.0.40 (MySQL Community - GPL) instance...
- Creating account(s) (only those that are needed, if any)- Verifying account (using it to run SQL queries that would be run by Router)- Storing account in keyring- Creating configuration C:/Program Files/MySQL/MySQL Router 8.0/mysqlrouter.conf
# MySQL Router configured for the InnoDB Cluster 'ukoci_myic002'
After this MySQL Router has been started with the generated configuration
> net start mysqlrouteror > C:\Program Files\MySQL\MySQL Router 8.0\bin\mysqlrouter -c C:/Program Files/MySQL/MySQL Router 8.0/mysqlrouter.conf
InnoDB Cluster 'ukoci_myic002' can be reached by connecting to:
## MySQL Classic protocol
- Read/Write Connections: localhost:6446- Read/Only Connections: localhost:6447
## MySQL X protocol
- Read/Write Connections: localhost:6448- Read/Only Connections: localhost:6449
- Creating account(s) (only those that are needed, if any)- Verifying account (using it to run SQL queries that would be run by Router)- Storing account in keyring- Creating configuration C:/Program Files/MySQL/MySQL Router 8.0/mysqlrouter.conf
# MySQL Router configured for the InnoDB Cluster 'ukoci_myic002'
After this MySQL Router has been started with the generated configuration
> net start mysqlrouteror > C:\Program Files\MySQL\MySQL Router 8.0\bin\mysqlrouter -c C:/Program Files/MySQL/MySQL Router 8.0/mysqlrouter.conf
InnoDB Cluster 'ukoci_myic002' can be reached by connecting to:
## MySQL Classic protocol
- Read/Write Connections: localhost:6446- Read/Only Connections: localhost:6447
## MySQL X protocol
- Read/Write Connections: localhost:6448- Read/Only Connections: localhost:6449
Configure Windows Service
Configure Windows Service
From a command prompt (run as Adminsitrator)
C:\"Program Files"\MySQL\"MySQL Router 8.0"\bin\mysqlrouter -c C:/"Program Files"/MySQL/"MySQL Router 8.0"/mysqlrouter.conf --install-serviceIf you need to undo this use...
C:\"Program Files"\MySQL\"MySQL Router 8.0"\bin\mysqlrouter -c C:/"Program Files"/MySQL/"MySQL Router 8.0"/mysqlrouter.conf --remove-serviceBibliography & References
Bibliography & References
https://dev.mysql.com/downloads/router/https://dev.mysql.com/doc/mysql-router/8.0/en/mysql-router-deploying-sandbox.htmlhttps://docs.oracle.com/cd/E17952_01/mysql-shell-8.0-en/admin-api-using-router.htmlhttps://dev.mysql.com/doc/mysql-router/8.0/en/mysql-router-conf-options.html#option_mysqlrouter_user_defaulthttps://dev.mysql.com/doc/mysql-router/8.0/en/mysql-router-server-starting.htmlhttps://dev.mysql.com/doc/mysql-shell/8.0/en/admin-api-bootstrapping-router.htmlhttps://docs.oracle.com/cd/E17952_01/mysql-router-8.0-en/mysqlrouter.htmlhttps://dev.mysql.com/doc/mysql-router/9.1/en/mysqlrouter.html#option_mysqlrouter_config(1) https://dev.mysql.com/doc/mysql-router/8.0/en/mysql-router-faq.html(2) https://docs.oracle.com/cd/E17952_01/mysql-shell-8.0-en/admin-api-bootstrapping-router.html
https://support.oracle.comHow to Make MySQL Router Automatically Restart on Systemd (Doc ID 2684939.1)MySQL Router Deployment Recommendations (Doc ID 2277385.1)MySQL Router User when Bootstrapping (Doc ID 2449015.1)Primary Note For MySQL Router (Doc ID 2265731.1)How To Create a Local Yum Repository for MySQL Enterprise Packages (Doc ID 1947384.1)
https://support.oracle.comHow to Make MySQL Router Automatically Restart on Systemd (Doc ID 2684939.1)MySQL Router Deployment Recommendations (Doc ID 2277385.1)MySQL Router User when Bootstrapping (Doc ID 2449015.1)Primary Note For MySQL Router (Doc ID 2265731.1)How To Create a Local Yum Repository for MySQL Enterprise Packages (Doc ID 1947384.1)