skip to content »

Invalidating query cache entries replication

Scale Arc’s auto cache invalidation feature uses the transparent No SQL technology by extracting metadata from the query and tagging the cache objects used to associate cache entries with invalidation queries.

Scale Arc then has a cache invalidation group consisting of read queries or stored procedures as well invalidation queries or stored procedures all using a common column.Once the cache rules are created and grouped, Scale Arc will add cache objects created by the select calls with the metadata value extracted from the column location.When the application modifies data with the update or insert queries, Scale Arc will extract the metadata values from the column location.Using the column value or metadata, Scale Arc will invalidate only those cache items where the column value or metadata is an exact match.Subsequent select queries with the same invalidated column value(s) will get a cache miss and will be sent to the database.The invalidation mechanisms can also be triggered via API or as part of a SQL comment that includes the metadata for the column values.

The following use cases are supported using the auto cache invalidation-based method: Shopping cart data is tracked for a user in an e Commerce application on every page load.

Queries that happened a month ago are probably no longer useful now.

So if it's storing those query results then it's completely worthless because chances are no one is going to run that same exact query again.

User profile data, that is personal data associated with a specific user, is typically the most accessed data for the majority of applications.

User profile databases need to have 100% uptime because they are validating users before any transactions can be performed.

Scale Arc has introduced auto cache invalidation to the industry – a method for automatically invalidating cache entries that enables true ACID-compliant caching.