千家信息网

ProxySQL 2.0.X安装

发表于:2025-01-23 作者:千家信息网编辑
千家信息网最后更新 2025年01月23日,1. 设置proxysql 2.0.x的yum repocat <
千家信息网最后更新 2025年01月23日ProxySQL 2.0.X安装

1. 设置proxysql 2.0.x的yum repo

cat <

[proxysql_repo]

name= ProxySQL YUM repository

baseurl=http://repo.proxysql.com/ProxySQL/proxysql-2.0.x/centos/\$releasever

gpgcheck=1

gpgkey=http://repo.proxysql.com/ProxySQL/repo_pub_key

EOF


2. 安装proxysql

yum install -y proxysql

指定安装版本:yum install proxysql-version


Installed:

proxysql.x86_64 0:2.0.5-1


Dependency Installed:

perl.x86_64 4:5.16.3-294.el7_6

perl-Carp.noarch 0:1.26-244.el7

perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7

perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7

perl-DBD-MySQL.x86_64 0:4.023-6.el7

perl-DBI.x86_64 0:1.627-4.el7

perl-Data-Dumper.x86_64 0:2.145-3.el7

perl-Encode.x86_64 0:2.51-7.el7

perl-Exporter.noarch 0:5.68-3.el7

perl-File-Path.noarch 0:2.09-2.el7

perl-File-Temp.noarch 0:0.23.01-3.el7

perl-Filter.x86_64 0:1.49-3.el7

perl-Getopt-Long.noarch 0:2.40-3.el7

perl-HTTP-Tiny.noarch 0:0.033-3.el7

perl-IO-Compress.noarch 0:2.061-2.el7

perl-Net-Daemon.noarch 0:0.48-5.el7

perl-PathTools.x86_64 0:3.40-5.el7

perl-PlRPC.noarch 0:0.2020-14.el7

perl-Pod-Escapes.noarch 1:1.04-294.el7_6

perl-Pod-Perldoc.noarch 0:3.20-4.el7

perl-Pod-Simple.noarch 1:3.28-4.el7

perl-Pod-Usage.noarch 0:1.63-3.el7

perl-Scalar-List-Utils.x86_64 0:1.27-248.el7

perl-Socket.x86_64 0:2.010-4.el7

perl-Storable.x86_64 0:2.45-3.el7

perl-Text-ParseWords.noarch 0:3.29-4.el7

perl-Time-HiRes.x86_64 4:1.9725-3.el7

perl-Time-Local.noarch 0:1.2300-2.el7

perl-constant.noarch 0:1.27-2.el7

perl-libs.x86_64 4:5.16.3-294.el7_6

perl-macros.x86_64 4:5.16.3-294.el7_6

perl-parent.noarch 1:0.225-244.el7

perl-podlators.noarch 0:2.5.1-3.el7

perl-threads.x86_64 0:1.87-4.el7

perl-threads-shared.x86_64 0:1.43-6.el7


3. 安装MySQL客户端

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.27-el7-x86_64.tar.gz

tar -zxvf mysql-5.7.27-el7-x86_64.tar.gz

mv mysql-5.7.27-el7-x86_64 /usr/local/mysql


vi /etc/profile

在最后添加:

PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH


执行:source /etc/profile



4. 启动proxysql服务

service proxysql start


5. 登录proxysql管理端

mysql -uadmin -padmin -h227.0.0.1 -P6032








0