关于Atlas 配置及调试

1.软件安装

# rpm -ivh Atlas-2.2.1.el6.x86_64.rpm

2.生成加密密码

# /usr/local/mysql-proxy/bin/encrypt 123456

/iZxz+0GRoA=

3.编辑配置文件

# vim /usr/local/mysql-proxy/conf/test.cnf

[mysql-proxy]

admin-username = admin

admin-password = admin

proxy-backend-addresses = 192.168.1.204:3306

proxy-read-only-backend-addresses = 192.168.1.203:3306

pwds = root:/iZxz+0GRoA=

daemon = true

keepalive = true

event-threads = 8

log-level = message

log-path = /usr/local/mysql-proxy/log

proxy-address = 0.0.0.0:1234

admin-address = 0.0.0.0:2345

4.启动服务

# /usr/local/mysql-proxy/bin/mysql-proxyd test start

# netstat -ntpl | grep mysql-proxy

tcp        0      0 0.0.0.0:1234                0.0.0.0:*                   LISTEN      4389/mysql-proxy   

tcp        0      0 0.0.0.0:2345                0.0.0.0:*                   LISTEN      4389/mysql-proxy

5.测试atlas连接mysql  

成功

注意：图中为管理员账号 可用select * from help；产看可执行sql

还有一个是工作账号工作账号的ip端口为test.cnf所设置的  用户名和密码是用encrypt加密过的那个