ProxySQL

ProxySQL

• we are not experts in ProxySQL so this is only basic functional setting

Basic proxy configuration:

datadir="/var/lib/proxysql"
errorlog="/var/lib/proxysql/proxysql.log"

admin_variables=
{
	admin_credentials="admin:admin"
	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="voip"
	monitor_password="test"
	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
}
mysql_servers =
(
	{ address="127.0.0.1" , port=3306 , hostgroup=0, max_connections=1000}
)
mysql_users:
(
	{
		username = "user" # no default , required
		password = "pass" # default: 
	}
)
mysql_query_rules:
(
)
scheduler=
(
)
mysql_replication_hostgroups=
(
)

First start for ProxySQL initialization:

/usr/bin/proxysql --idle-threads -c /etc/proxysql.cnf -f --initial

Foreground start for testing:

/usr/bin/proxysql --idle-threads -c /etc/proxysql.cnf -f

Set the SET rule to avoid warnings:

root@vmmysql:~# mysql -h 127.0.0.1 -P 6032 -u admin -p
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.30 (ProxySQL Admin Module)

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [(none)]> INSERT INTO mysql_query_rules (rule_id, active, match_digest, multiplex) VALUES (1, 1, '^SET ', 1);
Query OK, 1 row affected (0.000 sec)

MySQL [(none)]> LOAD MYSQL QUERY RULES TO RUNTIME;
Query OK, 0 rows affected (0.000 sec)

MySQL [(none)]> SAVE MYSQL QUERY RULES TO DISK;
Query OK, 0 rows affected (0.006 sec)

• sensor and GUI setting can be done by usual way