STOP REPLICATING

On this page

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 for more information.
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.
Refer to the Permission Matrix for the required permission.

Example

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

Last modified: January 9, 2023

Was this article helpful?

Verification instructions

Note: You must install cosign to verify the authenticity of the SingleStore file.

Use the following steps to verify the authenticity of singlestoredb-server, singlestoredb-toolbox, singlestoredb-studio, and singlestore-client SingleStore files that have been downloaded.

You may perform the following steps on any computer that can run cosign, such as the main deployment host of the cluster.

(Optional) Run the following command to view the associated signature files.
Shell
```
curl undefined
```
Download the signature file from the SingleStore release server.
- Option 1: Click the Download Signature button next to the SingleStore file.
- Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.
- Option 3: Run the following command to download the signature file.
  Shell
```
curl -O undefined
```

After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.

Shell

echo -n undefined |
    cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC \
      --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker \
      --bundle undefined \
      --new-bundle-format -

Verified OK