IP地址
192.168.200.111
192.168.200.112
192.168.200.113
授权Atlas登录用户
grant all on *.* to admin@'192.168.200.113' identified by '123';
flush privileges;
二、安装atlas
#下载rpm包
wget https://github.com/Qihoo360/Atlas/releases/download/2.2.1/Atlas-2.2.1.el6.x86_64.rpm
#安装
rpm -ivh Atlas-2.2.1.el6.x86_64.rpm
3yb5jEku5h4= #加密后
[mysql-proxy]
admin-username = user
admin-password = pwd
proxy-backend-addresses = 192.168.200.111:3306
proxy-read-only-backend-addresses = 192.168.200.112:3306@1
pwds = admin:3yb5jEku5h4=
daemon = true
keepalive = true
event-threads = 8
log-level = message
log-path = /usr/local/mysql-proxy/log
sql-log = ON
#sql-log-slow = 10
#instance = test
proxy-address = 0.0.0.0:1234
admin-address = 0.0.0.0:2345
#tables = person.mt.id.3
charset = utf8
#client-ips = 127.0.0.1, 192.168.1
#lvs-ips = 192.168.1.1
四、启动Atlas服务
/usr/local/mysql-proxy/bin/mysql-proxyd test start
OK: MySQL-Proxy of test is started #启动成功
#查看端口
netstat -lnupt
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:2345 0.0.0.0:* LISTEN 2156/mysql-proxy
tcp 0 0 0.0.0.0:1234 0.0.0.0:* LISTEN 2156/mysql-proxy
五、登录测试
mysql -uuser -ppwd -h127.0.0.1 -P2345
select * from backends;
+-------------+----------------------+-------+------+
| backend_ndx | address | state | type |
+-------------+----------------------+-------+------+
| 1 | 192.168.200.111:3306 | up | rw |
| 2 | 192.168.200.112:3306 | up | ro |
+-------------+----------------------+-------+------+