You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

CONTINUE REPLICATING

Resume replicating the database after pausing via PAUSE REPLICATING.

Syntax

Same Master: To resume replication from the same master, use the following syntax:

CONTINUE REPLICATING db_name

New Master: To resume replication from a new master, use the following syntax:

CONTINUE REPLICATING db_name FROM master_user[:'master_password']@master_host[:master_port][/master_db_name]

Remarks

  • The long form of CONTINUE REPLICATING can be used to re-point a replica from one master to another.
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 Developer and MemSQL Enterprise, see the MemSQL Editions page.

Example

memsql> CONTINUE REPLICATING ExampleDatabase;
Query OK, 1 row affected (0.26 sec)