# ALTER DATABASE

The `ALTER DATABASE` command specifies if an existing database should begin using [synchronous or asynchronous replication](https://docs.singlestore.com/db/v9.1/user-and-cluster-administration/high-availability-and-disaster-recovery/replication-and-durability-concepts.md).

## 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. Refer to [COMMIT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/commit.md) for more information.
* This command can be run on the master aggregator node, or a child aggregator node (see [Node Requirements for SingleStore Commands](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands.md) ).

## Example

The following example specifies that the database `database_name` should begin using synchronous replication.

```sql
ALTER DATABASE database_name SET SYNC REPLICATION;

```

**Related Topics**

* [CREATE DATABASE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/create-database.md)

***

Modified at: June 11, 2026

Source: [/db/v9.1/reference/sql-reference/data-definition-language-ddl/alter-database/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/alter-database/)

(An index of the documentation is available at /llms.txt)