Enabling NodeSync validation

Continuously verify data consistency in the background without performing anti-entropy repairs.

By default, NodeSync is disabled when a table is created. It is also disabled on tables that were migrated from earlier versions. To continuously verify data consistency in the background without the need for anti-entropy repairs, enable NodeSync on one or more tables.

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