On this page
Pause replicating a database.
PAUSE REPLICATING db_name
db_- name of a SingleStoreDB database.
This command causes implicit commits.
See COMMIT for more information.
PAUSE REPLICATINGto suspend the database replication process initiated by REPLICATE DATABASE.
Once replication is paused, the replica no longer requests new log records from the primary database.
The connection between the replica and the master is closed. The secondary database continues to be available only for reads, and not for writes.
While replication is paused, the database is in the
replication pausedstate (see Database States).
You can resume replication by running CONTINUE REPLICATING .
Refer to the Permission Matrix for the required permission.
PAUSE REPLICATING ExampleDatabase;Query OK, 1 row affected (0.03 sec)
Last modified: January 9, 2023