安装文档(如果不能访问, 跳过)

• 文档(国内镜像): https://proxysql.com/documentation/installing-proxysql/
• 文档(原站): https://proxysql.com/documentation/installing-proxysql/

安装包安装

• 安装包下载地址: https://github.com/sysown/proxysql/releases

  wget https://github.com/sysown/proxysql/releases/download/v2.0.14/proxysql_2.0.14-ubuntu16_amd64.deb
  dpkg -i proxysql_2.0.14-ubuntu16_amd64.deb
  

  安装命令安装

  • Red Hat / CentOS

    cat <<EOF | tee /etc/yum.repos.d/proxysql.repo
    [proxysql_repo]
    name= ProxySQL YUM repository
    baseurl=https://repo.proxysql.com/ProxySQL/proxysql-2.0.x/centos/\$releasever
    gpgcheck=1
    gpgkey=https://repo.proxysql.com/ProxySQL/repo_pub_key
    EOF
    

• Ubuntu / Debian
  ```
  apt-get install -y lsb-release
  wget -O - 'https://repo.proxysql.com/ProxySQL/repo_pub_key' | apt-key add -
  echo deb https://repo.proxysql.com/ProxySQL/proxysql-2.0.x/$(lsb_release -sc)/ ./ \
  | tee /etc/apt/sources.list.d/proxysql.list

apt-get update
apt-get install proxysql OR apt-get install proxysql=version

### 启动/停止/重启服务

service proxysql start

service proxysql stop

service proxysql restart

### 配置文件
- 配置文件路径

/etc/proxysql.cnf

- 常用配置

datadir: proxysql ##数据文件存放目录, 和审计日志、查询日志等
errorlog: ##错误日志目录
admin_variables=
{
admin_credentials="admin:admin" ##proxysql管理账号
mysql_ifaces="0.0.0.0:6032" ## proxysql管理端口
}
mysql_variables=
{
interfaces="0.0.0.0:6033" ## proxysql代理访问端口, 一般开放给用户
}
```