ADO.NET Provider for Cassandra

Build 24.0.9060

ConsistencyLevel

The consistency level determines how many of the replicas of the data you are interacting with need to respond for the query to be considered a success.

Possible Values

ONE, TWO, THREE, QUORUM, ALL, LOCAL_QUORUM, EACH_QUORUM, SERIAL, LOCAL_SERIAL, LOCAL_ONE, ANY

Data Type

string

Default Value

"ONE"

Remarks

The consistency level determines how many of the replicas of the data you are interacting with need to respond for the query to be considered a success. You need to specify the appropriate replicas in the Server property.

Below are the possible values:

  • ANY: At least one replica must return success in a write operation. This property guarantees that a write never fails; this consistency level delivers the lowest consistency and highest availability.
  • ALL: All replicas must respond. This property provides the highest consistency and the lowest availability.
  • ONE: At least one replica must respond. This is the default and suitable for most users, who do not typically require high consistency.
  • TWO: At least two replicas must respond.
  • THREE: At least three replicas must respond.
  • QUORUM: A quorum of nodes must respond. The QUORUM properties provide high consistency with some failure tolerance.
  • EACH_QUORUM: A quorum of nodes must respond where a quorum is calculated for each data center. This setting maintains consistency in each data center.
  • SERIAL: A quorum of replicas performs a consensus algorithm to allow lightweight transactions.
  • LOCAL_ONE: At least one replica in the local data center must respond.
  • LOCAL_SERIAL: The consensus algorithm is calculated for the local data center.
  • LOCAL_QUORUM: A quorum of nodes must respond where the quorum is calculated for the local data center.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060