ProxySQL – Modify Variable Values

ProxySQL is a powerful software load balancer and an open-source database protocol-aware proxy for MySQL that provides high performance, high availability, and high availability.

Typically, a load balancer distributes network or application traffic among available servers, resulting in increased application efficiency, dependability, availability, and performance by boosting concurrent users and enhancing hardware utilization efficiency.

ProxySQL is a daemon that is monitored by a monitoring process. To reduce downtime, the process monitors the daemon and restarts it if it crashes. The daemon accepts traffic from MySQL clients and routes it to MySQL servers in the backend.

UPDATING GLOBAL VARIABLES in ProxySQL

The initialization values for the corresponding session variables for new connections to MySQL are called GLOBAL variables.   Similar to this, the value of a SESSION variable is the value that is applied to the current connection.

Each global variable is initialized to its default value when the server starts. When it comes to its importance, the overall performance of the server is impacted by global variables.

UPDATE global_variables SET variable_name=’false’
WHERE variable_name = ‘admin-hash_passwords’;

UPDATE global_variables SET variable_value = 30000
WHERE variable_name = ‘mysql-connect_timeout_client’;

UPDATE global_variables SET variable_value = 30000
WHERE variable_name = ‘mysql-connect_timeout_server_max’;

After adding the configuration, we must load the configuration into runtime and store it on disk. Otherwise, the configurations would be lost when the ProxySQL is restarted. So, in order to load the configuration into memory and save it to disk, the following commands are required.

# Active current in-memory MySQL User Configuration
LOAD MYSQL VARIABLES TO RUNTIME;

# Save the current in-memory MySQL User configuration to the disk
SAVE MYSQL VARIABLES TO DISK;

Hope you find this article helpful.