You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

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 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 paused state (see Database States).
  • You can resume replication by running CONTINUE REPLICATING .
Info

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 Developer and MemSQL Enterprise, see the MemSQL Editions page.

Example

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

Related Topics