top of page


Public·34 members

ProxySQL Admin Interface Is Not Your Typical MySQL Server!


If enabled (default), after ProxySQL Cluster synchronizes MySQL Servers tables from a remote node, the configuration is also locally persisted to disk.See admin-checksum_mysql_servers and ProxySQL Cluster for further details.

Semicolon-separated list of hostname:port entries for interfaces on which the admin interface should listen. It also supports UNIX domain sockets for the cases where the connection is done from an application on the same machine: in this case the full path of the socket must be specified.For example: SET admin-mysql_ifaces=';/tmp/proxysql_admin.sock'.Please note that the default admin user can only connect locally for security reasons. In order to connect remotely a secondary user needs to be created by defining this in the admin-admin_credentials variable, for example admin-admin_credentials="admin:admin;radminuser:radminpass".

This is a list of semi-colon separated user:password pairs that defines the read-only credentials for connecting to the admin interface. These are not allowed to update internal data structures such as the list of MySQL backend servers (or hostgroups), query rules, etc., neither to read configuration tables. They are only allowed to read from the statistics and monitoring tables.Note: there are several restrictions on use of users in admin-stats_credentials : the restrictions are the same as those listed in admin-admin_credentials

ProxySQL embeds an HTTP web server from where it is possible to gather certain metrics.Credentials to access the web interfaces are the same as those defined in admin-stats_credentials.When Web UI plugin is enabled, the HTTP web server can be used to reconfigure ProxySQL itself, and the credentials configured in admin-admin_credentials can be used to access the web interface.

To connect to the ProxySQL admin interface, use the mysql client. Youcan either connect to the admin interface from a Percona XtraDB Cluster node that already has themysql client installed (Node 1, Node 2, Node 3) or install the client onNode 4 and connect locally. For this tutorial, install Percona XtraDB Cluster on Node 4: