mysql router读写_Mysql Router 读写分离配置

1.安装

rpm -ivh mysql-router-2.0.4-1.el6.x86_64.rpm

2.配置

cat >/etc/mysqlrouter/mysqlrouter.ini <

[DEFAULT]

logging_folder = /var/log/mysqlrouter/

plugin_folder = /usr/lib64/mysqlrouter

runtime_folder = /var/run/mysqlrouter

config_folder = /etc/mysqlrouter

hostname=192.168.1.201

[logger]

level = info

# If no plugin is configured which starts a service, keepalive

# will make sure MySQL Router will not immediately exit. It is

# safe to remove once Router is configured.

#[keepalive]

#interval = 60

[routing:read_write]

#将router绑定到哪个NIC

bind_address = {hostname}:7001

#将路由的后端db列表，rw模式将采用first available模式轮训

#ro模式采用round-robin模式轮训

destinations = {hostname}:3306

mode = read-write

# default 512,like mysql's max_connections

max_connections = 1024

#default 100,like mysql's ax_connect_errors

max_connect_errors = 100

#default 9,like mysql's connect_timeout

client_connect_timeout = 9

[routing:read_only]

bind_address = {hostname}:7002

destinations = {hostname}:3306,{hostname}:3307,{hostname}:3308

mode = read-only

max_connections = 65535

max_connect_errors = 100

client_connect_timeout = 9

EOF

3.启动

service mysqlrouter start

4.测试

[root@localhost ~]# netstat -ntpl|grep mysqlrouter

tcp        0      0 192.168.1.201:7001          0.0.0.0:*                   LISTEN      20498/mysqlrouter

tcp        0      0 192.168.1.201:7002          0.0.0.0:*                   LISTEN      20498/mysqlrouter

5.连接

mysql -uroot -p123456 -P7002 -h192.168.1.201