SingleStore DB

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 can be run on the master aggregator node, or a child aggregator node (see Node Requirements for SingleStore DB 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