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.

   datadir="/home/user/data"
   

9. Set the other options, as needed.

See also

ProxySQL 2.x and proxysql-admin utility

Contact us

For free technical help, visit the Percona Community Forum.

To report bugs or submit feature requests, open a JIRA ticket.

For paid support and managed or consulting services , contact Percona Sales.

---

Last update: 2023-08-23