MySQL Forums
Forum List  »  Router & Proxy

MySQL Router - We would like to remove a bootsrap setting.
Posted by: 佳晃 富田
Date: December 04, 2019 02:32AM

Hello,

We are using MySQL Router (Version : 8.0.18-1ubuntu18.04) in client machine(IP: 172.18.0.31).
We are trying to access to MySQL InnoDB Cluster (Version : 8.0.18) via this Router.

Web did 2 bootstrap commands in client machine, as follows:

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

② sudo mysqlrouter --bootstrap root@172.18.0.31:3306 --directory /etc/mysqlrouter --user=mysqlrouter

And then, we accessed to the Cluster as below:

shell > mysql -uroot -p -h127.0.0.1 -P6446 mysql_innodb_cluster_metadata
mysql> select * from routers;
+-----------+-------------+---------+------------+
| router_id | router_name | host_id | attributes |
+-----------+-------------+---------+------------+
| 2 | system | 9 | NULL | → Record 1
| 30 | | 9 | NULL | → Record 2
+-----------+-------------+---------+------------+
2 rows in set (0.00 sec)

In this routers table, Record 1 was inserted by ① command,and Record 2 was inserted by ② command.

We need not the bootstrap setting by ① command.
Please give us some advice how to remove this setting.
May we just delete Record 1 ?

> in client machine(IP: 172.18.0.31).

Sorry,this is not client machine's IP, it's Cluster server's.
※ December 05, 2019, modified.



Edited 2 time(s). Last edit at 12/04/2019 07:17PM by 佳晃 富田.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Router - We would like to remove a bootsrap setting.
1805
December 04, 2019 02:32AM


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.