Microsoft SQL Server

A Microsoft SQL Server (MSSQL) persistence connection can be used to connect your Active Caching module to an MSSQL database. This allows modules to persist modifications to SQL Server and retrieve saved values when the module first creates an object.

To connect to am MSSQL database, supply a MSSQL Database connection string. This string is an expression that contains the parameters required for applications to connect to the database server.

Here is a screenshot of the dialog in the ScaleOut Active Caching UI for creating a Microsoft SQL Server connection:

The “Create table if missing” option causes the connection to automatically create the table used to store instance data if it does not already exist in the database. The table will be named ScaleoutModuleInstances.

Enable MSSQL Persistence for a Module

When launching your model through the ScaleOut Active Caching UI, you can enable persistence by selecting the Microsoft SQL Server persistence provider you have defined above. If write-through is enabled, this will cause instances in your module to periodically persist themselves to MSSQL every five seconds (if the object has been modified). If read-through is enabled, this will cause instances to retrieve their state from MSSQL when they are first created.