Altas安装

cd /usr/local/mysql-proxy/conf
mv test.cnf test.cnf.bak
vim  test.cnf
[mysql-proxy]
admin-username = user
admin-password = pwd
proxy-backend-addresses = 10.0.0.55:3306
proxy-read-only-backend-addresses = 10.0.0.51:3306,10.0.0.53:3306
pwds = repl:3yb5jEku5h4=,mha:O2jBXONX098= #登录后台数据库的账号和密码，自带加密命令
daemon = true #守护进程
keepalive = true #检测后端节点
event-threads = 8 #8s无响应判断为故障
log-level = message #日志级别
log-path = /usr/local/mysql-proxy/log
sql-log=ON #保存web服务器发出的sql语句
proxy-address = 0.0.0.0:33060
admin-address = 0.0.0.0:2345
charset=utf8

启动atlas
/usr/local/mysql-proxy/bin/mysql-proxyd test start
ps -ef |grep proxy

测试读操作
select @@server_id;
测试写操作
begin;select @@server_id; commit;

登录管理程序
mysql -uuser -ppwd -h 10.0.0.53 -P 2345
查看帮助
select * from help;
查看后端节点
SELECT * FROM backends;
上线或下线节点
SET OFFLINE 3;
SET ONLINE  3;
添加和删除节点
db03 [(none)]>add slave 10.0.0.54:3306;
db03 [(none)]>REMOVE BACKEND 4;

添加用户先在后端服务器上添加
ADD PWD root:123;
删除用户
remove pwd mha ;
查看用户
select * from pwds;
永久保存配置
save config;