MySQL-Router的配置档研究

zhgc

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
   
6. 
   
7. [keepalive]
   
8. interval = 60
   

复制代码

zhgc

XC Proxy的目录 ：


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

1. [DEFAULT]
   
2. logging_folder = D:\DBA\log
   
3. 
   
4. 
   
5. [logger]
   
6. #level = debug
   
7. level = INFO
   
8. 
   
9. 
   
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
    
15. 
    
16. 
    
17. [keepalive]
    
18. interval = 60
    

复制代码

安装成服务时，[code]和[logger]都要有

zhgc

盘点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

盘点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

命令部分：

  --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