Created
October 14, 2016 08:51
-
-
Save freddielunchbird/09f292c2f356a7f8ebb1089440519faf to your computer and use it in GitHub Desktop.
mysql query rules
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "result": [{ | |
| "errorMessage": "", | |
| "proxysql": { | |
| "hostname": "10.10.10.13", | |
| "port": 6032 | |
| }, | |
| "query_rules": [{ | |
| "active": "1", | |
| "apply": "1", | |
| "cache_ttl": "NULL", | |
| "client_addr": "NULL", | |
| "delay": "NULL", | |
| "destination_hostgroup": "10", | |
| "digest": "NULL", | |
| "error_msg": "NULL", | |
| "flagIN": "0", | |
| "flagOUT": "NULL", | |
| "log": "NULL", | |
| "match_digest": "NULL", | |
| "match_pattern": "^SELECT .* FOR UPDATE", | |
| "mirror_flagOUT": "NULL", | |
| "mirror_hostgroup": "NULL", | |
| "negate_match_pattern": "0", | |
| "proxy_addr": "NULL", | |
| "proxy_port": "NULL", | |
| "reconnect": "NULL", | |
| "replace_pattern": "NULL", | |
| "retries": "NULL", | |
| "rule_id": "100", | |
| "schemaname": "NULL", | |
| "timeout": "NULL", | |
| "username": "NULL" | |
| }, { | |
| "active": "1", | |
| "apply": "1", | |
| "cache_ttl": "NULL", | |
| "client_addr": "NULL", | |
| "delay": "NULL", | |
| "destination_hostgroup": "20", | |
| "digest": "NULL", | |
| "error_msg": "NULL", | |
| "flagIN": "0", | |
| "flagOUT": "NULL", | |
| "log": "NULL", | |
| "match_digest": "NULL", | |
| "match_pattern": "^SELECT .*", | |
| "mirror_flagOUT": "NULL", | |
| "mirror_hostgroup": "NULL", | |
| "negate_match_pattern": "0", | |
| "proxy_addr": "NULL", | |
| "proxy_port": "NULL", | |
| "reconnect": "NULL", | |
| "replace_pattern": "NULL", | |
| "retries": "NULL", | |
| "rule_id": "200", | |
| "schemaname": "NULL", | |
| "timeout": "NULL", | |
| "username": "NULL" | |
| }, { | |
| "active": "1", | |
| "apply": "1", | |
| "cache_ttl": "NULL", | |
| "client_addr": "NULL", | |
| "delay": "NULL", | |
| "destination_hostgroup": "10", | |
| "digest": "NULL", | |
| "error_msg": "NULL", | |
| "flagIN": "0", | |
| "flagOUT": "NULL", | |
| "log": "NULL", | |
| "match_digest": "NULL", | |
| "match_pattern": ".*", | |
| "mirror_flagOUT": "NULL", | |
| "mirror_hostgroup": "NULL", | |
| "negate_match_pattern": "0", | |
| "proxy_addr": "NULL", | |
| "proxy_port": "NULL", | |
| "reconnect": "NULL", | |
| "replace_pattern": "NULL", | |
| "retries": "NULL", | |
| "rule_id": "300", | |
| "schemaname": "NULL", | |
| "timeout": "NULL", | |
| "username": "NULL" | |
| }] | |
| }, { | |
| "errorMessage": "", | |
| "proxysql": { | |
| "hostname": "10.10.10.14", | |
| "port": 6032 | |
| }, | |
| "query_rules": [{ | |
| "active": "1", | |
| "apply": "1", | |
| "cache_ttl": "NULL", | |
| "client_addr": "NULL", | |
| "delay": "NULL", | |
| "destination_hostgroup": "10", | |
| "digest": "NULL", | |
| "error_msg": "NULL", | |
| "flagIN": "0", | |
| "flagOUT": "NULL", | |
| "log": "NULL", | |
| "match_digest": "NULL", | |
| "match_pattern": "^SELECT .* FOR UPDATE", | |
| "mirror_flagOUT": "NULL", | |
| "mirror_hostgroup": "NULL", | |
| "negate_match_pattern": "0", | |
| "proxy_addr": "NULL", | |
| "proxy_port": "NULL", | |
| "reconnect": "NULL", | |
| "replace_pattern": "NULL", | |
| "retries": "NULL", | |
| "rule_id": "100", | |
| "schemaname": "NULL", | |
| "timeout": "NULL", | |
| "username": "NULL" | |
| }, { | |
| "active": "1", | |
| "apply": "1", | |
| "cache_ttl": "NULL", | |
| "client_addr": "NULL", | |
| "delay": "NULL", | |
| "destination_hostgroup": "20", | |
| "digest": "NULL", | |
| "error_msg": "NULL", | |
| "flagIN": "0", | |
| "flagOUT": "NULL", | |
| "log": "NULL", | |
| "match_digest": "NULL", | |
| "match_pattern": "^SELECT .*", | |
| "mirror_flagOUT": "NULL", | |
| "mirror_hostgroup": "NULL", | |
| "negate_match_pattern": "0", | |
| "proxy_addr": "NULL", | |
| "proxy_port": "NULL", | |
| "reconnect": "NULL", | |
| "replace_pattern": "NULL", | |
| "retries": "NULL", | |
| "rule_id": "200", | |
| "schemaname": "NULL", | |
| "timeout": "NULL", | |
| "username": "NULL" | |
| }, { | |
| "active": "1", | |
| "apply": "1", | |
| "cache_ttl": "NULL", | |
| "client_addr": "NULL", | |
| "delay": "NULL", | |
| "destination_hostgroup": "10", | |
| "digest": "NULL", | |
| "error_msg": "NULL", | |
| "flagIN": "0", | |
| "flagOUT": "NULL", | |
| "log": "NULL", | |
| "match_digest": "NULL", | |
| "match_pattern": ".*", | |
| "mirror_flagOUT": "NULL", | |
| "mirror_hostgroup": "NULL", | |
| "negate_match_pattern": "0", | |
| "proxy_addr": "NULL", | |
| "proxy_port": "NULL", | |
| "reconnect": "NULL", | |
| "replace_pattern": "NULL", | |
| "retries": "NULL", | |
| "rule_id": "300", | |
| "schemaname": "NULL", | |
| "timeout": "NULL", | |
| "username": "NULL" | |
| }] | |
| }] | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment