Pausing and Stopping Replication
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
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.REPLICATE DATABASE
process.
To completely stop a replication see STOP REPLICATING.
Last modified: July 5, 2022