Outdated Version

You are viewing an older version of this section. View current production version.

STOP REPLICATING

Stops replicating a database.

Syntax

STOP REPLICATING db_name

Remarks

  • When replication stops, the database is no longer a secondary database and is promoted to a primary database; it is fully available for both reads and writes.
  • The remarks in the REPLICATE DATABASE topic discuss the replication and durability modes that a database uses after it has stopped replicating.

Example

memsql> STOP REPLICATING ExampleDatabase;
Query OK, 1 row affected (0.04 sec)