This 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:
sudo apt install proxysql2
To Install ProxySQL on RPM-based distributions, run:
sudo yum install proxysql2
After installation, ProxySQL will not be started automatically. To start it, use:
sudo service proxysql start
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:
mysql -uadmin -padmin -h127.0.0.1 -P6032 --prompt='\u (\d)>' main
admin (main)>UPDATE global_variables SET variable_value='admin:NEWPASSWORD' WHERE variable_name='admin-admin_credentials';
admin (main)>LOAD ADMIN VARIABLES TO RUNTIME;
admin (main)>SAVE ADMIN VARIABLES TO DISK;
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:
echo "alias psqladmin=\"mysql -uadmin -pNEWPASSWORD -h 127.0.0.1 -P 6032 --prompt='ProxySQLAdmin> '\"" >>$HOME/.bashrc
You can then proceed to configure ProxySQL according to your use-case.