Advanced replication data synchronization statements let you perform such tasks as registering replica databases, implementing access rights, and creating publications. In addition, you administer the advanced replication functionality using many of these statements. For example, you use MESSAGE commands to create and manage synchronization messages and DROP commands to remove synchronization objects such as publications and subscriptions.
The advanced replication statements are grouped into the following categories and their usage is described in this chapter. Refer to solidDB® SQL Guide for an alphabetical list of all SQL statements, including those used in advanced replication operations.
Database configuration statements
These following statements are used to set up and configure the databases used in an advanced replication system.
DROP MASTER
DROP REPLICA
REGISTER REPLICA
SET SYNC master_or_replica
SET SYNC master_or_replica
SET SYNC CONNECT
SET SYNC NODE
SET SYNC PARAMETER
SET SYNC USER
Security statements
These statements are used to set up security for multi-tier and multi-master environments.
ALTER USER SET MASTER
ALTER USER SET PUBLIC | PRIVATE
Publication statements
These statements are used to create and maintain publications, as well as refresh data from them.
ALTER TABLE SET { SYNCHISTORY | NOSYNCHISTORY } CREATE SYNC BOOKMARK CREATE PUBLICATION
DROP PUBLICATION
DROP PUBLICATION REGISTRATION
DROP SUBSCRIPTION
DROP SYNC BOOKMARK
EXPORT SUBSCRIPTION
GRANT REFRESH ON
IMPORT
MESSAGE APPEND REGISTER | UNREGISTER PUBLICATION
MESSAGE APPEND REFRESH
REVOKE REFRESH ON
REFRESH
Intelligent Transaction control
The functions and statements below are used to control the execution of Intelligent Transactions:
▪saving transactions in the replica database for propagation to the master,
▪defining bulletin board parameters (for example to control which transactions are propagated in a particular message),
▪setting parameters on the parameter bulletin board within a transaction, and
▪reading parameters from the parameter bulletin board.
GET_PARAM( )
PUT_PARAM( )
SAVE
SAVE PROPERTY
Message statements
The MESSAGE statements are used to create and execute the synchronization messages that are sent between a replica and the master database.