本文共 1514 字,大约阅读时间需要 5 分钟。
wget https://dev.mysql.com/get/Downloads/MySQL-Router/mysql-router-2.0.4-linux-glibc2.12-x86-64bit.tar.gz
[root@mysqlrouter mytmp]# tar -xzvf mysql-router-2.0.4-linux-glibc2.12-x86-64bit.tar.gz
[root@mysqlrouter mytmp]# mv mysql-router-2.0.4-linux-glibc2.12-x86-64bit /usr/local/mysqlrouter
[root@mysqlrouter mytmp]# cd /usr/local/mysqlrouter
[root@mysqlrouter mysqlrouter]# mkdir logs
[root@mysqlrouter mysqlrouter]# mkdir etc
[root@mysqlrouter mysqlrouter]#cp share/doc/mysqlrouter/sample_mysqlrouter.ini ./etc/mysqlrouter.conf
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
bind_address = 192.168.1.47
destinations = 192.168.1.41:3306
client_connect_timeout = 9
bind_address = 192.168.1.47
destinations = 192.168.1.42:3306,192.168.1.43:3306
client_connect_timeout = 9
bind_address 指定mysql router绑定的服务器
destinations 指定后端mysql server列表 (ip:port 格式,使用逗号分隔)
mode 读写模式(read-write, read_only)
[root@mysqlrouter mysqlrouter]# cd bin
[root@mysqlrouter bin]# ./mysqlrouter -c /etc/mysqlrouter.conf &
转载地址:http://murkf.baihongyu.com/