mysql-router 中间件的安装与配置

下载

wget https://dev.mysql.com/get/Downloads/MySQL-Router/mysql-router-2.0.4-linux-glibc2.12-x86-64bit.tar.gz

 

1、解压安装程序文件

[root@mysqlrouter mytmp]#  tar -xzvf mysql-router-2.0.4-linux-glibc2.12-x86-64bit.tar.gz

 

2、重命名安装文件夹

[root@mysqlrouter mytmp]#  mv mysql-router-2.0.4-linux-glibc2.12-x86-64bit /usr/local/mysqlrouter

 

3、创建日志和配置相关文件存放目录

[root@mysqlrouter mytmp]# cd /usr/local/mysqlrouter

[root@mysqlrouter mysqlrouter]# mkdir logs

[root@mysqlrouter mysqlrouter]# mkdir etc

 

4、创建配置文件 (利用模板文件创建)

[root@mysqlrouter mysqlrouter]#cp share/doc/mysqlrouter/sample_mysqlrouter.ini ./etc/mysqlrouter.conf

 

配置项内容如下：

[DEFAULT]

logging_folder = /usr/local/mysqlrouter/logs

plugin_folder = /usr/local/mysqlrouter/lib/mysqlrouter

config_folder = /usr/local/mysqlrouter/etc

runtime_folder = /usr/local/mysqlrouter/run

 

[logger]

level = INFO

 

[routing:read_write]

bind_address = 192.168.1.47

bind_port = 7001

mode = read-write

destinations = 192.168.1.41:3306

max_connections = 65535

max_connect_errors = 100

client_connect_timeout = 9

 

[routing:read_only]

bind_address = 192.168.1.47

bind_port = 7002

mode = read-only

destinations = 192.168.1.42:3306,192.168.1.43:3306

max_connections = 65535

max_connect_errors = 100

client_connect_timeout = 9

 

[keepalive]

interval = 60

 

注：参数说明

bind_address  指定mysql router绑定的服务器

bind_port         指定绑定的端口

destinations     指定后端mysql server列表 (ip:port 格式，使用逗号分隔)

mode               读写模式(read-write, read_only)

 

5、启动 mysql router  

[root@mysqlrouter mysqlrouter]# cd bin

[root@mysqlrouter bin]# ./mysqlrouter  -c  /etc/mysqlrouter.conf  &