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

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)