SingleStore DB

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.

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

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