Functional Spec: Query Firewall
|Parameter Location||CLUSTER -> Security -> Firewall|
|Modifiable without restarting cluster||YES|
Firewall Rules - Query firewall rules work very similar to cache rules in the way it filters on SQL string using patterns and expressions. You can add and prioritize rules that prevent certain queries from reaching your database servers. You could use these rules to block malicious queries, prevent data deletion or modification, or even prevent mass data theft. Firewall rules are specified in the same manner as cache rules by using regular expression patterns. A rule like ".*drop.*" will block any query that includes the word "drop".
Take a look at the REGEX guide to learn how to build more complicated rules.
The query firewall rules screen lists all databases and the patterns associated with a database. Click on the edit icon to add or modify patterns for a database.
If you are experiencing issues with ScaleArc or with any of it's features, please contact ScaleArc Support. We are available 24x7 by phone at 855 800 7225 or +1 408 412 7315. For general support inquiries, you can also e-mail us at firstname.lastname@example.org.
2901 Tasman Drive Santa Clara, CA 95054 | Email: email@example.com