Back
Outdated Version

You are viewing an older version of this section. View current production version.

STOP REPLICATING

Stop replicating the database.

STOP REPLICATING db_name

Notes

  • Once replication is stopped, the secondary database is no longer a replica. It is fully available for both reads and writes.
  • However, replication can be resumed only by using CONTINUE_REPLICATING with the FORCE option.
  • This command can be run on any MemSQL node (see Node Requirements for MemSQL Commands).
Info

This MemSQL feature is only available in MemSQL Enterprise Edition. MemSQL Enterprise Edition includes 24x7 support and several enterprise-only features for critical deployments. For more information about MemSQL Community and MemSQL Enterprise, see the MemSQL Editions page.

Example

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

Questions?

Ask the Community, find solutions in the Troubleshooting Overview, get Self-Paced Training or learn more about our Support Plans.