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.


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

Was this helpful?

Give Feedback

How can we improve the documentation?

© 2024 DataStax | Privacy policy | Terms of use

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.

General Inquiries: +1 (650) 389-6000, info@datastax.com