Skip to content

Install ProxySQL 2.x.x binary tarball

If installing ProxySQL 2 with a package manager is not an option in your environment, you can install from a binary tarball. The difference between versions is the available tar files or the command to extract the file.

Starting with ProxySQL 2.3.2-1.2, Percona no longer provides a tarball for CentOS 6. For more information, see Spring Cleaning: Discontinuing RHEL 6/CentOS 6 (glibc2.12) and 32-bit Binary Builds of Percona Software

The password-based file encryption requires OpenSSL 1.1.1, but Ubuntu 16.04 does not support this OpenSSL version. A special statically linked OpenSSL 1.1.1 binary is packaged with the executable. This packaged binary avoids conflicts with the system OpenSSL and any shared libraries. Each new release rebuilds the binary.

Follow these steps:

  1. In Download ProxySQL, select the ProxySQL 2 product.

  2. In the Select Product Version field, select the ProxySQL 2 version.

  3. In the Select Platform field, select Linux - Generic.

  4. Select the tar file.

    tar files for ProxySQL 2.4.4 and higher
    Name Description
    proxysql-2--Linux-x86_64.glibc2.23.xenial.tar.gz For Ubuntu 16.04 xenial only
    proxysql-2--Linux-x86_64.glibc2.17.tar.gz For every supported operating system
    proxysql-2--Linux-x86_64.glibc2.27.tar.gz For every supported operating system but xenial. For CentOS 7, install OpenSSL 1.1.1, if needed.
    tar files from ProxySQL 2.3.2-1.2 to ProxySQL 2.4.3
    Name Description
    proxysql-2--Linux-x86_64.glibc2.23.xenial.tar.gz For Ubuntu 16.04 xenial only
    tar files from ProxySQL 2.0.15 to ProxySQL 2.3.2
    Name Description
    proxysql-2.0.XX-Linux-x86_64.glibc2.12.tar.gz For every supported operating system but xenial. For CentOS 7, install OpenSSL 1.1.1, if needed.
    proxysql-2.x.xx-Linux-x86_64.glibc2.17.tar.gz For every supported operating system
    proxysql-2.0.XX-Linux-x86_64.glibc2.23.xenial.tar.gz For Ubuntu 16.04 xenial only.

    See ProxySQL 2.0.15 and proxysql-admin

  5. Navigate to the downloaded tar file.

  6. Extract the files with the following commands:

    Extract ProxySQL 2.0.14 or higher
    $ # Extract the files to the download destination directory
    $ tar xzf proxysql-2.X.X-<PLATFORM-ARCHITECTURE*>.tar.gz
    $ # Change to the directory that contains the extracted files
    $ cd proxysql-<VERSION>-Linux-<PLATFORM-ARCHITECTURE>
    
    Extract ProxySQL 2.0.13 or lower
    # Extract the files (assumes you have changed to the download destination directory)
    $ tar xzf proxysql-<VERSION>-<Linux-PLATFORM-ARCHITECTURE*>.tar.gz
    # Change to the directory that contains the extracted files
    $ cd proxysql-<VERSION>-Linux-<PLATFORM-ARCHITECTURE>
    
  7. Create a directory to store the ProxySQL data.

    $ mkdir /home/user/data
    
  8. In the configuration file, update the datadir value to point to the created data directory.

    ```{.text .no-copy}
    datadir="/home/user/data"
    ```
    
  9. Set the other options, as needed.

Get expert help

If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.


Last update: 2024-05-21