Signup and create a free PolyScale account here. There is a free tier and no credit card is required.
A Polyscale account can have one or more
caches defined. A cache simply identifies a database origin via a
port that you wish to cache data for. Typically you create a cache per database for simplicity.
To create a new cache, click the
New Cache button in the upper right of the caches dashboard and enter the hostname and port of the database you wish to connect to.
To connect to the origin database via PolyScale simply update any client applications as follows:
The Cache ID can be found under the
Settings tab of any cache (as detailed in Step 2 above). For MySQL and MariaDB, this is prepended to the database username seperated with a hyphen (see example below). For PostgreSQL, an
application_name property containing the PolyScale Cache ID is required e.g.
For further details, see Getting Connected.
If the username provided by PolyScale is
8c126a4d-567a-4382-9ffe-b31ec50635f2 and the origin database username is
foobar, the database username to connect via PolyScale would be
PolyScale does not save your database username and password. To connect to your database via PolyScale, no database credentials on the origin database change.
All database traffic flowing through PolyScale will be captured within the Observability tab of each cache. PolyScale provides visualizations and metrics to make it easy to examine query behavior. A
Cacheability score is provided that indicates query candidates that are best suited to be cached, as well as a
Recommended TTL value.
If PolyScale has derived an optimum TTL value for a specified query, it will be listed as a button option within the
Actions column. Click to accept the TTL value. If no "Set TTL" button is listed as an Action, PolyScale does not yet have enough data to make a TTL recommendation. Revisit the query at a later date or, manually set a TTL by selecting the menu dropdown from the
Actions column and selecting
Read more about Cache Configuration.