Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

CONTINUE REPLICATING

Info

SingleStore Managed Service does not support this command.

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)