实验主机
Master: 192.168.0.17
Slave: 192.168.0.20
Proxysql:192.168.0.30
建议关闭防火墙
建立Master: 192.168.0.17与Slave: 192.168.0.20的MySQL主从复制架构
Proxysql:192.168.0.30主机上基于yum安装proxysql
[root@centos6 ~ 20:21:05]#cat <
> [proxysql_repo]
> name= ProxySQL YUM repository
> baseurl=http://repo.proxysql.com/ProxySQL/proxysql-1.4.x/centos/\$releasever
> gpgcheck=1
> gpgkey=http://repo.proxysql.com/ProxySQL/repo_pub_key
> EOF
查看yum源配置是否成功
成功了可以开始安装proxysql
yum install proxysql
用mysql工具进入proxy管理页面
[root@centos6 ~ 20:08:36]#mysql -uadmin -padmin -P6032 -h127.0.0.1
查看proxy的表