Install ProxySQL 2.x.x binary tarball¶

In an MySQL 8.4 or Percona Server for MySQL 8.4 environment, you may have the following issues:

ProxySQL contains counters that have not been updated to use the new terminology. Unexpected results may occur
The binlog reader errors out during initialization due to the use of the old terminology, such as SHOW MASTER STATUS command.

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:

In Download ProxySQL, select the ProxySQL 2 product.
In the Select Product Version field, select the ProxySQL 2 version.
In the Select Platform field, select Linux - Generic.

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

Navigate to the downloaded tar file.

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>

Create a directory to store the ProxySQL data.
```
$ mkdir /home/user/data
```
In the configuration file, update the datadir value to point to the created data directory.
```
```{.text .no-copy}
datadir="/home/user/data"
```
```
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.

Community Forum Get a Percona Expert

Last update: 2024-11-20