You can set a property on a StreamBase Query Table indicating that the table is to be replicated automatically by the server. When you enable table replication on a table, StreamBase automatically creates a container and runs it on the specified second server of a table replication pair. StreamBase can replicate any number of tables to a single container.
To enable table replication, you must edit the <table-replication> section of the server configuration file
for each server in the pair, specifying the other server in the pair on which the
table replication container is to be created. Thus, there are two tasks required:
|
Specify Enable table replication at design time in the Properties view for a Query Table data construct. |
|
|
Specify the servers in the high-availability pair by editing the value of
the REPL_OTHER_SERVER_PORT attribute in the You can also specify optional parameters, such as the frequency of checks on the state of the servers, the number of changes to include in batch updates of the table,and the parameter for automatically reconnecting.
The configuration file excerpt on the right is based on the |
<table-replication>
<param name="HB_OTHER_SERVER"
value="name_of_other_server"/>
<param name="REPL_OTHER_SERVER_PORT"
value="12345"/>
<param name="REPL_CHECK_INTERVAL" value="1"/>
<param name="REPL_BATCH_SIZE" value="100"/>
<param name="REPL_RECONNECT_INTERVAL"
value="250"/>
</table-replication>
|
-
<high-availability> section of the server configuration file
-
Properties: Table Settings Tab of the Query Table Properties view