Apache Cassandra Advanced Properties

Following tables list the advanced properties that you can add to the store.xml file for Apache Cassandra. The table lists the property key names which are unique for each property and data type. You can provide the UI display name and default value as you want in store.xml, for example:

<property name="query.opt.consistency.level" displayName="Query Consistency Level" type="String" default="LOCAL_ONE" mandatory="false" />

Connection Properties

Property Name Type Description
clusterName String An optional name for the created cluster. If not provided, a default name is created. It isused for JMX reporting of metrics.
compressionProtocol String

Configures the compression protocol to use for the transport. The values are:

  • NONE
  • LZ4
  • SNAPPY
reconnectionPolicy String

Configures the reconnection policy to use for the new cluster. The values are:

  • Exponential
  • Constant
constantDelayMs Integer The constant delay in milliseconds used by the Constant reconnection policy.
baseDelayMs Integer The base delay in milliseconds for the Exponential reconnection policy.
maxDelayMs Integer The maximum delay in milliseconds between reconnection attempts for the Exponential reconnection policy.
retryPolicy String

Configures the retry policy to use for the new cluster. The values are:

  • DEFAULT
  • FALLTHROUGH
loggingRetryPolicy Boolean

Provides option to enable a retry policy that wraps another policy and logs the decision made by the wrapped policy.

This policy only logs RETRY and IGNORE decisions.
enableMetrics Boolean Provides option to enable or disable the metrics collection for the created cluster.
useJMX Boolean Provides option to enable or disable JMX reporting of the metrics.

QueryOptions

The following properties provide configurations related to defaults for individual queries.

Property Name Type Description
query.opt.consistency.
level
String Configures the consistency level of the query.
query.opt.idempotence Boolean Provides option to make a query idempotent.
query.opt.fetchSize Integer Fetch size for query
query.opt.maxPending
RefreshNodeListRequests
Integer Maximum number of the node list refresh requests that the control connection can accumulate before executing them.
query.opt.maxPending
RefreshNodeRequests
Integer The maximum number of node refresh requests that the control connection can accumulate before executing them
query.opt.maxPending
RefreshSchemaRequests
Integer The maximum number of schema refresh requests that the control connection can accumulate before executing them.
query.opt.prepareOnAll
Hosts
Boolean Provides option to enable the driver to prepare statements on all hosts in the cluster.
query.opt.refreshNode
IntervalMillis
Integer The default window size in milliseconds used to debounce node refresh requests
query.opt.refreshNode
ListIntervalMillis
Integer The default window size in milliseconds used to debounce node list refresh requests
query.opt.refreshSchema
IntervalMillis
Integer The default window size in milliseconds used to debounce schema refresh requests.
query.opt.rePrepareOnUp Boolean Provides option to enable the driver to re-prepare all cached prepared statements on a host when it marks it to be backed up.
query.opt.serial
consistency.level
String Configures the serial consistency level for the query.

Pooling Options

The following properties provides configurations related to connection pooling.

Property Name Type Description
pooling.opt.heartbeat
Interval
Integer The heart beat interval after which a message is sent on an idle connection to make sure it's still alive.
pooling.opt.idleTimeout Integer The timeout before an idle connection is removed.
pooling.opt.poolTimeout Integer The timeout when trying to acquire a connection from a host's pool.
pooling.opt.remote.core
Connections
Integer The core number of connections for remote host.
pooling.opt.remote.max
Connections
Integer The maximum number of connections for remote host.
pooling.opt.remote.max
RequestsPerConnection
Integer The maximum number of requests per connection for remote host.
pooling.opt.remote.new
ConnectionThreshold
Integer The threshold that triggers the creation of a new connection to a remote host.
pooling.opt.local.core
Connections
Integer The core number of connections for remote host.
pooling.opt.local.max
Connections
Integer The maximum number of connections for remote host.
pooling.opt.local.max
RequestsPerConnection
Integer The maximum number of requests per connection for local host.
pooling.opt.local.new
ConnectionThreshold
Integer The threshold that triggers the creation of a new connection to a local host.