MySQL Router - We would like to remove a bootsrap setting.

[佳晃 富田]

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 佳晃 富田.