dse nodesync

The NodeSync service continuous background repair is enabled on a per table basis.

Modifies CQL nodesync property on one or more tables, enables nodesync tracing and monitoring.

Tables with NodeSync enabled will be skipped for repair operations run against all or specific keyspaces. For individual tables, running the repair command will be rejected when NodeSync is enabled.

Synopsis

[dse] nodesync
[(-ca cql_Authprovider | --cql-auth-provider <cql_Authprovider>)]
[(-cp <cql_password> | --cql-password <cql_password>)]
[(-cs | --cql-ssl)]
[(-cu <cql_username> | --cql-username <cql_username>)]
[(-h <cql_host> | --host <cql_host>)]
[help]
[(-jp <jmx_password> | --jmx-password <jmx_password>)]
[(-jpf <jmx_password_file> | --jmx-password-file <jmx_password_file>)]
[(-js | --jmx-ssl)]
[(-ju <jmx_username> | --jmx-username <jmx_username>)]
[(-p <cql_port> | --port <cql_port> )]
subcommand [options]

Syntax legend

Syntax conventions Description

Syntax conventions	Description
Italic, bold, or `< >`	Syntax diagrams and code samples use one or more of these styles to mark placeholders for variable values. Replace placeholders with a valid option or your own user-defined value. In CQL statements, angle brackets are required to enclose data types in a set, list, map, or tuple. Separate the data types with a comma. For example: `<datatype2` In Search CQL statements, angle brackets are used to identify the entity and literal value to overwrite the XML element in the schema and `solrconfig` files, such as `@<xml_entity>='<xml_entity_type>'`.
`[ ]`	Square brackets surround optional command arguments. Do not type the square brackets.
`( )`	Parentheses identify a group to choose from. Do not type the parentheses.
`\|`	A pipe separates alternative elements. Type any one of the elements. Do not type the pipe.
`...`	Indicates that you can repeat the syntax element as often as required.
`'`	Single quotation marks must surround literal strings in CQL statements. Use single quotation marks to preserve upper case. + For Search CQL only: Single quotation marks surround an entire XML schema declaration, such as `'<<schema> ... </schema>>'`
`{ }`	Map collection. Curly braces enclose maps (`{ <key_datatype>:<value_datatype> }`) or key value pairs (`{ <key>:<value> }`). A colon separates the key and the value.
`;`	Ends a CQL statement.
`--`	Separate command line options from command arguments with two hyphens. This syntax is useful when arguments might be mistaken for command line options.

Italic, bold, or < >

Syntax diagrams and code samples use one or more of these styles to mark placeholders for variable values. Replace placeholders with a valid option or your own user-defined value.

In CQL statements, angle brackets are required to enclose data types in a set, list, map, or tuple. Separate the data types with a comma. For example: <datatype2

In Search CQL statements, angle brackets are used to identify the entity and literal value to overwrite the XML element in the schema and solrconfig files, such as @<xml_entity>='<xml_entity_type>'.

[ ]

Square brackets surround optional command arguments. Do not type the square brackets.

( )

Parentheses identify a group to choose from. Do not type the parentheses.

|

A pipe separates alternative elements. Type any one of the elements. Do not type the pipe.

...

Indicates that you can repeat the syntax element as often as required.

'

Single quotation marks must surround literal strings in CQL statements. Use single quotation marks to preserve upper case. + For Search CQL only: Single quotation marks surround an entire XML schema declaration, such as '<<schema> ... </schema>>'

{ }

Map collection. Curly braces enclose maps ({ <key_datatype>:<value_datatype> }) or key value pairs ({ <key>:<value> }). A colon separates the key and the value.

;

Ends a CQL statement.

--

Separate command line options from command arguments with two hyphens. This syntax is useful when arguments might be mistaken for command line options.

Common options

The following options are available to all nodesync commands:

-ca, --cql-auth-provider cql_Authprovider: CQL auth provider class name.

-cp, --cql-password cql_password: CQL password.

-cs | --cql-ssl: Use SSL for CQL connection.

-cu, --cql-username cql_username: CQL username.

-h, --host cql_host: Connect to the specified remote CQL host.

help: Displays options and usage instructions. Use nodesync help subcommand for more information on a specific command.

-jp, --jmx-password jmx_password: JMX password.

-jpf, --jmx-password-file jmx_password_file: Path to JMX password file.

-js | --jmx-ssl: Use SSL for JMX.
-ju, --jmx-username jmx_username: JMX username.

-p, --port cql_port: Connection port for CQL.

-k, --keyspace keyspace_name

Specify a default keyspace for unqualified table names or wildcards in the table_list.

The keyspace must be an alterable keyspace: system_distributed keyspace or a user-created keyspace. An error results when attempting to run these commands on an unalterable keyspace such as system_auth.

For example, when the keyspace is alterable:

nodesync disable -v -k system_distributed "*"

Nodesync disabled for system_distributed.nodesync_status
Nodesync disabled for system_distributed.backups
...
Nodesync disabled for system_distributed.repair_history
--
+
As compared to an unalterable keyspace:
+
[source,console]
--
nodesync disable -v -k system_auth "*"

Error: Keyspace [system_auth] is not alterable.
--
+
You can use a CQL command to enable or disable nodesync for unalterable keyspaces, such as a `system_*` keyspace.
For example:
+
[source,console]
--
ALTER TABLE system_auth.roles WITH nodesync = {'enabled': 'false'};

--quiet: Suppress warning and error messages.

-v, --verbose: Enable verbose console output
--: Separates table list from the rest of the command.

table_list

Target tables using any of the following methods:

Qualified table names: keyspace_name.table_name. For example, cycling.comments.
Default keyspace -k option with:
- Unqualified table names. For example -k cycling cyclist_alt_stats comments cyclist_races.
- An asterisk in double quotes to select all tables. For example, -k cycling "*".

-n, --nodes node_list: Only disable tracing on the listed nodes. Specify the host name or IP address in a comma separated list.

Default: All nodes

--quiet: Suppresses messages from displaying on stdout.

Example

Get general help for the nodesync command:

nodesync help

usage: nodesync [(-js | --jmx-ssl)] [(-p <cqlPort> | --port <cqlPort>)]
  [(-cu <cqlUsername> | --cql-username <cqlUsername>)]
  [(-jp <jmxPassword> | --jmx-password <jmxPassword>)]
  [(-jpf <jmxPasswordFile> | --jmx-password-file <jmxPasswordFile>)]
  [(-ca <cqlAuthProvider> | --cql-auth-provider <cqlAuthProvider>)]
  [(-ju <jmxUsername> | --jmx-username <jmxUsername>)]
  [(-cp <cqlPassword> | --cql-password <cqlPassword>)] [(-cs | --cql-ssl)]
  [(-h <cqlHost> | --host <cqlHost>)] <command> [<args>]

The most commonly used nodesync commands are:
  disable      Disable nodesync on the specified tables
  enable       Enable nodesync on the specified tables
  help         Display help information
  tracing      Enable/disable tracing for NodeSync
  validation   Monitor/manage user-triggered validations

See 'nodesync help <command>' for more information on a specific command.

For command-specific help, see nodesync help.

dse nodesync

Synopsis

Common options

Example

See also

Was this helpful?

Give Feedback