Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

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