小编给大家分享一下Mysql中如何搭建oneproxy,相信大部分人都还不怎么了解,因此分享这篇文章给大家参考一下,希望大家阅读完这篇文章后大有收获,下面让我们一起去了解一下吧!
1 下载
官网:http://www.onexsoft.cn/software/step_into_oneproxy.pdf
2 安装
机器有限,oneproxy就安装在192.168.1.6上
192.168.1.6–主—oneproxy
192.168.1.56—从
3 简单读写分离
-
插入数据:[chenliang@hostnfsd oneproxy]$ mysql -utestuser -ptestuser -h292.168.1.6 –port=3308 -e "insert into test2(id) values(4)" testbak;
Warning: Using a password on the command line interface can be insecure.
[chenliang@hostnfsd oneproxy]$ mysql -utestuser -ptestuser -h292.168.1.6 –port=3308 -e "select * from test2" testbak;
Warning: Using a password on the command line interface can be insecure.
+——+——+
| id | name |
+——+——+
| 1 | NULL |
| 2 | NULL |
| 3 | 4 |
+——+——+ -
成功插入主库
读负载均衡测试:
-
[chenliang@hostnfsd oneproxy]$ mysql -utestuser -ptestuser -h292.168.1.6 –port=3308 -e "select * from test2" group1;
Warning: Using a password on the command line interface can be insecure.
+——+——+
| id | name |
+——+——+
| 1 | NULL |
| 2 | NULL |
| 3 | 4 |
+——+——+
[chenliang@hostnfsd oneproxy]$ mysql -utestuser -ptestuser -h292.168.1.6 –port=3308 -e "select * from test2" group1;
Warning: Using a password on the command line interface can be insecure.
+——+
| id |
+——+
| 1 |
| 2 |
+——+
[chenliang@hostnfsd oneproxy]$ mysql -utestuser -ptestuser -h292.168.1.6 –port=3308 -e "select * from test2" group1;
Warning: Using a password on the command line interface can be insecure.
+——+——+
| id | name |
+——+——+
| 1 | NULL |
| 2 | NULL |
| 3 | 4 |
+——+——+
[chenliang@hostnfsd oneproxy]$ mysql -utestuser -ptestuser -h292.168.1.6 –port=3308 -e "select * from test2" group1;
Warning: Using a password on the command line interface can be insecure.
+——+
| id |
+——+
| 1 |
| 2 |
+——+ -
读负载均衡,均衡分发至每个库
多用户:
-
[root@hostnfsd :/usr/local/oneproxy]$ vi demo.sh
#/bin/bash
#
export ONEPROXY_HOME=/usr/local/oneproxy# valgrind –leak-check=full /
${ONEPROXY_HOME}/bin/oneproxy –keepalive /
–proxy-address=192.168.1.6:3308 /
–admin-address=192.168.1.6:4041 /
–proxy-master-addresses=192.168.1.6:3307@group1 /
–proxy-slave-addresses=192.168.1.56:3307@group1 /
–proxy-user-list=testuser/950434F7872CB57A600E1B2B7237766FA7E95460@testbak /
–proxy-user-list=jonn/950434F7872CB57A600E1B2B7237766FA7E95460@testbak2 / —就这不同,用户指定默认数据库不一样罢了
–proxy-group-policy=group1:Read-balance /
–proxy-charset=utf8_chinese_ci /
–log-file=${ONEPROXY_HOME}/oneproxy.log /
–pid-file=${ONEPROXY_HOME}/oneproxy.pid
测试:
[root@hostnfsd :/root]$ mysql -ujonn -ptestuser -h292.168.1.6 –port=3308 -e "select * from test2" group1 —读写分离
Warning: Using a password on the command line interface can be insecure.
+——+
| id |
+——+
| 106 |
+——+
[root@hostnfsd :/root]$ mysql -ujonn -ptestuser -h292.168.1.6 –port=3308 -e "select * from test2" group1
Warning: Using a password on the command line interface can be insecure.
+——+
| id |
+——+
| 56 |
+——+
[root@hostnfsd :/root]$ mysql -ujonn -ptestuser -h292.168.1.6 –port=3308 -e "select * from test2" group1
Warning: Using a password on the command line interface can be insecure.
+——+
| id |
+——+
| 106 |
+——+
[root@hostnfsd :/root]$ mysql -ujonn -ptestuser -h292.168.1.6 –port=3308 -e "insert into test2 values(111)" group1 —插入主库
Warning: Using a password on the command line interface can be insecure.
[root@hostnfsd :/root]$ mysql -ujonn -ptestuser -h292.168.1.6 –port=3308 -e "select * from test2" group1
Warning: Using a password on the command line interface can be insecure.
+——+
| id |
+——+
| 56 |
+——+
[root@hostnfsd :/root]$ mysql -ujonn -ptestuser -h292.168.1.6 –port=3308 -e "select * from test2" group1
Warning: Using a password on the command line interface can be insecure.
+——+
| id |
+——+
| 106 |
| 111 |
+——+
[root@hostnfsd :/root]$ mysql -ujonn -ptestuser -h292.168.1.6 –port=3308 -e "select * from test2" group1
Warning: Using a password on the command line interface can be insecure.
+——+
| id |
+——+
| 56 |
+——+
[root@hostnfsd :/root]$ mysql -ujonn -ptestuser -h292.168.1.6 –port=3308 -e "select * from test2" group1
Warning: Using a password on the command line interface can be insecure.
+——+
| id |
+——+
| 106 |
| 111 |
以上是“Mysql中如何搭建oneproxy”这篇文章的所有内容,感谢各位的阅读!相信大家都有了一定的了解,希望分享的内容对大家有所帮助,如果还想学习更多知识,欢迎关注亿速云行业资讯频道!
原创文章,作者:carmelaweatherly,如若转载,请注明出处:https://blog.ytso.com/201845.html