添加链接
link管理
链接快照平台
  • 输入网页链接,自动生成快照
  • 标签化管理网页链接

For the properties in each section, the parent setting has zero spaces. Each child entry requires at least two spaces. Adhere to the YAML syntax and retain the spacing. For example:

node_health_options:
    refresh_rate_ms: 60000
    uptime_ramp_up_period_seconds: 10800
    dropped_mutation_window_minutes: 30

Authentication options

DSE Authenticator supports multiple schemes for authentication at the same time in a DataStax Enterprise cluster. Additional authenticator configuration is required in cassandra.yaml .

# scheme_permissions: false # allow_digest_with_kerberos: true # plain_text_without_ssl: warn # transitional_mode: disabled
authentication_options

Configures DseAuthenticator to authenticate users when the authenticator option in cassandra.yaml is set to com.datastax.bdp.cassandra.auth.DseAuthenticator . Authenticators other than DseAuthenticator are not supported.

enabled

Enables user authentication.

true - The DseAuthenticator authenticates users.

false - The DseAuthenticator does not authenticate users and allows all connections.

scheme_permissions

Determines if roles need to have permission granted to them to use specific authentication schemes. These permissions can be granted only when the DseAuthorizer is used.

true - Use multiple schemes for authentication. To be assigned, every role requires permissions to a scheme.

false - Do not use multiple schemes for authentication. Prevents unintentional role assignment that might occur if user or group names overlap in the authentication service.

allow_digest_with_kerberos

Controls whether DIGEST-MD5 authentication is allowed with Kerberos. Kerberos uses DIGEST-MD5 to pass credentials between nodes and jobs. The DIGEST-MD5 mechanism is not associated directly with an authentication scheme.

true - Allow DIGEST-MD5 authentication with Kerberos. In analytics clusters, set to true to use Hadoop internode authentication with Hadoop and Spark jobs.

false - Do not allow DIGEST-MD5 authentication with Kerberos.

transitional_mode

Sets transitional mode for temporary use during authentication setup in an established environment.

Transitional mode allows access to the database using the anonymous role, which has all permissions except AUTHORIZE .

disabled - Disable transitional mode. All connections must provide valid credentials and map to a login-enabled role.

permissive - Only super users are authenticated and logged in. All other authentication attempts are logged in as the anonymous user.

normal - Allow all connections that provide credentials. Maps all authenticated users to their role, and maps all other connections to anonymous .

strict - Allow only authenticated connections that map to a login-enabled role OR connections that provide a blank username and password as anonymous .

When scheme_permissions is enabled, all roles must have permission to execute on the authentication scheme. See Binding a role to an authentication scheme .

Manages granting and revoking of roles.

internal - Manage granting and revoking of roles internally using the GRANT ROLE and REVOKE ROLE CQL statements. See Managing database access . Internal role management allows nesting roles for permission management.

ldap - Manage granting and revoking of roles using an external LDAP server configured using the ldap_options . To configure an LDAP scheme, complete the steps in Defining an LDAP scheme . Nesting roles for permission management is disabled.

Controls the granting and revoking of roles based on the users' authentication method. When this setting is used, it overrides the value from the mode setting. The parameters are:

internal - Specifies the method of role management when a user has authenticated using the internal authentication scheme.

ldap - Specifies the method of role management when a user has authenticated using an LDAP server.

kerberos - Specifies the method of role management when a user has authenticated using a Kerberos authentication scheme. For all parameters, the possible values are:

internal - grant and revoke roles internally using the GRANT ROLE and REVOKE ROLE CQL statements.

ldap - grant and revoke roles using an external LDAP server configured using the ldap_options .

stats

Set to true, to enable logging of DSE role creation and modification events in the dse_security.role_stats system table. All nodes must have the stats option enabled, and must be restarted for the functionality to take effect.

To query role events:

SELECT * FROM dse_security.role_stats;
 role  | created                         | password_changed
-------+---------------------------------+---------------------------------
 user1 | 2020-04-13 00:44:09.221000+0000 |                            null
 user2 | 2020-04-12 23:49:21.457000+0000 | 2020-04-12 23:49:21.457000+0000
(2 rows)

Default: commented out ( false )

keytab: resources/dse/conf/dse.keytab service_principal: dse/_HOST@REALM http_principal: HTTP/_HOST@REALM qop: auth

Used by the Tomcat application container to run DSE Search. The Tomcat web server uses the GSSAPI mechanism (SPNEGO) to negotiate the GSSAPI security mechanism (Kerberos). <REALM> is the name of your Kerberos realm. In the Kerberos principal, <REALM> must be uppercase.

Default: HTTP/_HOST@REALM

A comma-delimited list of Quality of Protection (QOP) values that clients and servers can use for each connection. The client can have multiple QOP values, while the server can have only a single QOP value.

auth - Authentication only.

auth-int - Authentication plus integrity protection for all transmitted data.

auth-conf - Authentication plus integrity protection and encryption of all transmitted data.

Encryption using auth-conf is separate and independent of whether encryption is done using SSL. If both auth-conf and SSL are enabled, the transmitted data is encrypted twice. DataStax recommends choosing only one method and using it for encryption and authentication.

LDAP options

Define LDAP options to authenticate users against an external LDAP service and/or for Role Management using LDAP group lookup. For details, read this section. Related: also refer to Defining an LDAP scheme .

Starting in DSE 6.8.2, LDAP servers can handle multiple, comma separated addresses, with or without a port. If the port is not provided, the ldap_options.server_port parameter is used by default. This way, there is no change in configuration for existing users who have LDAP configured.

A connection pool is created of each server separately. Once the connection is attempted, the best pool is chosen using a heuristic. DSE uses a circuit breaker to temporarily disable those servers that frequently fail to connect. Also, DSE tries to choose the pool that has the greatest number of idle connections.

Failover parameters are configured through system properties.

A new method was added in DSE 6.8.2 to the LDAP MBean to reset LDAP connectors - that is, close all connection pools and recreate them.

# user_search_base: # user_search_filter: (uid={0}) # user_memberof_attribute: memberof # extra_user_search_bases: # group_search_type: directory_search # group_search_base: # group_search_filter: (uniquemember={0}) # group_name_attribute: cn # extra_group_search_bases: # credentials_validity_in_ms: 0 # search_validity_in_seconds: 0 # connection_pool: # max_active: 8 # max_idle: 8

Microsoft Active Directory (AD) example, for both authentication and role management:

ldap_options:
    server_host: win2012ad_server.mycompany.lan
    server_port: 389
    search_dn: cn=lookup_user,cn=users,dc=win2012domain,dc=mycompany,dc=lan
    search_password: lookup_user_password
    use_ssl: false
    use_tls: false
    truststore_path:
    truststore_password:
    truststore_type: jks
    #group_search_type: directory_search
    group_search_type: memberof_search
    #group_search_base:
    #group_search_filter:
    group_name_attribute: cn
    user_search_base: cn=users,dc=win2012domain,dc=mycompany,dc=lan
    user_search_filter: (sAMAccountName={0})
    user_memberof_attribute: memberOf
    connection_pool:
        max_active: 8
        max_idle: 8
ldap_options

Configures LDAP security when the authenticator option in cassandra.yaml is set to com.datastax.bdp.cassandra.auth.DseAuthenticator .

server_host

A comma separated list of LDAP server hosts.

For information on parameters related to tunning failover performance for multiple LDAP servers, see Tune LDAP failover .

Default: none

server_port

The port on which the LDAP server listens.

389 - The default port for unencrypted connections.

636 - Used for encrypted connections. Default SSL or TLS port for LDAP.

search_dn

Distinguished name (DN) of an account with read access to the user_search_base and group_search_base . For example:

OpenLDAP: uid=lookup,ou=users,dc=springsource,dc=com

Microsoft Active Directory (AD) : cn=lookup, cn=users, dc=springsource, dc=com

For your LDAP domain, set the ou and dc elements. Typically set to ou=users,dc=<domain>,dc=<top_level_domain> . For example, ou=users,dc=example,dc=com .

For your Active Directory, set the dc element for a different search base. Typically set to CN=search,CN=Users,DC=<ActDir_domname>,DC=internal . For example, CN=search,CN=Users,DC=example-sales,DC=internal .

Contains a list of group names. Role manager assigns DSE roles that exactly match any group name in the list. Required when managing roles using group_search_type: memberof_search with LDAP ( role_manager.mode:ldap ). The directory server must have memberof support, which is a default user attribute in Microsoft Active Directory (AD).

Default: memberof

Option to define additional search bases for users. If the user is not found in one search base, DSE attempts to find the user in another search base, until all search bases have been tried. See also user_search_base , group_search_base , and extra_group_search_bases .

Default: [] (empty list)

group_search_type

Defines how group membership is determined for a user. Required when managing roles with LDAP ( role_manager.mode: ldap ).

directory_search - Filters the results with a subtree search of group_search_base to find groups that contain the username in the attribute defined in the group_search_filter .

memberof_search - Recursively searches for user entries using the user_search_base and user_search_filter . Gets groups from the user attribute defined in user_memberof_attribute . The directory server must have memberof support.

group_search_base

The unique distinguished name (DN) of the group record from which to start the group membership search.

Default: commented out

The attribute in the group record that contains the LDAP group name. Role names are case-sensitive and must match exactly on DSE for assignment. Unmatched groups are ignored.

Default: cn

Option to define additional search bases for groups. DSE merges all groups found in all the defined search bases. See also group_search_base , user_search_base , and extra_user_search_bases .

Default: [] (empty list)

credentials_validity_in_ms

A credentials cache improves performance by reducing the number of requests that are sent to the internal or LDAP server. See Defining an LDAP scheme .

0 - Disable credentials cache.

duration period - The duration period in milliseconds of the credentials cache.

DataStax recommends using a remote encryption key from a KMIP provider when using Transparent data encryption . Use a local encryption key only if a KMIP server is not available.

system_info_encryption

Sets the encryption settings for system resources that might contain sensitive information, including the system.batchlog and system.paxos tables, hint files, and the database commit log.

enabled

Enables encryption of system resources. See Encrypting system resources .

true - Enable encryption of system resources.

false - Does not encryption of system resources.

The system_trace keyspace is not encrypted by enabling the system_information_encryption section. In environments that also have tracing enabled, manually configure encryption with compression on the system_trace keyspace. See Transparent data encryption .

key_provider

KMIP key provider to enable encrypting sensitive system data with a KMIP key. Comment out if using a local encryption key.

Default: KmipKeyProviderFactory

kmip_host

The KMIP key server host. Set to the <kmip_group_name> that defines the KMIP host in kmip_hosts section. DSE requests a key from the KMIP host and uses the key generated by the KMIP provider.

Default: kmip_host_name

system_key_directory

Path to the directory where local encryption key files are stored, also called system keys. Distributes the system keys to all nodes in the cluster. Ensure the DSE account is the folder owner and has read/write/execute (700) permissions.

See Setting up local encryption keys .

true - Enable encryption of configuration property values using the specified config_encryption_key_name . When set to true, the configuration values must be encrypted or commented out. See Encrypting configuration file properties .

include:securing:partial$sec/SecWH-LcmNoDseEncrypt.adoc[]

false - Do not enable encryption of configuration property values.

KMIP encryption options

Options for KMIP encryption keys and communication between the DataStax Enterprise node and the KMIP key server or key servers. Enables DataStax Enterprise encryption features to use encryption keys that are stored on a server that is not running DataStax Enterprise.

kmip_hosts:
  <your_kmip_groupname>:
    hosts: kmip1.yourdomain.com, kmip2.yourdomain.com
    keystore_path: pathto/kmip/keystore.jks
    keystore_type: jks
    keystore_password: <password>
    truststore_path: pathto/kmip/truststore.jks
    truststore_type: jks
    truststore_password: <password>
    key_cache_millis: (300000)
    timeout: (1000)
kmip_groupname

A user-defined name for a group of options to configure a KMIP server or servers, key settings, and certificates. For each KMIP key server or group of KMIP key servers, you must configure options for a <kmip_groupname> section. Using separate key server configuration settings allows use of different key servers to encrypt table data and eliminates the need to enter key server configuration information in Data Definition Language (DDL) statements and other configurations. DDL statements are database schema change commands like CREATE TABLE. Multiple KMIP hosts are supported.

Default: commented out

hosts

A comma-separated list of KMIP hosts (<host>[:<port>]) using the FQDN (Fully Qualified Domain Name). Add KMIP hosts in the intended failover sequence because DSE queries the host in the listed order.

For example, if the host list contains kmip1.yourdomain.com, kmip2.yourdomain.com , DSE tries kmip1.yourdomain.com and then kmip2.yourdomain.com .

keystore_path

The path to a Java keystore created from the KMIP agent PEM files.

Default: /etc/dse/conf/KMIP_keystore.jks

truststore_path

The path to a Java truststore that was created using the KMIP root certificate.

Default: /etc/dse/conf/KMIP_truststore.jks

key_cache_millis

Milliseconds to locally cache the encryption keys that are read from the KMIP hosts. The longer the encryption keys are cached, the fewer requests to the KMIP key server are made and the longer it takes for changes, like revocation, to propagate to the DSE node. DataStax Enterprise uses concurrent encryption, so multiple threads fetch the secret key from the KMIP key server at the same time. DataStax recommends using the default value.

Default: 300000

timeout

Socket timeout in milliseconds.

Default: 1000

decryption_cache_size_in_mb

The maximum size of the shared DSE Search decryption cache in megabytes (MB).

Default: 256

A fraction of the system memory. For example, 0.20 allows use up to 20% of system memory. This setting is ignored if max_memory_to_lock_mb is set to a non-zero value.

Default: 0.20

max_memory_to_lock_mb

Maximum amount of memory in megabytes (MB) for DSE In-Memory tables.

not set - Use the fraction specified with max_memory_to_lock_fraction .

number greater than 0 - Maximum amount of memory in megabytes (MB).

Node health options are always enabled. Node health is a score-based representation of how healthy a node is to handle search queries. See Collecting node health and indexing status scores .

uptime_ramp_up_period_seconds

The amount of continuous uptime required for the node’s uptime score to advance the node health score from 0 to 1 (full health), assuming there are no recent dropped mutations. The health score is a composite score based on dropped mutations and uptime.

dropped_mutation_window_minutes

The historic time window over which the rate of dropped mutations affects the node health score.

Default: 30

enable_health_based_routing

Enables node health as a consideration for replication selection for distributed DSE Search queries. Health-based routing enables a trade-off between index consistency and query throughput.

true - Consider node health when multiple candidates exist for a particular token range.

false - Ignore node health for replication selection. When the primary concern is performance, do not enable health-based routing.

lease_metrics_options

Lease holder statistics help monitor the lease subsystem for automatic management of Job Tracker and Spark Master nodes.

enabled

Enables log entries related to lease holders.

true - Enable log entries related to lease holders to help monitor performance of the lease subsystem.

false - No not enable log entries.

initial_delay

The number of seconds to delay the first TTL check to speed up start-up time.

Default: 20

max_docs_per_batch

The maximum number of documents to check and delete per batch by the TTL rebuild thread. All expired documents are deleted from the index during each check. To avoid memory pressure, their unique keys are retrieved and then deletes are issued in batches.

Default: 4096

thread_pool_size

The maximum number of search indexes (cores) that can execute TTL cleanup concurrently. Manages system resource consumption and prevents many search cores from executing simultaneous TTL deletes.

Default: 1

true - The node joins the ring immediately after bootstrap and reindexing occurs asynchronously. Do not wait for post-bootstrap reindexing so that the node is not marked down. The dsetool ring command can be used to check the status of the reindexing.

false - The node joins the ring after reindexing the bootstrapped data.

driver - Respects driver paging settings. Uses Solr pagination (cursors) only when the driver uses pagination. Enabled automatically for DSE SearchAnalytics workloads.

off - Paging is off. Ignore driver paging settings for CQL queries and use normal Solr paging unless:

The current workload is an analytics workload, including SearchAnalytics. SearchAnalytics nodes always use driver paging settings.

The cqlsh query parameter paging is set to driver. Even when cql_solr_query_paging: off , paging is dynamically enabled with the "paging":"driver" parameter in JSON queries .

cql_solr_query_row_timeout

The maximum time in milliseconds to wait for all rows to be read from the database during CQL Solr queries.

Default: 10000 (10 seconds)

solr_resource_upload_limit_mb

Configures the maximum file size of the search index config or schema. Resource files can be uploaded, but the search index config and schema are stored internally in the database after upload.

0 - Disable resource uploading.

upload size - The maximum upload size limit in megabytes (MB) for a DSE Search resource file (search index config or schema).

Timeout behavior during distributed queries. The internal timeout for all search queries to prevent long running queries. The client request timeout is the maximum cumulative time (in milliseconds) that a distributed search request will wait idly for shard responses.

Default: 60000 (1 minute)

# back_pressure_threshold_per_core: 1024
# flush_max_time_per_core: 5
# load_max_time_per_core: 5
# enable_index_disk_failure_policy: false
# solr_data_dir: /MyDir
# solr_field_cache_enabled: false
# ram_buffer_heap_space_in_mb: 1024
# ram_buffer_offheap_space_in_mb: 1024
back_pressure_threshold_per_core

The maximum number of queued partitions during search index rebuilding and reindexing. This maximum number safeguards against excessive heap use by the indexing queue. If set lower than the number of threads per core (TPC), not all TPC threads can be actively indexing.

Default: 1024

Always set the wait time high enough to ensure flushing completes successfully to fully sync DSE Search indexes with the database data. If the wait time is exceeded, index updates are only partially committed and the commit log is not truncated which can undermine data durability.

When a timeout occurs, this node is typically overloaded and cannot flush in a timely manner. Live indexing increases the time to flush asynchronous index updates.

load_max_time_per_core

The maximum time, in minutes, to wait for each DSE Search index to load on startup or create/reload operations. This advanced option should be changed only if exceptions happen during search index loading.

Default: 5

The directory to store index data. See Managing the location of DSE Search data . By default, each DSE Search index is saved in <solr_data_dir>/<keyspace_name>.<table_name> or as specified by the dse.solr.data.dir system property.

Default: A solr.data directory in the cassandra data directory, like /var/lib/cassandra/solr.data

The Apache Lucene® field cache is deprecated. Instead, for fields that are sorted, faceted, or grouped by, set docValues="true" on the field in the search index schema. Then reload the search index and reindex.

Default: false

ram_buffer_heap_space_in_mb

Global Lucene RAM buffer usage threshold for heap to force segment flush. Setting too low can cause a state of constant flushing during periods of ongoing write activity. For near-real-time (NRT) indexing, forced segment flushes also de-schedule pending auto-soft commits to avoid potentially flushing too many small segments.

Default: 1024

ram_buffer_offheap_space_in_mb

Global Lucene RAM buffer usage threshold for offheap to force segment flush. Setting too low can cause a state of constant flushing during periods of ongoing write activity. For NRT, forced segment flushes also de-schedule pending auto-soft commits to avoid potentially flushing too many small segments. When not set, the default is 1024.

Default: 1024

Configures the thread pool that is used by most plugins. A dropped task warning is issued when the performance service requests more tasks than performance_max_threads + performance_queue_capacity . When a task is dropped, collected statistics might not be current.

# performance_core_threads: 4
# performance_max_threads: 32
# performance_queue_capacity: 32000
performance_core_threads

Number of background threads used by the performance service under normal conditions.

Default: 4

performance_max_threads

Maximum number of background threads used by the performance service.

Default: 32

performance_queue_capacity

Allowed number of queued tasks in the backlog when the number of performance_max_threads are busy.

Default: 32000

Performance Service

Configures the collection of performance metrics on transactional nodes. Performance metrics are stored in the dse_perf keyspace and can be queried using any CQL-based utility, such as cqlsh or any application using a CQL driver. To temporarily make changes for diagnostics and testing, use the dsetool perf subcommands.

cql_slow_log_options

Configures reporting distributed sub-queries for search (query executions on individual shards) that take longer than a specified period of time.

enabled

A value greater than 1 is expressed in time and will log queries that take longer than the specified number of milliseconds. For example, 200.0 sets the threshold at 0.2 seconds.

A value of 0 to 1 is expressed as a percentile and will log queries that exceed this percentile. For example, .95 collects information on 5% of the slowest queries.

The initial number of queries before activating the percentile filter.

Default: commented out ( 100 )

ttl_seconds

Number of seconds a slow log record survives before it is expired.

Default: 259200

skip_writing_to_db

Keeps slow queries only in-memory and does not write data to database.

true - Keep slow queries only in-memory. Skip writing to database.

false - Write slow query information in the node_slow_log table. The threshold must be >= 2000 ms to prevent a high load on the database.

cql_system_info_options

Configures collection of system-wide performance information about a cluster.

enabled

Enables collection of system-wide performance information about a cluster.

true - Collect metrics.

false - Do not collect metrics.

The length of the sampling period in milliseconds; the frequency to update the performance statistics.

Default: 10000 (10 seconds)

The length of the sampling period in milliseconds; the frequency to update the performance statistics.

Default: 10000 (10 seconds)

The length of the sampling period in milliseconds; the frequency to update the performance statistics.

Default: 10000 (10 seconds)

The length of the sampling period in milliseconds; the frequency to update the performance statistics.

Default: 10000 (10 seconds)

spark_cluster_info_options

Configures collection of data associated with Spark cluster and Spark applications.

spark_cluster_info_options:
    enabled: false
    refresh_rate_ms: 10000

The length of the sampling period in milliseconds; the frequency to update the performance statistics.

Default: 10000 (10 seconds)

The length of the sampling period in milliseconds; the frequency to update the performance statistics.

Default: 10000 (10 seconds)

retention_count

Default: 3

The length of the sampling period in milliseconds; the frequency to update the performance statistics.

Default: 10000 (10 seconds)

top_stats_limit

The maximum number of individual metrics.

Default: 100

quantiles

Default: false

The number of seconds a record survives before it is expired.

Default: 604800 (about 10 minutes)

async_writers

The number of server threads dedicated to writing in the log. More than one server thread might degrade performance.

Default: 1

threshold_ms

Default: 3000

The length of the sampling period in milliseconds; the frequency to update the performance statistics.

Default: 10000 (10 seconds)

driver

Collection that configures collection of metrics at the Spark Driver.

connectorSource

Enables collecting Spark Cassandra Connector metrics at the Spark Driver.

true - Collect metrics.

false - Do not collect metrics.

spark_shared_secret_bit_length: 256
spark_security_enabled: false
spark_security_encryption_enabled: false
spark_daemon_readiness_assertion_interval: 1000
resource_manager_options:
   worker_options:
       cores_total: 0.7
       memory_total: 0.6
       workpools:
          - name: alwayson_sql
          cores: 0.25
          memory: 0.25
spark_shared_secret_bit_length

The length of a shared secret used to authenticate Spark components and encrypt the connections between them. This value is not the strength of the cipher for encrypting connections.

Default: 256

spark_security_enabled

When DSE authentication is enabled with authentication_options , Spark security is enabled regardless of this setting.

Default: false

spark_security_encryption_enabled

When DSE authentication is enabled with authentication_options , Spark security encryption is enabled regardless of this setting.

spark_daemon_readiness_assertion_interval

Time interval in milliseconds between subsequent retries by the Spark plugin for Spark Master and Worker readiness to start.

Default: 1000

resource_manager_options

Controls the physical resources used by Spark applications on this node. Optionally add named workpools with specific dedicated resources. See Core management .

worker_options

Configures the amount of system resources that are made available to the Spark Worker.

Setting cores_total or a workpool’s cores to 1.0 is a decimal value, meaning 100% of the available cores will be reserved. Setting cores_total or cores to 1 (no decimal point) is an explicit value, and one core will be reserved.

absolute value - Use standard suffixes like M for megabyte and G for gigabyte. For example, 12G.

decimal value - Maximum fraction of system memory to give all executors for all applications running on a particular node. For example, 0.8.

When the value is expressed as a decimal, the available resources are calculated in the following way:

Spark Worker memory = memory_total x (total system memory - memory assigned to DataStax Enterprise)

The lowest values that you can assign to Spark Worker memory is 64 MB. If the results are lower, no exception is thrown and the values are automatically limited.

workpools

A collection of named workpools that can use a portion of the total resources defined under worker_options .

A default workpool named default is used if no workpools are defined in this section. If workpools are defined, the resources allocated to the workpools are taken from the total amount, with the remaining resources available to the default workpool.

The total amount of resources defined in the workpools section must not exceed the resources available to Spark in worker_options .

The name of the workpool. A workpool named alwayson_sql is created by default for AlwaysOn SQL. By default, the alwayson_sql workpool is configured to use 25% of the resources available to Spark.

Default: alwayson_sql

cores

The number of system cores to use in this workpool expressed as an absolute value or a decimal value. This option follows the same rules as cores_total .

memory

The amount of memory to use in this workpool expressed as either an absolute value or a decimal value. This option follows the same rules as memory_total .

keystore: resources/dse/conf/.ui-keystore keystore_password: cassandra require_client_auth: false truststore: .truststore truststore_password: cassandra # Advanced settings # protocol: TLS # algorithm: SunX509 # keystore_type: JKS # truststore_type: JKS # cipher_suites: [TLS_RSA_WITH_AES_128_CBC_SHA,TLS_RSA_WITH_AES_256_CBC_SHA,TLS_DHE_RSA_WITH_AES_128_CBC_SHA,TLS_DHE_RSA_WITH_AES_256_CBC_SHA,TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA,TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA]

inherit - Inherit the SSL settings from the client_encryption_options in cassandra.yaml .

custom - Use the following encryption_options in dse.yaml .

encryption_options

When encryption: custom , configures encryption for HTTPS of Spark Master and Worker UI.

enabled

Enables Spark encryption for Spark client-to-Spark cluster and Spark internode communication.

Default: false

keystore

The keystore for Spark encryption keys.

The relative filepath is the base Spark configuration directory that is defined by the SPARK_CONF_DIR environment variable. The default Spark configuration directory is resources/spark/conf.

Default: resources/dse/conf/.ui-keystore

keystore_password

The password to access the keystore.

Default: cassandra

require_client_auth

Enables custom truststore for client authentication.

true - Require custom truststore for client authentication.

false - Do not require custom truststore.

truststore

The filepath to the truststore for Spark encryption keys if require_client_auth: true .

The relative filepath is the base Spark configuration directory that is defined by the SPARK_CONF_DIR environment variable. The default Spark configuration directory is resources/spark/conf.

Default: resources/dse/conf/.ui-truststore

truststore_password

The password to access the truststore.

Default: cassandra

protocol

The Transport Layer Security (TLS) authentication protocol. The TLS protocol must be supported by JVM and Spark. TLS 1.2 is the most common JVM default.

Default: JVM default

algorithm

The key manager algorithm.

Default: SunX509

spark_process_runner:

Configures how Spark driver and executor processes are created and managed. See Running Spark processes as separate users .

runner_type
run_as_runner_options

When runner_type: run_as , Spark applications run as a different OS user than the DSE service user.

user_slots

The list slot users to separate Spark processes users from the DSE service user.

Default: slot1, slot2

# web_ui_port: 9077 # reserve_port_wait_time_ms: 100 # alwayson_sql_status_check_wait_time_ms: 500 # workpool: alwayson_sql # log_dsefs_dir: /spark/log/alwayson_sql # auth_user: alwayson_sql # runner_max_errors: 10 # heartbeat_update_interval_seconds: 30

true - Enable AlwaysOn SQL for this node. The node must be an analytics node. Set workpools in Spark resource_manager_options .

false - Do not enable AlwaysOn SQL for this node.

reserve_port_wait_time_ms

The wait time in milliseconds to reserve the thrift_port if it is not available.

Default: 100

alwayson_sql_status_check_wait_time_ms

The time in milliseconds to wait for a health check status of the AlwaysOn SQL server.

Default: 500

workpool

The named workpool used by AlwaysOn SQL.

Default: alwayson_sql

log_dsefs_dir

Location in DSEFS of the AlwaysOn SQL log files.

Default: /spark/log/alwayson_sql

auth_user

The role to use for internal communication by AlwaysOn SQL if authentication is enabled. Custom roles must be created with login=true .

Default: alwayson_sql

runner_max_errors

The maximum number of errors that can occur during AlwaysOn SQL service runner thread runs before stopping the service. A service stop requires a manual restart.

Default: 10

heartbeat_update_interval_seconds

The time interval to update heartbeat of AlwaysOn SQL. If heartbeat is not updated for more than three times the interval, AlwaysOn SQL automatically restarts.

Default: 30

The keyspace where the DSEFS metadata is stored. You can optionally configure multiple DSEFS file systems within a single datacenter by specifying different keyspace names for each cluster.

Default: dsefs

work_dir

The local directory for storing the local node metadata, including the node identifier. The volume of data stored in this directory is nominal and does not require configuration for throughput, latency, or capacity. This directory must not be shared by DSEFS nodes.

Default: /var/lib/dsefs

public_port

The public port on which DSEFS listens for clients.

DataStax recommends that all nodes in the cluster have the same value. Firewalls must open this port to trusted clients. The service on this port is bound to the native_transport_address .

Mandatory attribute to identify the set of directories. DataStax recommends segregating these data directories on physical devices that are different from the devices that are used for DataStax Enterprise. Using multiple directories on JBOD improves performance and capacity.

Default: /var/lib/dsefs/data

storage_weight

Weighting factor for this location. Determines how much data to place in this directory, relative to other directories in the cluster. This soft constraint determines how DSEFS distributes the data. For example, a directory with a value of 3.0 receives about three times more data than a directory with a value of 1.0.

Default: 1.0

The reserved space, in bytes, to not use for storing file data blocks. You can use a unit of measure suffix to specify other size units. For example: terabyte (1 TB), gigabyte (10 GB), and megabyte (5000 MB).

Default: 268435456

#     service_startup_timeout_ms: 60000
#     service_close_timeout_ms: 600000
#     server_close_timeout_ms: 2147483647 # Integer.MAX_VALUE
#     compression_frame_max_size: 1048576
#     query_cache_size: 2048
#     query_cache_expire_after_ms: 2000
#     gossip_options:
  #   round_delay_ms: 2000
  #   startup_delay_ms: 5000
  #   shutdown_delay_ms: 10000
# rest_options:
  #   request_timeout_ms: 330000
  #   connection_open_timeout_ms: 55000
  #   client_close_timeout_ms: 60000
  #   server_request_timeout_ms: 300000
  #   idle_connection_timeout_ms: 60000
  #   internode_idle_connection_timeout_ms: 120000
  #   core_max_concurrent_connections_per_host: 8
# transaction_options:
  #   transaction_timeout_ms: 3000
  #   conflict_retry_delay_ms: 200
  #   conflict_retry_count: 40
  #   execution_retry_delay_ms: 1000
  #   execution_retry_count: 3
#     block_allocator_options:
#         overflow_margin_mb: 1024
#         overflow_factor: 1.05
service_startup_timeout_ms

Wait time in milliseconds before the DSEFS server times out while waiting for services to bootstrap.

Default: 60000

service_close_timeout_ms

Wait time in milliseconds before the DSEFS server times out while waiting for services to close.

Default: 60000

server_close_timeout_ms

Wait time in milliseconds that the DSEFS server waits during shutdown before closing all pending connections.

Default: 2147483647

compression_frame_max_size

The maximum accepted size of a compression frame defined during file upload.

Default: 1048576

query_cache_size

Maximum number of elements in a single DSEFS Server query cache.

Default: 2048

query_cache_expire_after_ms

The time to retain the DSEFS Server query cache element in cache. The cache element expires when this time is exceeded.

Default: 2000

gossip options

Configures DSEFS gossip rounds.

round_delay_ms

The delay in milliseconds between gossip rounds.

Default: 2000

startup_delay_ms

The delay in milliseconds between registering the location and reading back all other locations from the database.

Default: 5000

shutdown_delay_ms

The delay time in milliseconds between announcing shutdown and shutting down the node.

Default: 30000

rest_options

Configures DSEFS rest times.

request_timeout_ms

The time in milliseconds that the client waits for a response that corresponds to a given request.

Default: 330000

connection_open_timeout_ms

The time in milliseconds that the client waits to establish a new connection.

Default: 55000

client_close_timeout_ms

The time in milliseconds that the client waits for pending transfer to complete before closing a connection.

Default: 60000

server_request_timeout_ms

The time in milliseconds to wait for the server rest call to complete.

Default: 300000

idle_connection_timeout_ms

The time in milliseconds for RestClient to wait before closing an idle connection. If RestClient does not close connection after timeout, the connection is closed after 2 x this wait time.

time - Wait time to close idle connection.

0 - Disable closing idle connections.

internode_idle_connection_timeout_ms

Wait time in milliseconds before closing idle internode connection. The internode connections are primarily used to exchange data during replication. Do not set lower than the default value for heavily utilized DSEFS clusters.

Default: 0

core_max_concurrent_connections_per_host

Maximum number of connections to a given host per single CPU core. DSEFS keeps a connection pool for each CPU core.

Default: 8

transaction_options

Configures DSEFS transaction times.

transaction_timeout_ms

Transaction run time in milliseconds before the transaction is considered for timeout and rollback.

Default: 3000

conflict_retry_delay_ms

Wait time in milliseconds before retrying a transaction that was ended due to a conflict.

Default: 200

conflict_retry_count

The number of times to retry a transaction before giving up.

Default: 40

execution_retry_delay_ms

Wait time in milliseconds before retrying a failed transaction payload execution.

Default: 1000

execution_retry_count

The number of payload execution retries before signaling the error to the application.

Default: 3

block_allocator_options

Controls how much additional data can be placed on the local coordinator before the local node overflows to the other nodes. The trade-off is between data locality of writes and balancing the cluster. A local node is preferred for a new block allocation, if:

used_size_on_the_local_node < average_used_size_per_node x overflow_factor + overflow_margin
overflow_margin_mb

Directory to store collected metrics.

When data_dir is not explicitly set, the insights_data directory is stored in the same parent directory as the commitlog_directory as defined in cassandra.yaml. If the commitlog_directory uses the package default of /var/lib/cassandra/commitlog, data_dir will default to /var/lib/cassandra/insights_data.

Default: /var/lib/cassandra/insights_data

Directory to store logs for collected metrics. The log file is dse-collectd.log. The file with the collectd PID is dse-collectd.pid.

Default: /var/log/cassandra/

Comma-separated list of keyspaces to exclude. You can also use a regular expression to filter on keyspace name.

Default: exclude no keyspaces

included_roles

Comma-separated list of the roles for which events are logged.

queue_size: 30000 write_consistency: QUORUM # dropped_event_log: /var/log/cassandra/dropped_audit_events.log # day_partition_millis: 3600000

async - Audit events are queued for writing to the audit table, but are not necessarily logged before the query executes. A pool of writer threads consumes the audit events from the queue, and writes them to the audit table in batch queries.

Must be greater than 0.

The maximum number of events the writer dequeues before writing them out to the table. If warnings in the logs reveal that batches are too large, decrease this value or increase the value of batch_size_warn_threshold_in_kb in cassandra.yaml .

Default: 50

flush_time

Available only when mode: async .

The maximum amount of time in milliseconds before an event is removed from the queue by a writer before being written out. This flush time prevents events from waiting too long before being written to the table when there are not a lot of queries happening.

Default: 500

queue_size

The size of the queue feeding the asynchronous audit log writer threads.

Number of events - When there are more events being produced than the writers can write out, the queue fills up, and newer queries are blocked until there is space on the queue.

0 - The queue size is unbounded, which can lead to resource exhaustion under heavy query load.

The directory to store the log file that reports dropped events.

Default: /var/log/cassandra/dropped_audit_events.log

day_partition_millis

The time interval in milliseconds between changing nodes to spread audit log information across multiple nodes. For example, to change the target node every 12 hours, specify 43200000 milliseconds.

Default: 3600000 (1 hour)

One or more disk configurations for DSE Tiered Storage . Specify multiple disk configurations as unnamed tiers by a collection of paths that are defined in priority order, with the fastest storage media in the top tier. With heterogeneous storage configurations across the cluster, specify each disk configuration with <config_name>:<config_settings>, and then use this configuration in CREATE TABLE or ALTER TABLE statements.

DSE Tiered Storage does not change compaction strategies. To manage compression and compaction options, use the compaction option. See Modifying compression and compaction .

# - /mnt1 # - /mnt2 # - paths: [ /mnt3, /mnt4 ] # - paths: [ /mnt5, /mnt6 ] # local_options: # k1: v1 # k2: v2 # 'another strategy': # tiers: [ paths: [ /mnt1 ] ]
tiered_storage_options

Configures the smart movement of data across different types of storage media so that data is matched to the most suitable drive type, according to the required performance and cost characteristics.

strategy1

The first disk configuration strategy. Create a strategy2, strategy3, and so on. In this example, strategy1 is the configurable name of the tiered storage configuration strategy.

tiers

The unnamed tiers in this section configure a storage tier with the paths and filepaths that define the priority order.

local_options

Local configuration options overwrite the tiered storage settings for the table schema in the local dse.yaml file. See Testing DSE Tiered Storage configurations .

- paths

The section of filepaths that define the data directories for this tier of the disk configuration. List the fastest storage media first. These paths are used to store only data that is configured to use tiered storage and are independent of any settings in the cassandra.yaml file.

- /filepath

The filepaths that define the data directories for this tier of the disk configuration.

# advanced_replication_options:
  # enabled: false
  # conf_driver_password_encryption_enabled: false
  # advanced_replication_directory: /var/lib/cassandra/advrep
  # security_base_path: /<base>/<path>/<to>/<advrep>/<security>/<files>/

The directory for storing advanced replication CDC logs. The replication_logs directory will be created in the specified directory.

Default: /var/lib/cassandra/advrep

security_base_path

The base path to prepend to paths in the Advanced Replication configuration locations, including locations to SSL keystore, SSL truststore, and so on.

Default: /base/path/to/advrep/security/files/

internode_messaging_options

Configures the internal messaging service used by several components of DataStax Enterprise. All internode messaging requests use this service.

The mandatory port for the internode messaging service.

Default: 8609

frame_length_in_mb

Maximum message frame length.

Default: 256

server_acceptor_threads

The number of server acceptor threads.

Default: The number of available processors

server_worker_threads

The number of server worker threads.

Default: The default is the number of available processors x 8

client_max_connections

The maximum number of client connections.

Default: 100

client_worker_threads

The number of client worker threads.

Default: The default is the number of available processors x 8

handshake_timeout_seconds

Timeout for communication handshake process.

Default: 10

client_request_timeout_seconds

Timeout for non-query search requests like core creation and distributed deletes.

Default: 60

server_id

Unique generated ID of the physical server in DSE Multi-Instance /etc/<dse-nodeId>/dse.yaml files. You can change server_id when the MAC address is not unique, such as a virtualized server where the host’s physical MAC is cloned.

Default: the media access control address (MAC address) of the physical server

# config: # sandbox_enabled: false # sandbox_rules: # whitelist_packages: # - package.name # whitelist_types: # - fully.qualified.type.name # whitelist_supers: # - fully.qualified.class.name # blacklist_packages: # - package.name # blacklist_supers: # - fully.qualified.class.name
threadPoolWorker

The number of worker threads that handle non-blocking read and write (requests and responses) on the Gremlin Server channel, including routing requests to the right server operations, handling scheduled jobs on the server, and writing serialized responses back to the client.

Default: 2

gremlinPool

This pool represents the workers available to handle blocking operations in Gremlin Server.

0 - the value of the JVM property cassandra.available_processors, if that property is set

positive number - The number of Gremlin threads available to execute actual scripts in a ScriptEngine.

List of super classes, one class per line, to blacklist. Retain the hyphen before the fully qualified class name.

-<fully.qualified.class.name>

The fully qualified class name.

# graph:
    # analytic_evaluation_timeout_in_minutes: 10080
    # realtime_evaluation_timeout_in_seconds: 30
    # schema_agreement_timeout_in_ms: 10000
    # system_evaluation_timeout_in_seconds: 180
    # adjacency_cache_size_in_mb: 128
    # index_cache_size_in_mb: 128
    # max_query_params: 16
graph

System-level configuration options and options that are shared between graph instances. Add an option if it is not present in the provided dse.yaml file.

Option names and values expressed in ISO 8601 format used in earlier DSE 5.0 releases are still valid. The ISO 8601 format is deprecated.

analytic_evaluation_timeout_in_minutes

Maximum time to wait for an OLAP analytic (Spark) traversal to evaluate.

Default: 10080 (168 hours)

realtime_evaluation_timeout_in_seconds

Maximum time to wait for an OLTP real-time traversal to evaluate.

Default: 30

schema_agreement_timeout_in_ms

Maximum time to wait for the database to agree on schema versions before timing out.

Default: 10000

system_evaluation_timeout_in_seconds

Maximum time to wait for a graph system-based request to execute, like creating a new graph.

Default: 180 (3 minutes)

adjacency_cache_size_in_mb

The amount of ram to allocate to each graph’s adjacency (edge and property) cache.

Default: 128

index_cache_size_in_mb

The amount of ram to allocate to the index cache.

Default: 128

max_query_params

The maximum number of parameters that can be passed on a graph query request for TinkerPop drivers and drivers using the Cassandra native protocol. Passing very large numbers of parameters on requests is an anti-pattern, because the script evaluation time increases proportionally. DataStax recommends reducing the number of parameters to speed up script compilation times. Before you increase this value, consider alternate methods for parameterizing scripts, like passing a single map. If the graph query request requires many arguments, pass a list.

Default: 16

Some graph options in earlier versions of DSE are no longer required. The default settings from the earlier versions of dse.yaml/ are preserved. These advanced settings were removed from dse.yaml , although expert users can manually enter the option to change the default setting.

Generally, the default value is appropriate and does not need adjusting. DataStax recommends contacting the DataStax Services team before changing this value.

graph:
  adjacency_cache_clean_rate: 1024
  adjacency_cache_max_entry_size_in_mb: 0
  adjacency_cache_size_in_mb: 128
  gremlin_server_enabled: true
  index_cache_clean_rate: 1024
  index_cache_max_entry_size_in_mb: 0
  schema_mode: Production
  window_size: 100000
adjacency_cache_clean_rate

The number of stale rows per second to clean from each graph’s adjacency cache.

Default: 1024

adjacency_cache_max_entry_size_in_mb

The maximum entry size in each graph’s adjacency cache. When set to zero, the default is calculated based on the cache size and the number of CPUs. Entries that exceed this size are quietly dropped by the cache without producing an explicit error or log message.

Default: 0

adjacency_cache_size_in_mb

The amount of RAM to allocate to each graph’s adjacency (edge and property) cache.

Default: 128

gremlin_server_enabled

Enables Gremlin Server.

true - Enable Gremlin Server.

false - Do not enable Gremlin Server.

index_cache_clean_rate

The number of stale entries per second to clean from the adjacency cache.

Default: 1024

index_cache_max_entry_size_in_mb

Entries that exceed this size are quietly dropped by the cache without producing an explicit error or log message.

0 - Maximum size is based on the cache size and the number of CPUs.

postive integer - The maximum entry size in the index adjacency cache.

Production = Schema must be created before data insertion. Schema cannot be changed after data is inserted. Full graph scans are disallowed unless the option graph.allow_scan is changed to TRUE.

Development = No schema is required to write data to a graph. Schema can be changed after data is inserted. If this option is not present, manually enter it. Full graph scans are allowed unless the option graph.allow_scan is changed to FALSE.

The number of samples to keep when aggregating log events. Only a small subset of graph’s log events use this system. Modifying this setting is rarely necessary or helpful.

Default: 100000

Some graph options in earlier versions of DSE are no longer required. The default settings from the earlier versions of dse.yaml are preserved. These advanced settings vertex ID assignment and partitioning strategy options were removed from dse.yaml , although expert users can manually enter the option to change the default setting.

Generally, the default value is appropriate and does not need adjusting. DataStax recommends contacting the DataStax Services team before changing this value.

block_renew: 0.8 community_reuse: 28 consistency_mode: GLOBAL # datacenter_id: <integer> unique per DC when consistency_mode: DC_LOCAL id_hash_modulus: 20 member_block_size: 512

DSG configuration options for standard vertex ID assignment and partitioning strategies.

block_renew

The graph standard vertex ID allocator operates on blocks of contiguous IDs. Each block is allocated using a database lightweight transaction that requires coordination latency. To hide the cost of allocating a standard ID block, the allocator begins asynchronously buffering a replacement block whenever a current block is nearly empty. This block_renew parameter defines "nearly empty" as a floating point number between 0 and 1. The value is how much of a standard ID block can be used before graph starts asynchronously allocating its replacement. This setting has no effect on custom IDs. Value must be between 0 and 1.

Default: 0.8

community_reuse

For graphs using standard vertex IDs, if a transaction creates multiple vertices, the allocator attempts to assign vertex IDs that colocate vertices on the same database replicas. If an especially large vertex cohort is created, the allocator chunks the vertex creation and assigns a random target location to avoid load hotspotting. This setting controls the vertex chunk size and has no effect on custom IDs.

Default: 28

consistency_mode

Must be set to DC_LOCAL or GLOBAL.

DC_LOCAL - The node uses LOCAL_QUORUM when allocating an ID for a graph vertex. The datacenter_id option must be correctly configured on every node in the cluster.

GLOBAL - The node uses QUORUM when allocating an ID for a graph vertex. The datacenter_id option is ignored. This option must have the same value on every node in the cluster and can be changed only when the entire cluster is stopped. This setting has no effect on custom IDs.

Applies only when consistency_mode is DC_LOCAL. Set to an arbitrary value between 1 and 127, inclusive. This setting has no effect on custom IDs.

id_hash_modulus

An integer between 1 and 2^24 (both inclusive) that affects maximum ID capacity and the maximum storage space used by ID allocations. Lower values reduce the storage space consumed and the lightweight transaction overhead imposed at startup. Lower values also reduce the total number of IDs that can be allocated over the life of a graph, because this parameter is proportional to the allocatable ID space. However, the proportion coefficient is Long.MAX_VALUE (2^63-1), so ID headroom should be sufficient, practically speaking, even if this is set to 1. This setting has no effect on custom IDs.

Default: 20

member_block_size

The graph standard vertex ID allocator claims uniformly-sized blocks of contiguous IDs using lightweight transactions on the database. This setting controls the size of each block. This setting has no effect on custom IDs.

Default: 512

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries. Kubernetes is the registered trademark of the Linux Foundation.