Upgrading to new SQL server cache

WebMap now includes as standard a new SQL database cache Garnet (this replaces Redis used in previous versions). It also includes Memurai as a CLI (Command Line Interface) to manage the cache.

The new cache functionality is available on all WebMap installations 9.1.2340 onwards.

About Garnet

Garnet is in many ways similar to Redis; they share the same commands and both can be configured for clustering or replication. As an added advantage existing Redis configuration files can be reused with Garnet by renaming the *.conf files to “garnet.conf”).

The default Garnet port is the same as Redis (6379). If upgrading from WebMap 9.1.2312 or earlier, first remove Redis using standard Windows uninstallation. If not, the port required by Memurai/Garnet will still be in use by Redis and WebMap installation will fail.

After a successful WebMap installation, a Memurai 4.1.4 Windows Service and a GarnetServer process are added to Windows services.

All Garnet installation files are stored in C:\Cadcorp\Services\Garnet and all Memurai files in C:\Program Files\Memurai. To configure settings use the garnet.conf file.

Accessing the SQL cache

The cache can be accessed via the Memurai command line interface:

Here -h is the host url -p is the port number.

To flush the cache:

Remember

Garnet is not considered a prerequisite; it is automatically installed and managed by the WebMap installer instead. This means Garnet binaries will be uninstalled if no other WebMap instance is present.

Troubleshooting and advice

1. GarnetServer process has not been started

  • Start Garnet via Powershell:

    • Copy 
    Start-Process -FilePath "C:\Cadcorp\Services\Garnet\GarnetServer.exe" -ArgumentList "--lua -q" -WindowStyle Hidden

  • Start Garnet via command line (closing the window will end the Garnet process!):

2. Memurai fails to connect to Garnet

Confirm you have uninstalled Redis and port 6379 is not in use.