This parameter indicates the connection string that the master must use to communicate with the replica. This information is read when the replica server is started. The connect string is sent to the master as part of each message from the replica to the master.

For example:

none

RW

Replica

The size of the statement cache used during one propagation in Master. The statement cache is used to store prepared statements received by Master in one propagation from Replica.

10

RO

Master

This parameter defines the transaction isolation level for refresh operations, instead of using the solid.ini default value. The possible values are

1 = READ COMMITTED

2 = REPEATABLE READ

Default is the same as SQL.IsolationLevel

RW

Master

This parameter defines the number of rows after which the read level is released in the master, if the used isolation level is READ COMMITTED. With other isolation levels, the read level is kept for the full time of the refresh operation. The read level denotes a snapshot-consistent version of the data in the whole database. By releasing the read level, you avoid keeping too much data in main memory during the refresh operation.

See also the Srv.RemoteStartTasks parameter.

1000

RW

Master

This parameter defines the amount of system processing capacity (as percentage) that is used to perform a refresh in the replica. By default, full capacity is used.

If you want to reserve some capacity for local processing in parallel with refresh, set this parameter to a lower value.

Possible values are between 0 and 100. Value 0 means that the feature is disabled and full processor capacity is used.

If this parameter is set to 0 or 100, you can set the system processing capacity with the SET SYNC parameter SYS_SYNC_REPLICA_REFRESH_LOAD.

100

RW

Replica