MySQL Router Install (Linux)

If your server has SELinux enabled, you have two choices. Disable SELinux (not recommended, but might be right for a test system), or configure SELinux to allow our configuration...

Note: if your process is running as root, then the root login is generally mapped to the unconfined_u user in SELinux, which means the following config may not be necessary. But we will assume that MySQL will run as the mysqlrouter user (as that is the default outcome for the process described below)

Configure SELinux

(Recommended)

semanage port -a -t mysqld_port_t -p tcp 6446

semanage port -a -t mysqld_port_t -p tcp 6447

semanage port -a -t mysqld_port_t -p tcp 6448

semanage port -a -t mysqld_port_t -p tcp 6449

semanage port -a -t mysqld_port_t -p tcp 6450

semanage port -a -t mysqld_port_t -p tcp 8444

semanage port -a -t mysqld_port_t -p tcp 64460

semanage port -a -t mysqld_port_t -p tcp 64470

64460 & 64470 are for Oracle MySQL EE

semanage port -l | grep mysql

6446 RW Connections
6447 RO Connections
6448 X RW Connections
6449 X RO Connections
6450 RW Split Connections
8444 Router API
64460 X RW Connections (EE)
64470 X RO Connections (EE)

Disable SELinux

(Not recommended)

Assumes SELinux is currently set to 'enforcing'...

setenforce 0

getenforce

sed -i 's/SELINUX=enforcing/SELINUX=permissive/' /etc/selinux/config

Install

RPM

Using the RPM distribution keeps the installation standard. Recommended for ease of use on MySQL client machines (e.g. application servers) where YUM is not available.

RPM OEL78.0.26 - V1010808-01.zip

edelivery.oracle.com

dev.mysql.com/downloads

YUM/DNF

OEL/RHEL/CentOS

MySQL YUM Repositories

Oracle Enterprise MySQL

Assumes commercial yum repository is available

yum install mysql-router-commercial.x86_64

yum

Last metadata expiration check: 1:17:38 ago on Tue 15 Oct 2024 03:51:26 PM BST.Dependencies resolved.============================================================================================================================================================ Package Architecture Version Repository Size============================================================================================================================================================Installing: mysql-router-commercial x86_64 8.0.40-1.1.el8 mysql-80-Local 4.4 M
Transaction Summary============================================================================================================================================================Install 1 Package
Total download size: 4.4 MInstalled size: 18 MIs this ok [y/N]: yDownloading Packages:mysql-router-commercial-8.0.40-1.1.el8.x86_64.rpm 19 MB/s | 4.4 MB 00:00------------------------------------------------------------------------------------------------------------------------------------------------------------Total 19 MB/s | 4.4 MB 00:00Running transaction checkTransaction check succeeded.Running transaction testTransaction test succeeded.Running transaction Preparing : 1/1 Running scriptlet: mysql-router-commercial-8.0.40-1.1.el8.x86_64 1/1 Installing : mysql-router-commercial-8.0.40-1.1.el8.x86_64 1/1 Running scriptlet: mysql-router-commercial-8.0.40-1.1.el8.x86_64 1/1 Verifying : mysql-router-commercial-8.0.40-1.1.el8.x86_64 1/1
Installed: mysql-router-commercial-8.0.40-1.1.el8.x86_64
Complete!

Percona MySQL Router

dnf install percona-mysql-router --enablerepo=Percona-84-Local

dnf

Last metadata expiration check: 2:21:16 ago on Tue 08 Sep 2026 14:54:50 BST.Dependencies resolved.========================================================================================================= Package Architecture Version Repository Size=========================================================================================================Installing: percona-mysql-router x86 64 B.4.8-8.1.e19 @Percona-84-Local 20 M

Transaction Summary=========================================================================================================Install 1 Package
Total download size: 4.6 MInstalled size: 20 MIs this ok [y/N]: y
Downloading Packages:percona-mysq1-router-8. 4.8-8.1.e19.x86 64.rpm 39 MB/s | 4.6 MB 00:00---------------------------------------------------------------------------------------------------------------------------------------------------------------------Total 38 MB/s | 4.6 MB 00:00Running transaction checkTransaction check succeeded.Running transaction testTransaction test succeeded.Running transaction Preparing : 1/1 Running scriptlet: percona-mysql-router-8.4.8-8.1.e19.x86_64 1/1 Installing : percona-mysql-router-8.4.8-8.1.e19.x86_64 1/1 Running scriptlet: percona-mysql-router-8.4.8-8.1.e19.x86_64 1/1 Verifying : percona-mysql-router-8.4.8-8.1.e19.x86_64 1/1
Installed: percona-mysq1-router-8.4.8-8.1.e19.x86_64
Complete!

IMPORTANT: If you see errors, check the troubleshooting section near the end of this page.

Configure Router

mysqlrouter --bootstrap icadmin@node1:3306 --https-port 8444 --user mysqlrouter

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)

NOTE: --https-port is relevant since MySQL 8.0.22

Please enter MySQL password for icadmin:# Bootstrapping system MySQL Router 8.4.8 (Percona Server (GPL), Release 8, Revision 1c288264) 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- Adjusting permissions of generated files- Creating configuration /etc/mysqlrouter/mysqlrouter.conf
Existing configuration backed up to '/etc/mysqlrouter/mysqlrouter.conf.bak'
# MySQL Router configured for the InnoDB Cluster 'myic001'
After this MySQL Router has been started with the generated configuration
$ /etc/init.d/mysqlrouter restartor $ systemctl start mysqlrouteror $ mysqlrouter -c /etc/mysqlrouter/mysqlrouter.conf
InnoDB Cluster 'myic001' can be reached by connecting to:
## MySQL Classic protocol
- Read/Write Connections: localhost:6446- Read/Only Connections: localhost:6447- Read/Write Split Connections: localhost:6450
## MySQL X protocol
- Read/Write Connections: localhost:6448- Read/Only Connections: localhost:6449

For the RPM/YUM install the auto generated mysqlrouter.conf looks like this..

# Copyright (c) 2020, 2024, Oracle and/or its affiliates.##################### The lines above are intentionally left blank
[Unit]Description=MySQL RouterAfter=network-online.targetWants=network-online.targetAfter=syslog.target

[Service]Type=notifyUser=mysqlrouterGroup=mysqlrouter
# Start main serviceExecStart=/usr/bin/mysqlrouter
# Sets open_files_limitLimitNOFILE = 10000
Restart=on-failure
PrivateTmp=true
[Install]WantedBy=multi-user.target

Start Router

systemctl start mysqlrouter

systemctl status mysqlrouter

Enable Router

Required if you want the MySQL Router to auto start on system boot (recommended)

systemctl enable mysqlrouter

systemctl status mysqlrouter

Check Router

mysqlrouter --version

Use mysqlsh on the primary database server...

mysqlsh

\js

\c icadmin@node1

var cluster = dba.getCluster()

cluster.listRouters()

If you are prompted to upgrade the metadata, do this...

dba.upgradeMetadata()

cluster.setupRouterAccount('icadmin',{'update':1})

{ "clusterName": "myic001", "routers": { "myappserv1.local::system": { "hostname": "myappserv1.local", "lastCheckIn": "2026-09-08 20:10:31", "roPort": "6447", "roXPort": "6449", "rwPort": "6446", "rwSplitPort": "6450", "rwXPort": "6448", "version": "8.4.8" } "myappserv2.local::system": { "hostname": "myappserv2.local", "lastCheckIn": "2026-09-08 20:10:31", "roPort": "6447", "roXPort": "6449", "rwPort": "6446", "rwSplitPort": "6450", "rwXPort": "6448", "version": "8.4.8" } }}

Set API Password

Optional

If you want to use the MySQL Router API, you should create a user and password...

mysqlrouter_passwd set /etc/mysqlrouter/mysqlrouter.pwd apiuser

You can check which users have been created using...

mysqlrouter_passwd list /etc/mysqlrouter/mysqlrouter.pwd

Troubleshooting

Last metadata expiration check: 2:21:16 ago on Tue 08 Sep 2026 14:54:50 BST.Dependencies resolved.========================================================================================================= Package Architecture Version Repository Size=========================================================================================================Installing: percona-mysql-router x86 64 B.4.8-8.1.e19 @Percona-84-Local 20 M

Transaction Summary=========================================================================================================Install 1 Package
Total download size: 4.6 MInstalled size: 20 MIs this ok [y/N]: y
Downloading Packages:percona-mysq1-router-8. 4.8-8.1.e19.x86 64.rpm 39 MB/s | 4.6 MB 00:00---------------------------------------------------------------------------------------------------------------------------------------------------------------------Total 38 MB/s | 4.6 MB 00:00Running transaction checkTransaction check succeeded.Running transaction testTransaction test succeeded.Running transaction  Preparing : 1/1  Running scriptlet: percona-mysql-router-8.4.8-8.1.e19.x86_64 1/1  Installing : percona-mysql-router-8.4.8-8.1.e19.x86_64 1/1  Running scriptlet: percona-mysql-router-8.4.8-8.1.e19.x86_64 1/1Failed to start jobs: Failed to enqueue some jobs, see logs for details: No such file or directory
  Verifying : percona-mysql-router-8.4.8-8.1.e19.x86_64 1/1
Installed:  percona-mysq1-router-8.4.8-8.1.e19.x86_64
Complete!

Output from:

dnf history 99

dnf

Transaction ID : 99Begin time : Tue 08 Sep 2026 14:54:54 BSTBegin rpmdb : f928f7a2c271a169d62315d29aec88d1c162068ad85352484aa28433232fdlf9End time : Tue 08 Sep 2026 14:54:57 BST (3 seconds)End rpmdb : 4c7aae8b95aaa2deeb632935065cfc3cae5bd6f7bd3703fc5d3bbca5f5ebb904User : Mike <admin_mike>Return-Code : SuccessReleasever : 9Command Line : install percona-mysql-router -- enablerepo=Percona-84-LocalPersistence : PersistComment :Packages Altered: Install percona-mysql-router-8.4.8-8.1.e19.x86_64 @Percona-84-LocalScriptlet output: 1 Failed to start jobs: Failed to enqueue some jobs, see logs for details: No such file or directory

Remove Router

dnf remove percona-mysql-router

dnf

Dependencies resolved.========================================================================================================= Package Architecture Version Repository Size=========================================================================================================Removing: percona-mysql-router x86 64 B.4.8-8.1.e19 @Percona-84-Local 20 M

Transaction Summary=========================================================================================================Remove 1 Package
Freed space: 20 MIs this ok [y/N]: yRunning transaction checkTransaction check succeeded.Running transaction testTransaction test succeeded.Running transaction Preparing : 1/1 Running scriptlet: percona-mysql-router-8.4.8-8.1.e19.x86_64 1/1 Erasing : percona-mysql-router-8.4.8-8.1.e19.x86_64 1/1 Running scriptlet: percona-mysql-router-8.4.8-8.1.e19.x86_64 1/1 Verifying : percona-mysql-router-8.4.8-8.1.e19.x86_64 1/1
Removed: percona-mysql-router-8.4.8-8.1.e19.x86_64
Complete!

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)