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'};
