The content of the synchronization process is fully definable by the application designer. This way the application needs are best considered. Similarly, the synchronization process can be tailored to efficiently utilize the capacity and characteristics of the currently available infrastructure. solidDB Advanced Replication architecture itself does not provide any default process but it does not set any limitations on the contents of a custom-built process either.

The maximum size of a single synchronization message can be set by database level system parameters. The SYS_R_MAXBYTES_OUT parameter sets the maximum length of messages sent from a replica database to the master, while SYS_R_MAXBYTES_IN parameter sets the maximum length of messages that can be received to a replica database from the master database, see Parameters on replica.

The default message length for both parameters is 2GB. Valid values for both parameters are between 0 - 2 GB. If 0 is specified, then 2GB is used.

To set these parameters, use the SET SYNC PARAMETER statement in the replica database, see SET SYNC PARAMETER.

For example:

Note that for both parameters, an error message is generated if the message is longer than expected.

By default, all data of a publication refresh is written to the replica database in a single transaction. If the reply of a sent message contains refreshes of large publications, you can adjust the number of rows that are committed in one transaction using the COMMITBLOCK option of the MESSAGE FORWARD or MESSAGE GET REPLY statements, see MESSAGE FORWARD or MESSAGE GET REPLY.

This allows you to divide a single large transaction into multiple smaller transactions.

For example:

Setting the maximum size of the commitblock can improve performance of the replica databases. However, data integrity cannot be guaranteed if the data is transmitted in more than one transaction and active users on the replica are changing data at the same time. Therefore, it is recommended that you disconnect all online users from the replica database when you use the COMMITBLOCK option.