SingleStore DB

STOP REPLICATING

Stops replicating a database.

Syntax
STOP REPLICATING db_name
Remarks
  • This is used in inter cluster replication, when the primary database is down for some reason, and you do not want the secondary database to continue replicating from the primary, you run STOP REPLICATING on the secondary.

  • When replication stops, the secondary database is promoted to a primary database and it is fully available for both reads and writes.

  • This command cannot be reversed.

  • 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)