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)