Router Installation procedure (Version 8)

Pre-install checks

Firewalls and ports

Install

yum install percona-mysql-router.x86_64

Bootstrap router

[root@ip-172-31-18-222 ~]# mysqlrouter --bootstrap idbclusr@18.216.203.216:3306 --directory prdrouter


- 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 /root/prdrouter/mysqlrouter.conf

 MySQL Router configured for the InnoDB Cluster 'prd_cluster'

Start Router

You can start router after bootstrapping using one of below methods

Method 1: 
mysqlrouter -c /root/prdrouter/mysqlrouter.conf
Method 2:
Go to the router directory you specified when you bootstrapped 
cd /root/prdrouter/
sh start.sh

[root@ip-172-31-18-222 prdrouter]# PID 25237 written to '/root/prdrouter/mysqlrouter.pid'
logging facility initialized, switching logging to loggers specified in configuration

Validation

Below is one important config file that you may need to configure according to your requirements

/root/prdrouter/mysqlrouter.conf is one important file

You can validate router process using below command

[root@ip-172-31-18-222 prdrouter]# netstat -tlnp | grep mysql
tcp        0      0 0.0.0.0:64460           0.0.0.0:*               LISTEN      25237/mysqlrouter
tcp        0      0 0.0.0.0:6446            0.0.0.0:*               LISTEN      25237/mysqlrouter
tcp        0      0 0.0.0.0:6447            0.0.0.0:*               LISTEN      25237/mysqlrouter
tcp        0      0 0.0.0.0:64470           0.0.0.0:*               LISTEN      25237/mysqlrouter
tcp6       0      0 :::33060                :::*                    LISTEN      26236/mysqld
tcp6       0      0 :::33061                :::*                    LISTEN      26236/mysqld
tcp6       0      0 :::3306                 :::*                    LISTEN      26236/mysqld