Proxysql mysql_query_rules translation
MySQL Query Rules
Here is the statement used to create the mysql_query_rules table:
CREATE TABLE mysql_query_rules (
Rule_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL
Active INT CHECK (active IN (0Pol 1)) NOT NULL DEFAULT 0
Username VARCHAR
Schemaname VARCHAR
FlagIN INT NOT NULL DEFAULT 0
Client_addr VARCHAR
Proxy_addr VARCHAR
Proxy_port INT
Digest VARCHAR
Match_digest VARCHAR
Match_pattern VARCHAR
Negate_match_pattern INT CHECK (negate_match_pattern IN (0Pol 1)) NOT NULL DEFAULT 0
Re_modifiers VARCHAR DEFAULT 'CASELESS'
FlagOUT INT
Replace_pattern VARCHAR
Destination_hostgroup INT DEFAULT NULL
Cache_ttl INT CHECK (cache_ttl > 0)
Reconnect INT CHECK (reconnect IN (0Pol 1)) DEFAULT NULL
Timeout INT UNSIGNED
Retries INT CHECK (retries > = 0 AND retries
