ProxySQL – MySQL_User 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.

Inserting and Updating MySQL Users in ProxySQL

The MySQL users that clients can use to connect to ProxySQL and then backends are defined in the table mysql_users.

INSERT INTO mysql_users ( username, password, default_hostgroup )
VALUES ( ‘reportServer’, ‘somePassword’, 2);

UPDATE mysql_users SET max_connections=20000
WHERE username=’reportServer’;

DELETE FROM mysql_users
WHERE username=’reportServer’;

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

Hope you find this article helpful.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s