Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

STOP REPLICATING

Info

SingleStore Managed Service does not support this command.

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)