ALTER DATABASE
Specify if an existing database should begin using synchronous or asynchronous replication.
Syntax
ALTER DATABASE <database_name> { SET | WITH } { SYNC | ASYNC } REPLICATION;
Remarks
<database_name>
is the name of the existing database for which you want to specify the replication setting.This command causes implicit commits. See COMMIT for more information.
This command can be run on the master aggregator node, or a child aggregator node (see Node Requirements for SingleStoreDB Commands ).
Example
The following example specifies that the database database_name
should begin using synchronous replication.
ALTER DATABASE database_name SET SYNC REPLICATION;
Related Topics