CONTINUE REPLICATING

Resume replicating the database after pausing via PAUSE REPLICATING.

Syntax

To resume replication from the master aggregator in the Disaster Recovery (DR) secondary cluster, use the following syntax:

CONTINUE REPLICATING <database_name>;

Remarks

  • CONTINUE REPLICATING can only be used to resume replication from the primary database on the remote host that was specified when REPLICATE DATABASE was originally run.

  • This command causes implicit commits. Refer to COMMIT for more information.

  • If the master aggregator fails on the DR secondary cluster, you can either restart the master aggregator node successfully, or pick a child aggregator to promote to master. Then, run CONTINUE REPLICATING on the master aggregator.

  • Refer to the Permission Matrix for the required permission.

Example

CONTINUE REPLICATING ExampleDatabase;
Query OK, 1 row affected (0.26 sec)

Last modified: January 9, 2023

Was this article helpful?