SingleStore DB

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
STOP REPLICATING ExampleDatabase;
Query OK, 1 row affected (0.04 sec)