MySQL Forums
Forum List  »  Router & Proxy

Unable to bootstrap the mysql router
Posted by: Haashir Mohamed
Date: December 14, 2022 01:07AM

Hello,

I have configured the 3 Node Innodb Cluster, which is running fine. And then I tried to install the mysql router (8.0.31) on my App server, its getting the below error. Please let me know what is the issue here.


# MySQL Router configuration file
#
# Documentation is available at
# http://dev.mysql.com/doc/mysql-router/en/

[DEFAULT]
logging_folder = /var/log/mysqlrouter
runtime_folder = /run/mysqlrouter
config_folder = /etc/mysqlrouter

[logger]
level = INFO


[root@eiacwebapp1test mysqlrouter]# cd /etc/mysqlrouter
[root@eiacwebapp1test mysqlrouter]# ls
mysqlrouter.conf
[root@eiacwebapp1test mysqlrouter]# ls -ld /etc/mysqlrouter
drwxr-xr-x 2 root root 30 Dec 14 09:32 /etc/mysqlrouter
[root@eiacwebapp1test mysqlrouter]#
[root@eiacwebapp1test mysqlrouter]# ls -ld /run/mysqlrouter
drwxr-xr-x 2 mysqlrouter mysqlrouter 40 Sep 13 21:57 /run/mysqlrouter
[root@eiacwebapp1test mysqlrouter]#
[root@eiacwebapp1test mysqlrouter]# ls -ld /var/log/mysqlrouter
drwxr-xr-x 2 mysqlrouter mysqlrouter 6 Sep 13 21:57 /var/log/mysqlrouter


[root@eiacwebapp1test mysqlrouter]# mysqlrouter --bootstrap mycluster@172.16.4.42:3306 -d myrouter --user=mysqlrouter
Please enter MySQL password for mycluster:
# Bootstrapping MySQL Router instance at '/etc/mysqlrouter/myrouter'...

Fetching Cluster Members
trying to connect to mysql-server at eiacdb2test:3306
Failed connecting to eiacdb2test:3306: Error connecting to MySQL server at eiacdb2test:3306: Unknown MySQL server host 'eiacdb2test' (-2) (2005), trying next
trying to connect to mysql-server at eiacdb3test:3306
Failed connecting to eiacdb3test:3306: Error connecting to MySQL server at eiacdb3test:3306: Unknown MySQL server host 'eiacdb3test' (-2) (2005), trying next
trying to connect to mysql-server at eiacdb1test:3306
Failed connecting to eiacdb1test:3306: Error connecting to MySQL server at eiacdb1test:3306: Unknown MySQL server host 'eiacdb1test' (-2) (2005), trying next
Error: no more nodes to fail-over too, giving up.
[root@eiacwebapp1test mysqlrouter]#
[root@eiacwebapp1test mysqlrouter]# ls
mysqlrouter.conf
[root@eiacwebapp1test mysqlrouter]# mysqlrouter --bootstrap mycluster@172.16.4.42:3306 -d myrouter --user=root
Please enter MySQL password for mycluster:
# Bootstrapping MySQL Router instance at '/etc/mysqlrouter/myrouter'...

Fetching Cluster Members
trying to connect to mysql-server at eiacdb2test:3306
Failed connecting to eiacdb2test:3306: Error connecting to MySQL server at eiacdb2test:3306: Unknown MySQL server host 'eiacdb2test' (-2) (2005), trying next
trying to connect to mysql-server at eiacdb3test:3306
Failed connecting to eiacdb3test:3306: Error connecting to MySQL server at eiacdb3test:3306: Unknown MySQL server host 'eiacdb3test' (-2) (2005), trying next
trying to connect to mysql-server at eiacdb1test:3306
Failed connecting to eiacdb1test:3306: Error connecting to MySQL server at eiacdb1test:3306: Unknown MySQL server host 'eiacdb1test' (-2) (2005), trying next
Error: no more nodes to fail-over too, giving up.


[root@eiacwebapp1test mysqlrouter]# mysqlrouter --bootstrap root@eiacdb1test --user=mysqlrouter
Please enter MySQL password for root:
Error: Unable to connect to the metadata server: Error connecting to MySQL server at eiacdb1test:0: Unknown MySQL server host 'eiacdb1test' (-2) (2005)
[root@eiacwebapp1test mysqlrouter]#
[root@eiacwebapp1test mysqlrouter]# mysqlrouter --bootstrap mycluster@eiacdb1test --user=mysqlrouter
Please enter MySQL password for mycluster:
Error: Unable to connect to the metadata server: Error connecting to MySQL server at eiacdb1test:0: Unknown MySQL server host 'eiacdb1test' (-2) (2005)

Options: ReplyQuote


Subject
Views
Written By
Posted
Unable to bootstrap the mysql router
49
December 14, 2022 01:07AM


Sorry, only registered users may post in this forum.

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.