The PolyScale platform proxies and caches using native database wire protocols. It transparently connects to your current database and requires no code or infrastructure changes; just update your database origin host address.
Queries are inspected and reads (SQL SELECT) can be cached geographically close to the requesting origin for accelerated performance. All other traffic (INSERT, UPDATE and DELETE) seamlessly pass through to the source database.
PolyScale provides a global edge network for database caching. Connecting to PolyScale via a database client application will automatically route the request to the closest Point Of Presence (POP) where the query results are then cached for low latency access.
PolyScale caches database responses i.e. the payloads returned from the origin database when a query is executed. These are stored locally to where the request originated.
Time To Live (TTL) values can be configured for query templates that span queries with common structure or entire tables. This gives fine grained control over what is cached and for how long. Read more about Cache Configuration.
At Polyscale we are excited about the future. We are building machine based intelligent cache configuration and invalidation rules using statistical analysis of query patterns. This analysis runs continuously in the background. At any time, the most up to date recommendations on optimal cache configurations are available and ready to be applied. That application can occur manually by the user, or in hands free mode, automatically adapting to conditions.
Some use cases require the ability to invalidate the cache based on data change. PolyScale efficiently inspects database requests for updates (DML - INSERT, UPDATE and DELETE) and can automatically invalidate accordingly.
If your use case requires this type of invalidation, please contact us to learn more.