关于Atlas 配置及调试

来源：互联网发布：网络通信是做什么的编辑：程序博客网时间：2024/06/18 06:18

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加密过的那个

0 0