# STOP REPLICATING

Stops replicating a database, and promotes the secondary database to the primary 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.
* If the previous primary database had running pipelines, these pipelines will continue to run in the promoted database.
* This command causes implicit commits. Refer to [COMMIT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/commit.md) for more information.
* This command cannot be reversed.
* The remarks in the [REPLICATE DATABASE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/operational-commands/replicate-database.md) topic discuss the replication and durability modes that a database uses after it has stopped replicating.
* Refer to the [Permissions Matrix](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md) for the required permissions.

## Example

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

```

***

Modified at: January 9, 2023

Source: [/db/v9.1/reference/sql-reference/operational-commands/stop-replicating/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/operational-commands/stop-replicating/)

(An index of the documentation is available at /llms.txt)