Mysql中如何分离mysql-proxy读写
作为配置文件启动
[root@host-192-168-1-56 mysql-proxy]# ls
p>
bin include lib libexec 许可证 mysql-proxy.conf mysql-proxy.log mysql-proxy.pid 共享
[root@host-192-168-1-56 mysql-proxy ]#更多 mysql-proxy.conf
[mysql-proxy]
daemon=true
pid-file=/usr/local/mysql-proxy/mysql-proxy .pid
log-file=/usr/local/mysql-proxy/mysql-proxy.log
log-level=debug
LUA_PATH=/usr/ local/mysql-proxy/share/doc/mysql-proxy
proxy-lua-script=/usr/local/mysql-proxy/share/doc/mysql-proxy/rw-splitting.lua
代理-address=127.0.0.1:4040
proxy-read-only-backend-addresses=192.168.1.56:3307,192.168.1.6.3307
proxy-backend-addresses=192.168.1.6:3307
保持活动=真
proxy-skip-profiling=true
admin-address=:4042
admin-lua-script=/usr/local/mysql-proxy/share/doc /mysql-proxy/admin-sql .lua
admin-username=admin
admin-password=admin
plugins=proxy,admin
[ root@host-192-168- 1-56 mysql-proxy]# /usr/local/mysql-proxy/bin/mysql-proxy --defaults-file=/usr/local/mysql-proxy/mysql-proxy.conf
以上内容是Mysql中如何分离mysql-proxy的读写。你学到了知识或技能了吗?如果您想学习更多技能或者丰富自己的知识库,请关注行业资讯频道。
2. 本站积分货币获取途径以及用途的解读,想在本站混的好,请务必认真阅读!
3. 本站强烈打击盗版/破解等有损他人权益和违法作为,请各位会员支持正版!
4. 编程技术 > Mysql中如何分离mysql-proxy读写