MySQL Router - After client machine rebooting, Cannot connect to MySQL InnoDB Cluster

[佳晃 富田]

Hello,

We are having trouble with MySQL Router on Ubuntu 18.04 LTS.

We installed MySQL Router (Version : 8.0.18-1ubuntu18.04) in client machine(OS: Ubuntu 18.04 LTS),
and we could access to MySQL InnoDB Cluster via Read/Write Connections port 6446.

But after rebooting client machine, we can not connect to Cluster via port 6446.
Router don't listen on this port.

We've done the following:

1. Install MySQL Router on client machine by apt command.

sudo apt install mysql-router

2. Bootstrap Router by following command.

sudo mysqlrouter --bootstrap root@172.18.0.31:3306 --user=mysqlrouter

3. Restart Router

sudo systemctl restart mysqlrouter

4. Confirm listening port.

sudo lsof -i -P -n | grep LISTEN|grep mysqlrouter
main 2354 mysqlrouter 4u IPv4 55249498 0t0 TCP *:6447 (LISTEN)
main 2354 mysqlrouter 5u IPv4 55247092 0t0 TCP *:6446 (LISTEN)
main 2354 mysqlrouter 6u IPv4 55225292 0t0 TCP *:64470 (LISTEN)
main 2354 mysqlrouter 7u IPv4 55244081 0t0 TCP *:64460 (LISTEN)

5. Access to Cluster (Success!).

mysql -uroot -p -h127.0.0.1 -P6447

6. Reboot client machine.

sudo reboot

7. After rebooting, confirm listening port.
But, client doesn't show ports mysqlrouter listens.

sudo lsof -i -P -n | grep LISTEN|grep mysqlrouter

8. Try to access to Cluster,but error occurs.

mysql -uroot -p -h127.0.0.1 -P6447
Enter password: XXXXXX
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)

How can we solve this problem ?
Please give us some advice.