Replication of Query Tables

Table Replication Configuration

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 <table-replication> section of the configuration file.

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 orders.sbconf file in the table-repl sample. See Table Replication.

<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>