Outdated Version

You are viewing an older version of this section. View current production version.

CONTINUE REPLICATING

Info

MemSQL Helios 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)