基于Atlas实现mysql读写分离
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 |
+-------------+----------------------+-------+------+
最新文章
- 【网站国际化必备】Asp.Net MVC 集成Paypal(贝宝)快速结账 支付接口 ,附源码demo
- 在nginx下去掉ci框架url中的index.php
- [转]BeginInvoke和EndInvoke方法浅析
- java中进程与线程的三种实现方式
- SubLime2 乱码解决
- js 增加 onclick 事件
- 【knockoutjs】 Computed VS Pure Computed 区别
- Java练习1
- 【20190304】JavaScript-知识点总结:Set,异或
- experiment 3
- Python:Day06 元组、字典、字符串
- [CocoaPods]pod安装与pod更新
- 未能写入输出文件“c:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files\root\106f9ae8\cc0e1169\App_global.asax.haz99mum.dll”--“拒绝访问。 ”
- hadoop hive组件介绍及常用cli命令
- POJ2488&;&;3083&;&;3009&;&;1321&;&;2251&;&;2049
- 软件测试为何我会首选Python
- 视图Ext.Viewport和窗口Ext.Window用法
- html页面转换成pdf
- 群晖MyDS账号注册--实现使用QuickConnect外网访问
- 20145335郝昊《java程序设计》第5周学习总结
热门文章
- C++STL(二)——vector容器
- 数据库学习 day2 检索数据
- 多转一ETH(ERC20代币汇集)
- Windows恢复分区管控命令reagentc
- DataAnalysis-SOP
- String 对象-->;大小比较
- python3(四)list tuple
- 数据库里账号的密码,需要怎样安全的存放?—— 密码哈希(Password Hash)
- std::string构造函数
- 解决从服务器获取的数组是 __NSCFConstantString以及";";没有空格字符串的问题