Enabling NodeSync for keyspaces and tables

Designate which keyspaces and tables have NodeSync active for viewing progress status. Follow the steps in this procedure to quickly turn on NodeSync monitoring for eligible entire keyspaces or specific tables.

Enable the NodeSync Service for OpsCenter Monitoring. Designate which keyspaces and tables have NodeSync active for viewing NodeSync status. NodeSync and incremental NodeSync are enabled by default; however, keyspaces and their tables must be explicitly opted in. Follow the steps in this procedure to enable NodeSync monitoring for eligible keyspaces or individual tables..
Important: The nodetool repair command fails on Nodesync-enabled tables. Tables with NodeSync enabled are skipped for nodetool repair operations run against any keyspaces.

Prerequisites

  • NodeSync is enabled in DSE by default. If NodeSync was disabled, enable NodeSync Service.
    Note: Incremental NodeSync is available in DataStax Enterprise 6.8 and later.
  • Create tables for keyspaces you intend to monitor. You cannot enable NodeSync on empty keyspaces in OpsCenter.
  • If OpsCenter authentication is enabled, set user permissions for the NodeSync Service for the applicable user roles and clusters.

Procedure

  1. Select cluster name > Services.
  2. Select Details for the NodeSync Service.
  3. Select the Settings tab.
    Tip: NodeSync Settings shows only keyspaces and tables eligible for NodeSync. Some tables are not shown and are exempt from NodeSync because their keyspace has a replication factor of 1 or is a reserved system keyspace. Select View excluded tables to view the excluded keyspaces and tables.
  4. Select the keyspaces and tables to configure NodeSync for your environment, and then select Configure.
    Note: The default maximum per request is 50 tables. If you encounter schema agreement errors when enabling or disabling multiple tables, increase the value for the max_request_tables option.
  5. Use the toggle buttons to enable NodeSync and incremental NodeSync for the selected keyspaces and tables.

    Enabling NodeSync sends an ALTER TABLE statement that is effective immediately; no DSE restart is necessary.

What's next

Viewing NodeSync Status