深圳全飞鸿

标题: MySQL-Router的配置档研究 [打印本页]
作者: zhgc    时间: 2020-6-24 16:29
标题: MySQL-Router的配置档研究
MySQL-Router的配置档研究

位置放在外层：mysqlrouter.ini
要放在bin目录的同级目录中


可行基本版:
  1. [routing:basic_failover]
  2. bind_address=10.0.10.72
  3. bind_port = 7001
  4. mode = read-write
  5. destinations = 127.0.0.1:3306

  7. [keepalive]
  8. interval = 60
复制代码




作者: zhgc    时间: 2020-6-27 17:02


XC Proxy的目录 ：


D:\DBA\mysql-router-8.0.20-winx64\mysqlrouter.ini


  1. [DEFAULT]
  2. logging_folder = D:\DBA\log


  5. [logger]
  6. #level = debug
  7. level = INFO


  10. [routing:basic_failover]
  11. bind_address=10.0.10.23
  12. bind_port = 7000
  13. mode = read-write
  14. destinations = 192.168.1.233:3306


  17. [keepalive]
  18. interval = 60
复制代码


安装成服务时，[code]和[logger]都要有
作者: zhgc    时间: 2021-1-27 23:57
盘点XC的100.18上的Router


同级目录mysqlrouter.ini的内容：
[DEFAULT]
logging_folder = D:\DBA\log  有这个目录

[logger]
level = INFO

[routing:basic_failover]
bind_address=10.0.10.23
bind_port = 7000
mode = read-write
destinations = 192.168.1.233:3306

[keepalive]
interval = 60



作者: zhgc    时间: 2021-1-28 12:23
本帖最后由 zhgc 于 2021-1-28 12:26 编辑

盘点XC的1.234上的Router

E:\DBA\mysql-router-8.0.20-winx64\bin\mysqlrouter -c E:\DBA\mysql-router-8.0.20-winx64\mysqlrouter.ini --service

[DEFAULT]
logging_folder = E:\DBA\log

[logger]
level = INFO

[routing:basic_failover]
bind_address=10.0.10.29
bind_port = 3306
mode = read-write
destinations = 192.168.1.233:3306

[keepalive]
interval = 60



作者: zhgc    时间: 2021-1-28 15:00
命令部分：

  --install-service
        Install Router as Windows service which starts automatically at
        system boot
  --install-service-manual
        Install Router as Windows service which needs to be started
        manually
  --remove-service
        Remove Router from Windows services
  --service
        Start Router as Windows service



安装服务

安装过程两次报错，1次提示要带-c参数 ，1次提示要有E:/DBA/log目录

指令：
E:\mysql-router-8.0.20-winx64\mysql-router-8.0.20-winx64\bin>mysqlrouter -c "E:\
mysql-router-8.0.20-winx64\mysql-router-8.0.20-winx64\mysqlrouter.ini" --install-service
Service successfully installed.




安装成功后，看到“服务”里的内容是：
E:\mysql-router-8.0.20-winx64\mysql-router-8.0.20-winx64\bin\mysqlrouter -c E:\mysql-router-8.0.20-winx64\mysql-router-8.0.20-winx64\mysqlrouter.ini --service

安装删除
E:\mysql-router-8.0.20-winx64\mysql-router-8.0.20-winx64\bin>mysqlrouter --remove-service







欢迎光临 深圳全飞鸿 (http://www.nagomes.com/disc/) Powered by Discuz! X3.2