VeloDB Cloud
SQL Manual
SQL Statements
Database Administration
ADMIN-SET-REPLICA-STATUS

ADMIN-SET-REPLICA-STATUS

Name

ADMIN SET REPLICA STATUS

Description

This statement is used to set the state of the specified replica.

This command is currently only used to manually set the status of certain replicas to BAD, DROP or OK, allowing the system to automatically repair these replicas

grammar:

ADMIN SET REPLICA STATUS
        PROPERTIES ("key" = "value", ...);

The following properties are currently supported:

  1. "tablet_id": Required. Specify a Tablet Id.
  2. "backend_id": Required. Specify Backend Id.
  3. "status": Required. Specifies the state. Currently only "bad", "drop" or "ok" are supported

If the specified replica does not exist, or the status is already bad, it will be ignored.

Note:

A replica set to Bad, it will not be able to read or write. In addition, sometimes the setting may not working, when be report tablet ok, fe will auto change its status to ok. This operation may delete the replica immediately, so please operate with caution.

A replica set to Drop, it can still be read and written. A healthy replica will be added to other machines first, and then this replica will be deleted. Compared with setting Bad, setting Drop is safer.

Example

  1. Set the replica status of tablet 10003 on BE 10001 to bad.

    ADMIN SET REPLICA STATUS PROPERTIES("tablet_id" = "10003", "backend_id" = "10001", "status" = "bad");
  2. Set the replica status of tablet 10003 on BE 10001 to drop.

    ADMIN SET REPLICA STATUS PROPERTIES("tablet_id" = "10003", "backend_id" = "10001", "status" = "drop");
  3. Set the replica status of tablet 10003 on BE 10001 to ok.

ADMIN SET REPLICA STATUS PROPERTIES("tablet_id" = "10003", "backend_id" = "10001", "status" = "ok");

Keywords

ADMIN, SET, REPLICA, STATUS

Best Practice