MySQL Forums
Forum List  »  Router & Proxy

MySQL Router - After client machine rebooting, Cannot connect to MySQL InnoDB Cluster
Posted by: 佳晃 富田
Date: November 28, 2019 08:53PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Router - After client machine rebooting, Cannot connect to MySQL InnoDB Cluster
3467
November 28, 2019 08:53PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.