This command is not supported in MemSQL Cloud.
Pause replicating a database.
PAUSE REPLICATING db_name
db_name- name of a MemSQL database.
PAUSE REPLICATINGto suspend the database replication process initiated by REPLICATE DATABASE.
- Once replication is paused, the slave no longer requests new log records from the master database. The connection between the slave and the master is closed. The slave 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 .
This MemSQL feature is only available in MemSQL Enterprise Edition. MemSQL Enterprise Edition includes 24x7 support and several enterprise-only features for critical deployments. For more information about MemSQL Community and MemSQL Enterprise, see the MemSQL Editions page.
memsql> PAUSE REPLICATING ExampleDatabase; Query OK, 1 row affected (0.03 sec)