How does ScaleArc’s transparent SQL caching work?
Once your database traffic is flowing through ScaleArc, you can activate SQL caching quite easily. You can set up Regular Expression rules – either manually or automatically via ScaleArc’s built-in analytics GUI – for those queries you want to cache, and you can designate the length of time you would like the caching to remain in effect (the so-called “Time to Live” or TTL). For example, a simple “.*” expression with a TTL of 60 seconds will cache all select queries for a period of 60 seconds, whereas a more specific pattern of “select * from table2 where userid=.*” with a TTL of 10 minutes will cache only queries that match this specific pattern for 10 minutes. Once you select the pattern, usually by clicking on an existing query to use its pattern as a regular expression, and set the TTL, you can add it to the cache in one mouse click.