Cassandra connection properties

The JMX (Java Management Extensions) port of a cluster. In Cassandra versions 0.8 and higher, the JMX port is 7199.

The JMX (Java Management Extensions) username, if authentication is enabled.

The JMX (Java Management Extensions) password, if authentication is enabled.

The JMX (Java Management Extensions) operations pool size. Default: 4.

A Cassandra seed node is used to determine the ring topology and obtain gossip information about the nodes in a cluster. This list should be the same comma-delimited list of seed nodes as the one configured for the DataStax Enterprise cluster by the seeds property in the cassandra.yaml configuration file. The default value is localhost.

The CQL port configured for a cluster. Default: 9042.

The location of the cassandra.yaml configuration file. If install_location is specified, but conf_location is not, then conf_location is assumed to be install_location/conf/cassandra.yaml. If conf_location is specified, it must be the absolute path to the Cassandra configuration file on all nodes. These settings are cluster-wide and require that the specified locations be correct for every node.

The directory in which Cassandra is installed. If install_location is not specified, OpsCenter looks in the package-specific installation locations. For a tarball installation of DataStax Enterprise, the install_location is dse_install_location/resources/cassandra.

The directory in which DSE logs reside on a node. The default location is /var/log/cassandra. This value will auto-populate the cassandra_log_location property for each agent.

When specified, OpsCenter will prefer using connections to the specified datacenter.

If using local_dc_pref, this option specifies how many remote dc connections may be used as a fallback. Default: 1.

Sets the timeout, in seconds, of a native connection from OpsCenter to Cassandra. The default value is 6.0.

The timeout in milliseconds for a host to be considered unresponsive during CQL read operations, such as querying for data. The timeout value should be set higher than the timeout settings used on the Cassandra side (read_request_timeout_in_ms in cassandra.yaml). Default: Embedded Cassandra Java driver default value.

The interface for native connections to use.

The number of connections to build for the connection pool. The default value is 5.

The username used to connect to Cassandra if authentication is enabled.

The password used to connect to Cassandra if authentication is enabled.

Specifies whether to send the Cassandra RPC IP to DataStax Agents. The default value is True.

The SSL keystore location for OpsCenter to use to connect to Cassandra directly.

The SSL keystore password for OpsCenter to use to connect to Cassandra directly.

The SSL truststore location for OpsCenter to use to connect to Cassandra directly.

The SSL truststore password for OpsCenter to use to connect to Cassandra directly.

The number of nodes in the cluster before OpsCenter will switch from running a backup immediately upon receiving a request to scheduling the backup to run after the next full minute, plus any time set in snapshot_wait. The default value is 10. If there are less than 10 nodes in the cluster, then OpsCenter will tell all nodes to take a snapshot as soon as it is requested. If there are more than 10 nodes, OpsCenter will tell all nodes to take a snapshot at the current time rounded to the next minute, plus snapshot_wait seconds.

The number of seconds to wait between retry attempts when connecting to Cassandra after restarting a node. Default: 5.

The maximum number of connection retry attempts after restarting a Cassandra node. Default: 25.

A rolling restart will be cancelled if the number of errors during the restart reaches this number. This helps prevent having too many nodes down in a cluster if something catastrophic happens during a rolling restart. Default: 1.

The time in milliseconds to wait for schema refreshes after issuing a schema change command. Because this option is intended for use with multiple schema creators that do not apply to opscenterd, the interval should remain at its default of 0.

During a rolling restart, the time in seconds OpsCenter waits after sending the command to stop Cassandra before sending the command to start it again. The default is 30 seconds.

Configure when using a separate OpsCenter storage cluster. For OpsCenter storage clusters, the agents only communicate with the listed seed hosts, consequently ensuring that a sufficient number of storage cluster nodes are placed in the comma-delimited list and that the list is reviewed as nodes are added and removed from the storage cluster.

Configure when using a different cluster for OpsCenter storage. The CQL port configured for your cluster, the default port is 9042.

To reliably determine cluster information, OpsCenter can require a minimum of 2 nodes to connect to. If you specified a single value for seed_hosts, OpsCenter selects a second node in the cluster to fulfill this requirement. You can specify local_dc_pref as a datacenter name to constrain OpsCenter to use that datacenter to pick the second node.

Configure when using a different cluster for OpsCenter storage. If using local_dc_pref, this option specified how many remote dc connections may be used as a fallback, the default value is 1.

Configure when using a different cluster for OpsCenter storage. Sets the timeout, in seconds, of a native connection from OpsCenter to Cassandra. The default value is 6.0.

The timeout in milliseconds for a host to be considered unresponsive during CQL read operations, such as querying for data. The timeout value should be set higher than the timeout settings used on the Cassandra side (read_request_timeout_in_ms in cassandra.yaml). Default: Embedded Cassandra Java driver default value.

Configure when using a different cluster for OpsCenter storage. The interface used for native connections.

Configure when using a different cluster for OpsCenter storage. The number of connections to build for the connection pool. The default value is 5.

Configure when using a different cluster for OpsCenter storage. The username used to connect to Cassandra if authentication is enabled.

Configure when using a different cluster for OpsCenter storage. The password used to connect to Cassandra if authentication is enabled.

Configure when using a different cluster for OpsCenter storage. Specifies whether to send the Cassandra RPC IP to DataStax Agents. The default value is True.

The name of the keyspace used for OpsCenter data. The keyspace name must be unique for each managed cluster.

The SSL keystore location for OpsCenter to use to connect to Cassandra directly.

The SSL keystore password for OpsCenter to use to connect to Cassandra directly.

The SSL truststore location for OpsCenter to use to connect to Cassandra directly.

The SSL truststore password for OpsCenter to use to connect to Cassandra directly.

The time in milliseconds to wait for schema refreshes after issuing a schema change command. Because this option is intended for use with multiple schema creators that do not apply to opscenterd, the interval should remain at its default of 0.

The frequency in seconds to check Cassandra for a Cassandra API update. The default value is 3600 (1 hour).

The interval in seconds OpsCenter waits to poll the nodes in a cluster. The default value is 30.

The frequency in seconds to poll the job tracker. The default value is 5.

The frequency in seconds to check for a schema update. The default value is 60.

The frequency in seconds to push node information to the UI. The default value is 60.

The number of data points to cache for cluster metrics. The default value is 50.

The number of metrics to cache for cluster metrics. The default value is 1000.

The port used by DataStax Agents for HTTP traffic. The default port is 61621.

The timeout, in seconds, for an HTTP call to the agent. The default value is 10.

The SSL keystore location for DataStax Agents to use to connect to CQL on the monitored cluster.

The SSL keystore password for DataStax Agents to use to connect to CQL on the monitored cluster.

The SSL truststore location for DataStax Agents to use for trusted certs.

The SSL truststore password for DataStax Agents to use for trusted certs.

The SSL keystore location for DataStax Agents to use to connect to CQL on the storage cluster.

The SSL keystore password for DataStax Agents to use to connect to CQL on the storage cluster.

The SSL truststore location for DataStax Agents to use for trusted certs on the storage cluster.

The SSL truststore password for DataStax Agents to use for trusted certs on the storage cluster.

The IP address to obtain ec2 metadata such as instance id. The default IP address is 169.254.169.254.

The number of concurrent HTTP requests OpsCenter will make to DataStax Agents for most HTTP operations. The default value is 10.

The number of concurrent DataStax Agents OpsCenter will contact upon start-up or when adding a new cluster. The default value is 10.

The number of concurrent get snapshot info requests. The default value is 1.

See [cassandra] snapshot_threshold

The S3 region region to connect to for remote backup/restore. The default value is us-west-1.

This path specifies the directory where commit logs archived to by cassandra. From there the commit logs are sent to the configured destinations and the backup_storage_dir.

This path specifies the directory where commit logs are stored and retained on each node. This property must be set prior to enabling commit log archiving.

The frequency in seconds that a restore reports progress back to OpsCenter. The default value is automatically calculated based on cluster size. To optimize performance, larger clusters have a longer threshold in which restore progress is sent to the UI. Configure this property accordingly for more or less frequent updates during a restore.

The maximum time in seconds to attempt downloading a diagnostic tarball from an agent. This value might need to be increased on slower machines or for multi-instance clusters. Default value: 600.

A list of keyspaces to not collect metrics for, separated by commas. The default value is system, system_traces, system_auth, dse_auth, OpsCenter, system_views and system_virtual_schema.

A list of tables to not collect metrics for, separated by commas. Each entry should be of the form "ks.cf". For example: metrics_ignored_column_families = system.NodeInfo, system.Schema, Keyspace1.Standard1

A list of solr cores to not collect metrics for, separated by commas. Each entry should be of the form "ks.cf". For example: metrics_ignored_solr_cores = Keyspace1.Standard1, solr.wiki.

Sets the time in seconds to expire 1 minute data points. The default value is 604800 (7 days).

Sets the time in seconds to expire 5 minute data points. The default value is 2419200 (28 days).

Sets the time in seconds to expire 2 hour data points. The default value is 31536000 (365 days).

Sets the time to expire 24 hour data points. The default value is 0, or never.

Specifies whether DataStax Agents should collect Cassandra metrics. The default value is True.

Specifies whether OpsCenter events should be recorded in the event store. The default value is True.

Port at which the Spark master UI is exposed. Default: 7080.

Override for the computed Spark proxy port.

The default Kerberos service name (Example: cassandra).

The default Kerberos hostname.

The default Kerberos client principal (Example: cassandra@realm).

The default Kerberos client user.

The OpsCenter client principal in Kerberos (Example: user@realm).

Full path to the keytab containing keys for opscenterd_client_principal on the OpsCenter machine.

The DataStax agent client principal in Kerberos (Example: user@realm).

Full path to the keytab containing keys for agent_client_principal on the DataStax agent machine.

Whether to output debug messages during Kerberos connection attempts from OpsCenter.

The number of request updates OpsCenter will push out at once. The default value is 100. This is used to avoid overloading the browser.

How often OpsCenter will push out updates to requests. The default value is 3 seconds. This is used to avoid overloading the browser.

How often OpsCenter will push out alert updates. The default value is 1 second. This is used to avoid overloading the browser.

How long in seconds OpsCenter will store the results of Best Practice service runs. The default value is 2,419,200 seconds, or 4 weeks.

Comma separated keyspace.tablename(s) for which ALLOW FILTERING check rule needs to be ignored / suppressed.

The multiplier for the query range needed to produce forecasts. The default multiplier is 3.

Minimum percent of past data required to forecast. The default value is 0.5.

The number of DataStax Agents on which OpsCenter will concurrently start the restore process. The default value is 20.

How long OpsCenter will sleep between batches of starting the restore process, set in restore_init_throttle. The default value is 5 seconds.

The percentage of the cluster that can fail to respond before a remote destination restore action fails. Default: 50.

Enable using the AWS CLI instead of the AWS SDK when bulk loading backups to Amazon S3 locations. Default: False.

When using azcopy to transfer files to an azure destination, integer value to pass as parallel-level. The parameter wont be used if set to 0. Default: 0

Controls whether to skip the verification check using file listing after upload for backup destinations. Default: false.

Setting graphite_host enables the forwarding of metrics to a graphite server at the given address. Leaving the graphite_host blank disables forwarding metrics to the graphite server.

Port for graphite’s plaintext protocol.

A prefix to insert metrics under.

Enable or disable storing metrics in a monitored or a separate storage DSE cluster. Metrics are stored in a DSE monitored or storage cluster by default. Default: False.

The [labs] use_s3_cli config option has been deprecated because of promotion to production rather than labs status. Please set the use_s3_cli config option in the [backups] section.

Enable or disable the ability to choose OpenStack Swift as a destination for backups

Allow for a delay between upload and sync status check with OpenStack Swift destination

Labs feature. Controls whether to skip the file difference check after uploading files to a Swift destination.

Per-node specification for the Kerberos hostname of the service (DSE). A list of IP and hostname pairs. For example 192.168.1.101 = cassandra01.example.com.

Per-node specification of the Kerberos service name. A list of IP, hostname pairs. For example 192.168.1.101 = cassandra.

Per-client specification of the Kerberos principal to use. A list of IP, hostname pairs. For example:

Display name used by OpsCenter to signify this cluster.