ProxySQL Main (runtime)

Main (runtime)

Listing all tables

 1 Admin> SHOW TABLES FROM main;
 2 +--------------------------------------------+
 3 | tables                                     |
 4 +--------------------------------------------+
 5 | global_variables                           |
 6 | mysql_collations                           |
 7 | mysql_group_replication_hostgroups         |
 8 | mysql_query_rules                          |
 9 | mysql_replication_hostgroups               |
10 | mysql_servers                              |
11 | mysql_users                                |
12 | proxysql_servers                           |
13 | runtime_checksums_values                   |
14 | runtime_global_variables                   |
15 | runtime_mysql_group_replication_hostgroups |
16 | runtime_mysql_query_rules                  |
17 | runtime_mysql_replication_hostgroups       |
18 | runtime_mysql_servers                      |
19 | runtime_mysql_users                        |
20 | runtime_proxysql_servers                   |
21 | runtime_scheduler                          |
22 | scheduler                                  |
23 +--------------------------------------------+
24 18 rows in set (0.00 sec)

View Code

Key Configuration Tables

mysql_servers

mysql_servers表定义后端所有的MySQL server：

 1 Admin> SHOW CREATE TABLE mysql_serversG
 2 *************************** 1. row ***************************
 3        table: mysql_servers
 4 Create Table: CREATE TABLE mysql_servers (
 5     hostgroup_id INT NOT NULL DEFAULT 0,
 6     hostname VARCHAR NOT NULL,
 7     port INT NOT NULL DEFAULT 3306,
 8     status VARCHAR CHECK (UPPER(status) IN ('ONLINE','SHUNNED','OFFLINE_SOFT', 'OFFLINE_HARD')) NOT NULL DEFAULT 'ONLINE',
 9     weight INT CHECK (weight >= 0) NOT NULL DEFAULT 1,
10     compression INT CHECK (compression >=0 AND compression <= 102400) NOT NULL DEFAULT 0,
11     max_connections INT CHECK (max_connections >=0) NOT NULL DEFAULT 1000,
12     max_replication_lag INT CHECK (max_replication_lag >= 0 AND max_replication_lag <= 126144000) NOT NULL DEFAULT 0,
13     use_ssl INT CHECK (use_ssl IN(0,1)) NOT NULL DEFAULT 0,
14     max_latency_ms INT UNSIGNED CHECK (max_latency_ms>=0) NOT NULL DEFAULT 0,
15     comment VARCHAR NOT NULL DEFAULT '',
16     PRIMARY KEY (hostgroup_id, hostname, port) )
17 1 row in set (0.00 sec)

View Code