Resume replicating the database after pausing via PAUSE REPLICATING.
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]
- The long form of
CONTINUE REPLICATINGcan be used to re-point a replica from one master to another.
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.
memsql> CONTINUE REPLICATING ExampleDatabase; Query OK, 1 row affected (0.26 sec)