When configuring remote backend MySQL servers it is ONLY required to specify port if it is non-default (i.e. This is achieved by adding them to the mysql_servers table.
ProxySQL Admin> SELECT * from mysql_query_rules įor the purpose of this guide, 3x MySQL server backends will be configured. ProxySQL Admin> SELECT * from mysql_replication_hostgroups ProxySQL Admin> SELECT * FROM mysql_servers Verify that the configuration is empty by checking that there are no entries in the mysql_servers, mysql_replication_hostgroups and mysql_query_rules tables. ProxySQL’s internals can be reconfigured using the standard SQL ProxySQL Admin interface, accessible via any MySQL command line client (available by default on port 6032): $ mysql -u admin -padmin -h 10.10.0.1 -P6032 -prompt 'ProxySQL Admin> ' The guide assumes you understand ProxySQL’s overall architecture and that ProxySQL is already installed on your operating system with the default configuration. This guide describes how to configure the basic components of ProxySQL step by step.
0 kommentar(er)
