Flush database data (2024)

To delete the data in a database without deleting the database, you can use Redis CLI to flush it from the database. You can also use Redis CLI, the admin console, and the Redis Software REST API to flush data from Active-Active databases.

To delete the data in a database without deleting the database configuration,you can flush the data from the database.

You can use the Cluster Manager UI to flush data from Active-Active databases.

Warning:

The flush command deletes ALL in-memory and persistence data in the database.We recommend that you back up your database before you flush the data.

Flush data from a database

From the command line, you can flush a database with the redis-cli command or with your favorite Redis client.

To flush data from a database with the redis-cli, run:

redis-cli -h <hostname> -p <portnumber> -a <password> flushall

Example:

redis-cli -h redis-12345.cluster.local -p 9443 -a xyz flushall

Flush data from an Active-Active database

When you flush an Active-Active database (formerly known as CRDB), all of the replicas flush their data at the same time.

To flush data from an Active-Active database:

Cluster Manager UI
1. If you are using the new Cluster Manager UI, switch to the legacy admin console.
2. Go to database and select the Active-Active database that you want to flush.
3. Go to configuration and click Flush at the bottom of the page.
4. Enter the name of the Active-Active database to confirm that you want to flush the data.
  See Also
  Flushing the database cache

Command line

To find the ID of the Active-Active database, run:

crdb-cli crdb list

For example:

$ crdb-cli crdb listCRDB-GUID NAME REPL-ID CLUSTER-FQDNa16fe643-4a7b-4380-a5b2-96109d2e8bca crdb1 1 cluster1.locala16fe643-4a7b-4380-a5b2-96109d2e8bca crdb1 2 cluster2.locala16fe643-4a7b-4380-a5b2-96109d2e8bca crdb1 3 cluster3.local

To flush the Active-Active database, run:

crdb-cli crdb flush --crdb-guid <CRDB-GUID>

The command output contains the task ID of the flush task, for example:

$ crdb-cli crdb flush --crdb-guid a16fe643-4a7b-4380-a5b2-96109d2e8bcaTask 63239280-d060-4639-9bba-fc6a242c19fc created---> Status changed: queued -> started

To check the status of the flush task, run:

crdb-cli task status --task-id <Task-ID>

For example:

$ crdb-cli task status --task-id 63239280-d060-4639-9bba-fc6a242c19fcTask-ID: 63239280-d060-4639-9bba-fc6a242c19fcCRDB-GUID: -Status: finished

REST API
1. To find the ID of the Active-Active database, use GET /v1/crdbs:
```
GET https://[host][:port]/v1/crdbs
```
2. To flush the Active-Active database, use PUT /v1/crdbs/{guid}/flush:
```
PUT https://[host][:port]/v1/crdbs/<guid>/flush
```
  The command output contains the task ID of the flush task.
3. To check the status of the flush task, use GET /v1/crdb_tasks:
```
GET https://[host][:port]/v1/crdb_tasks/<task-id>
```