Replication can now be enabled and configured in the SQL layer
using pragmas. The pragmas
replication_local_site
,
replication_initial_master
, and
replication_remote_site
can be used to configure
the replication group. Note that when the BDB SQL replicated
application is initially started, a specific master site must be
explicitly designated. After configuring the replication group,
start replication using PRAGMA replication=ON
.
To display replication statistics in the dbsql shell, use:
dbsql> .stat :rep
For more details on the replication pragmas see Replication PRAGMAs in the Berkeley DB Getting Started with the SQL APIs guide.
PRAGMA replication=ON|OFF
PRAGMA replication_initial_master=ON|OFF
PRAGMA replication_local_site="hostname:port"
PRAGMA replication_remote_site="hostname:port"
PRAGMA replication_remove_site="host:port"
PRAGMA replication_verbose_output=ON|OFF
PRAGMA replication_verbose_file=filename