DROP CLUSTER REPLICA removes an existing replica for the specified cluster. To remove all active replicas for a cluster, use the DROP CLUSTER command.


DROP CLUSTER REPLICA IF EXISTS cluster_name.replica_name
Field Use
IF EXISTS Do not return an error if the specified cluster replica does not exist.
cluster_name The cluster you want to remove a replica from. For available clusters, see SHOW CLUSTERS.
replica_name The cluster replica you want to drop. For available cluster replicas, see SHOW CLUSTER REPLICAS.


SHOW CLUSTER REPLICAS WHERE cluster = 'auction_house';
    cluster    | replica
 auction_house | bigger
DROP CLUSTER REPLICA auction_house.bigger;
Back to top ↑