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

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)