ALTER DATABASE
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
Specify if an existing database should begin using synchronous or asynchronous replication.
Syntax
ALTER DATABASE <database_name> { SET | WITH } { SYNC | ASYNC } REPLICATION;
Remarks
-
<database_
is the name of the existing database for which you want to specify the replication setting.name> -
This command causes implicit commits.
Refer to COMMIT for more information. -
This command can be run on the master aggregator node, or a child aggregator node (see Node Requirements for SingleStore Commands ).
Example
The following example specifies that the database database_
should begin using synchronous replication.
ALTER DATABASE database_name SET SYNC REPLICATION;
Related Topics
Last modified: July 25, 2022