Pausing and Stopping Replication
SingleStoreDB 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.