dbproxy mysql_DBProxy 入门到精通系列(二):DBProxy快速入门教程

这里主要用来了解有关DBProxy方面的部署及基本的配置，以及模拟架构

1 DBProxy方面的安装部署

1)基础环境的部署

# yum install -y Percona-Server-devel-55.x86_64 Percona-Server-client-55.x86_64 Percona-Server-shared-55 jemalloc jemalloc-devel libevent \

libevent-devel openssl openssl-devel lua lua-devel bison flex libtool.x86_64 libffi-devel libffi glib2.x86_64 glib2-devel.x86_64 glib2-fam.x86_64 git

2)由于需要使用到mysql_config，故此，需要下载mysql5.7的repos,然后将对应镜像源的5.6开启，5.7禁用，DBProxy只支持5.5 5.6的版本，故此，请勿在5.7上进行

测试

#rpm -ivh https://repo.mysql.com//mysql57-community-release-el7-9.noarch.rpm

#vim /etc/yum.repos.d/mysql-community.repo

[mysql56-community]

name=MySQL 5.6Community Server

baseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/7/$basearch/

enabled=1#这里改成1

gpgcheck=1gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

[mysql57-community]

name=MySQL 5.7Community Server

baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/

enabled=0#这里改成0，禁用

gpgcheck=1gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

3)部署安装DBProxy

#git clone https://github.com/Meituan-Dianping/DBProxy.git

#cd DBProxy/#sh autogen.sh#sh bootstrap.sh#make && make install# ll/usr/local/mysql-proxy/total0drwxr-xr-x 2 root root 162 Mar 27 03:46bin

drwxr-xr-x 4 root