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.

• 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 set as the new master aggregator. Then, run CONTINUE REPLICATING on the master aggregator.

Example

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

Was this Article Helpful?

Thanks For Your Feedback!