Pausing and Stopping Replication

SingleStore allows you to pause and resume online replication with single commands.

PAUSE REPLICATING db_name;

Query OK, 1 row affected (0.06 sec)

CONTINUE REPLICATING db_name;

Query OK, 1 row affected (0.96 sec)

PAUSE REPLICATING temporarily pauses replication but maintains the replication relationship between master and secondary databases. To begin replicating from a different primary cluster, you must start a new REPLICATE DATABASE process.

To completely stop a replication see STOP REPLICATING. This command is irreversible.