Ashwini Ahire edited this page Jul 11, 2018 · 19 revisions

Feature X doesn't work. Please advise

Please read How To ask Questions The Smart Way, then ask on forum or report a bug

Disclaimer: Thyrsus Enterprises is not a help desk .

How do I configure ProxySQL to connect to MySQL?

Port 6032 is the default port used by the "Admin interface".
Through this interface you can configure ProxySQL and get metrics from it by using a normal MySQL client.

for configuration check out also:
https://github.com/sysown/proxysql/wiki/ProxySQL-Configuration/#p6032


How can I connect to a MySQL server through ProxySQL?

In order to connect to MySQL servers through ProxySQL you should connect to Port 6033 (by default).

for configuration check out also:
https://github.com/sysown/proxysql/wiki/ProxySQL-Configuration/#p6033


Does ProxySQL support ip address whitelist?

ProxySQL supports some sort of IP address whitelisting. Field mysql_query_rules.client_addr can be used to filter traffic based on clients addresses, therefore it is possible to allow traffic from specific addresses while blocking everything else.
The catch here is that the filtering is done on the queries only: clients not in the "whitelist" can still be able to connect to ProxySQL, although their queries will be blocked.

check out also:
https://github.com/sysown/proxysql/wiki/ProxySQL-Configuration#mysql-query-rules


Are requests load balance for a single connection?

Yes, by default, it is possible that the requests coming from a single connection are evenly distributed among all the backends of the same hostgroup.

check out also:
https://github.com/sysown/proxysql/wiki/ProxySQL-Configuration


Clone this wiki locally
You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.
Press h to open a hovercard with more details.