PAUSE REPLICATING

Pause replicating a database.

Syntax

PAUSE REPLICATING db_name

Remarks

  • db_name - name of a MemSQL database.
  • Run PAUSE REPLICATING to 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 paused state (see Database States).
  • You can resume replication by running CONTINUE REPLICATING .

Example

memsql> PAUSE REPLICATING ExampleDatabase;
Query OK, 1 row affected (0.03 sec)

Related Topics

Was this article useful?