Advanced MySQL 8

Configuring the router configuration

Let's now connect to our host router and start configuration. Input the following command:

[root@router ~]# mysqlrouter --bootstrap cluster_admin@primaryone:3306 --directory /opt/router

Please enter the MySQL password for the root; after which, you should see the following output:

Bootstrapping MySQL Router instance at '/opt/router'...

The configuration of MySQL Router is now complete, allowing you to connect to the InnoDB cluster. The following connection credentials provide more detail.

The typical MySQL protocol connections to myCluster are as follows:

• Read/write connections: localhost:6446
• Read-only connections: localhost:6447

The X protocol connections to myProductionCluster are as follows:

• Read/write ...