How to Install ProxySQL From the Percona Repository

install proxysql percona repositoryThis article describes how to install ProxySQL from the Percona Software Repositories.

Percona Software Repositories contain a ProxySQL version that has passed rigorous Percona tests and is known to be compatible with other Percona Software. We recommend using those builds whenever you’re running ProxySQL with Percona Server for MySQL, Percona XtraDB Cluster, MySQL, or MariaDB.

To install the Percona Repository for DEB-based distributions (Debian and Ubuntu) follow these instructions, and for RPM-based distributions (RedHat Enterprise Linux and Derivatives) follow these instructions.

At the time of this writing, ProxySQL 2 is the latest major release of ProxySQL and it is recommended for new installations. You can also install older ProxySQL version 1 by using “proxysql” instead of “proxysql2” as the package name.

To Install ProxySQL on DEB-based distributions, run:

 

To Install ProxySQL on RPM-based distributions, run:

 

After installation, ProxySQL will not be started automatically.  To start it, use:

 

Warning – Never run ProxySQL in productions with default credentials. You can change those credentials by editing the /etc/proxysql.cnf configuration file or (assuming you have the mysql client installed) by running:

 

This will set credentials for the ProxySQL Administrative user to user “admin” with the password “NEWPASSWORD”.

Bonus Tip:  If you do not want to remember this long command to access your ProxySQL admin interface, consider saving it to your .bashrc:

 

You can then proceed to configure ProxySQL according to your use-case.   

Further Reading:

Share this post

Comments (4)

  • gunni Reply

    For logging into mysql i additionally change the HISTFILE, so the proxysql specific wont get mixed up with the mysql queries.
    MYSQL_HISTFILE=.proxysql_history mysql -uadmin -pNEWPASSWORD -h 127.0.0.1 -P 6032 –prompt=’ProxySQLAdmin> ‘

    April 8, 2020 at 3:26 pm
  • john danilson Reply

    it would be helpful if proxysql was listed in “products” and links to a download page were provided.

    May 1, 2020 at 11:20 am
    • Peter Zaitsev Reply

      We will have to figure out how to structure it better ProxySQL is not Percona’s product though we provide packages for convenience, it is different in this regard from Percona Server for MySQL and such.

      May 1, 2020 at 6:20 pm

Leave a Reply