Cache Manager

Cache Manager allows you to clear the cache from memory under very specific circumstances. The standard cache control expires with a TTL setting. However, there are conditions when we need more control over dynamic content or content that may expire periodically. Here we can delete all cache, delete cache for a specific database, or delete cache within databases that match a specific pattern and apply the rules to a schedule. 
 

 Clear Cache

  1. On the ScaleArc dashboard, click CLUSTERS > Settings > Transparent Cache.

    Transparent_cache.png 
     
  2. Click the Cache Manager tab.

    CacheManager_MySQL.png
     
  3. Configure the fields as follows:

    Field Description Default/User Input
    Delete Cache For all Databases

    This option deletes the entire cache for the selected cluster. Select this option only when you have made major changes to the cluster. Wiping the cache of a busy cluster, where significant amount of queries are being served from cache, can put severe strain on database servers. 

    Select the radio button.
    Delete Cache for Database

    Select a database to delete the entire cache when you have modified the structure of the database or added or removed major tables. You can also delete the dynamic cache for the selected database. 

    Select the radio button.
    Delete Cache for Patterns Within Database

    Select a database and the pattern to delete the entire cache for the pattern added for the specified database. A single pattern may be responsible for caching many queries. 

    Warning: Wiping the cache for a pattern results in additional load on the database server for a compute-intensive query which matches that pattern.

    1 Select the radio button.
    2 Then, choose the database and the pattern from the drop downs.
    Schedule for Later button Schedules the deletion of the cache at the specified hour of the day.  See below.
    Delete Now button

    Deletes the cache.

    Click on the Delete Now button.

 

Set update schedule

You can schedule a cache delete to occur over a period of time.

  1. Click on a delete option (for example, Delete Cache for Database) and select the database from the drop-down.
  2. Click the Schedule for Later button.
  3. Identify the day(s) and hours for your scheduled deletes.

    CacheManager_Schedule_MySQL.png

  4. Click on Update Schedule to commit the configuration.

    Cache-Manager-Update-Schedule-Success.png 
     
  5. Alternatively, click Back to cancel and return to the previous screen.

Back to top

Comments

0 comments

Please sign in to leave a comment.