proxysql/proxysql repository overview

⁠Overview

ProxySQL is a high performance, high availability, protocol aware proxy for MySQL and PostgreSQL. All the while getting the unlimited freedom that comes with a GPL license.

Its development is driven by the lack of open source proxies that provide high performance.

Details at ProxySQL⁠ website.

⁠Image Description

To pull the latest image simply run:

$ docker pull proxysql/proxysql

Or otherwise for a specific version (images use semantic versioning) specify the associated tag:

e.g. for version 3.0.3:

$ docker pull proxysql/proxysql:3.0.3

e.g. for version 2.7.3:

$ docker pull proxysql/proxysql:2.7.3

Omitted version or part of implies latest in series:

e.g. latest in the 3.0.y series:

$ docker pull proxysql/proxysql:3.0

e.g. latest in the 3.x.y series:

$ docker pull proxysql/proxysql:3

The image is based on Debian and runs ProxySQL as a foreground process.

• NOTE: The package doesn't contain the MySQL client

⁠Run

To run a ProxySQL container with a custom ProxySQL configuration file:

$ docker run -p 16032:6032 -p 16033:6033 -p 16070:6070 -d -v /path/to/proxysql.cnf:/etc/proxysql.cnf proxysql/proxysql

NOTE: You will need to define a second pair of admin credentials to connect outside of your container.

⁠Sample config file (i.e. /path/to/proxysql.cnf listed above)

The following basic configuration file should be sufficient for development purposes, this configuration will allow you to connect to your ProxySQL Docker container remotely using the second pair of admin_credentials e.g.:

mysql -h127.0.0.1 -P16032 -uradmin -pradmin --prompt "ProxySQL Admin>"

datadir="/var/lib/proxysql"

admin_variables=
{
	admin_credentials="admin:admin;radmin:radmin"
	mysql_ifaces="0.0.0.0:6032"
}

mysql_variables=
{
	threads=4
	max_connections=2048
	default_query_delay=0
	default_query_timeout=36000000
	have_compress=true
	poll_timeout=2000
	interfaces="0.0.0.0:6033"
	default_schema="information_schema"
	stacksize=1048576
	server_version="5.5.30"
	connect_timeout_server=3000
	monitor_username="monitor"
	monitor_password="monitor"
	monitor_history=600000
	monitor_connect_interval=60000
	monitor_ping_interval=10000
	monitor_read_only_interval=1500
	monitor_read_only_timeout=500
	ping_interval_server_msec=120000
	ping_timeout_server=500
	commands_stats=true
	sessions_sort=true
	connect_retries_on_failure=10
}

⁠Dockerfile

Details in ProxySQL Docker-Images⁠ repo.