Enabling NodeSync validation

By default, NodeSync is enabled for new tables. Enabling NodeSync continuously verifies data consistency in the background without the need for anti-entropy repairs.

Existing tables retain their settings but new tables have NodeSync enabled by default. To disable NodeSync for new tables, set -Ddse.nodesync.disable_on_new_tables=true. For more, see Setting system properties during startup.

Data only needs to be validated if the table is in more than one datacenter or is in a datacenter where the keyspace has a replication factor or 2 or more.

Procedure

Enable on an existing table:

Change the NodeSync setting on a single table using CQL syntax:
```
ALTER TABLE table_name WITH
nodesync={'enabled': 'true'};
```

A list of tables using nodesync enable:

nodesync enable <keyspace_name>.<table_name> <keyspace_name>.<table_name>

Create a table with NodeSync enabled:

CREATE TABLE <table_name> ( <column_list> ) WITH
nodesync={'enabled': 'true'};

Create a table with incremental NodeSync enabled:

CREATE TABLE <table_name> ( <column_list> ) WITH
nodesync={'enabled': 'true', 'incremental': 'true'};

Enabling NodeSync validation

Procedure

Was this helpful?

Give Feedback