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.

Last modified: July 5, 2022

Was this article helpful?