Upgrading DataStax Enterprise 6.0 to 6.7

Upgrade restrictions and limitations

Restrictions and limitations apply while a cluster is in a partially upgraded state. The cluster continues to work as though it were on the earlier version of DataStax Enterprise until all of the nodes in the cluster are upgraded.

Preparing to upgrade

Follow these steps to prepare each node for the upgrade:

1. Upgrade to the latest patch release on your current version. Fixes included in the latest patch release can simplify the upgrade process.
   Get the current DSE version:

   bin/dse -v
   current_dse_version

2. Familiarize yourself with the changes and features in the new release:
   • DataStax Enterprise 6.7 release notes.
   • General upgrading advice for any version. Be sure to read NEWS.txt all the way back to your current version.
   • DataStax Enterprise changes in CHANGES.txt.
   • DataStax driver changes.
3. Before upgrading, be sure that each node has adequate free disk space.
   Determine current DSE data disk space usage:

   sudo du -sh /var/lib/cassandra/data/
   3.9G	/var/lib/cassandra/data/

   Determine available disk space:

   sudo df -hT /
   Filesystem     Type  Size  Used Avail Use% Mounted on
   /dev/sda1      ext4   59G   16G   41G  28% /

   Important: The required space depends on the compaction strategy. See Disk space
4. Replace ITriggers and custom interfaces.

   All custom implementations, including the following interfaces, must be replaced with supported implementations when upgrading to DSE 6.x:

   • The org.apache.cassandra.triggers.ITrigger interface was modified from augment to augmentNonBlocking for non-blocking internal architecture. Updated trigger implementations must be provided on upgraded nodes. If unsure, drop all existing triggers before upgrading. To check for existing triggers:

     SELECT * FROM system_schema.triggers;

     DROP TRIGGER trigger_name ON keyspace_name.table_name;

   • The org.apache.cassandra.index.Index interface was modified to comply with the core storage engine changes. Updated implementations are required. If unsure, drop all existing custom secondary indexes before upgrading, except DSE Search indexes, which do not need to be replaced. To check for existing indexes:

     SELECT * FROM system_schema.indexes;

     DROP INDEX index_name;

   • The org.apache.cassandra.cql3.QueryHandler, org.apache.cassandra.db.commitlog.CommitLogReadHandler, and other extension points have been changed. See QueryHandlers.
   Tip: For help contact the DataStax Services team.
5. Support for Thrift-compatible tables (COMPACT STORAGE) is dropped. Before upgrading, migrate all tables that have COMPACT STORAGE to CQL table format:

   cqlsh -e 'DESCRIBE FULL SCHEMA;' > schema_file

   cat schema_file | while read -d $';\n' line ; do
     if echo "$line"|grep 'COMPACT STORAGE' 2>&1 > /dev/null ; then
       TBL="`echo $line|sed -e 's|^CREATE TABLE \([^ ]*\) .*$|\1|'`"
       if echo "$TBL"|egrep -v '^system' 2>&1 > /dev/null; then
         echo "ALTER TABLE $TBL DROP COMPACT STORAGE;" >> schema-drop-list
       fi
     fi
   done

   cqlsh -f schema-drop-list

   Note: The script above dumps the compete DSE schema to schema_file, uses grep to find lines containing COMPACT STORAGE, and then writes only those table names to schema-drop-list along with the required ALTER TABLE commands. The schema-drop-list file is then read by cqlsh which runs the ALTER TABLE commands contained therein.
   Warning: DSE will not start if tables using COMPACT STORAGE are present.
6. Upgrade the SSTables on each node to ensure that all SSTables are on the current version:

   nodetool upgradesstables

   Warning: Failure to upgrade SSTables when required results in a significant performance impact and increased disk usage.

   Tip: Use the --jobs option to set the number of SSTables that upgrade simultaneously. The default setting is 2, which minimizes impact on the cluster. Set to 0 to use all available compaction threads. DataStax recommends running the upgradesstables command on one node at a time or when using racks, one rack at a time.

   If the SSTables are already on the current version, the command returns immediately and no action is taken.

7. Ensure that keyspace replication factors are correct for your environment:

   cqlsh --execute "DESCRIBE KEYSPACE keyspace-name;" | grep "replication"
   CREATE KEYSPACE keyspace-name WITH replication = {'class': 'NetworkTopologyStrategy, 'replication_factor': '3'}  AND durable_writes = true;

   • Check the keyspace replication factor for analytics keyspaces.
   • Check the keyspace replication factor for system_auth and dse_security keyspaces.
8. Verify the Java runtime version and upgrade to the recommended version.

   java -version
   openjdk version "1.8.0_222"
   OpenJDK Runtime Environment (build 1.8.0_222-8u222-b10-1ubuntu1~18.04.1-b10)
   OpenJDK 64-Bit Server VM (build 25.222-b10, mixed mode)

   • Recommended: OpenJDK 8 (1.8.0_151 minimum)
     Note: Recommendation changed due to the end of public updates for Oracle JRE/JDK 8. See Oracle Java SE Support Roadmap.
   • Supported: Oracle Java SE 8 (JRE or JDK) (1.8.0_151 minimum)
   Important: Although Oracle JRE/JDK 8 is supported, DataStax does more extensive testing on OpenJDK 8.
9. Run nodetool repair to ensure that data on each replica is consistent with data on other nodes:

   nodetool repair -pr

10. Install the libaio package for optimal performance.
    RHEL platforms:

    sudo yum install libaio

    Debian:

    sudo apt-get install libaio1

11. Back up any customized configuration files since they may be overwritten with default values during installation of the new version.
    Tip: If you backed up your installation using instructions in Backing up and restoring DSE, your original configuration files are included in the archive.

Upgrade steps

1. Flush the commit log of the current installation:

   nodetool drain

2. Stop the node:
   • Package installations:

     sudo service dse stop

   • Tarball installations:

     installation_dir/bin/dse cassandra-stop

3. Use the appropriate method to install the new product version on a supported platform:
   • Package installer using YUM
   • Package installer using APT
   • Binary tarball installer
   Warning: Install the new product version using the same installation type that is on the system, otherwise problems might result.
4. To configure the new version:
   1. Compare changes in the new configuration files with the backup configuration files after the upgrade but before restarting, remove deprecated settings, and update any new settings if required.
      Warning: Do not simply replace new configuration files with old. Rather compare your old files to the new files and make any required changes.
      Tip: Use the DSE yaml_diff tool to compare backup YAML files with the upgraded YAML files:

      cd /usr/share/dse/tools/yamls

      ./yaml_diff path/to/yaml-file-old path/to/yaml-file-new
      ...
       CHANGES 
      =========
      authenticator:
      - AllowAllAuthenticator
      + com.datastax.bdp.cassandra.auth.DseAuthenticator
      
      authorizer:
      - AllowAllAuthorizer
      + com.datastax.bdp.cassandra.auth.DseAuthorizer
      
      roles_validity_in_ms:
      - 2000
      + 120000
      ...

      cassandra.yaml changes

      Table 1. Memtable settings

      Deprecated cassandra.yaml settings:

      memtable_heap_space_in_mb memtable_offheap_space_in_mb

      Replacement setting:

      memtable_space_in_mb

      Changed setting

      memtable_allocation_type: offheap_objects

      Table 2. User-defined function (UDF) settings

      Deprecated cassandra.yaml settings:

      user_defined_function_warn_timeout user_defined_function_fail_timeout

      Replacement settings:

      user_defined_function_warn_micros: 500 user_defined_function_fail_micros: 10000 user_defined_function_warn_heap_mb: 200 user_defined_function_fail_heap_mb: 500 user_function_timeout_policy: die Settings are in microseconds. The new timeouts are not equivalent to the deprecated settings.

      Table 3. Internode encryption settings

      Deprecated cassandra.yaml setting:

      server_encryption_options: store_type: JKS

      Replacement settings:

      server_encryption_options: keystore_type: JKS truststore_type: JKS Valid type options are JKS, JCEKS, PKCS11, or PKCS12 for keystore_type, and JKS, JCEKS, or PKCS12 for truststore_type.

      Table 4. Client-to-node encryption settings

      Deprecated cassandra.yaml setting:

      client_encryption_options: store_type: JKS

      Replacement settings:

      client_encryption_options: keystore_type: JKS truststore_type: JKS Valid type options are JKS, JCEKS, PKCS11, or PKCS12 for keystore_type, and JKS, JCEKS, or PKCS12 for truststore_type.

      dse.yaml changes

      Table 5. Spark resource and encryption options

      Deprecated cassandra.yaml setting:

      spark_ui_options: server_encryption_options: store_type: JKS

      Replacement settings:

      spark_ui_options_options: server_encrption_options: keystore_type: JKS truststore_type: JKS Valid type options are JKS, JCEKS, PKCS11, or PKCS12 for keystore_type, and JKS, JCEKS, or PKCS12 for truststore_type.

5. When upgrading DSE to versions earlier than 5.1.16, 6.0.8, or 6.7.4 inclusive, if any tables are using DSE Tiered Storage, remove all txn_compaction log files from second-level tiers and lower. For example, given the following dse.yaml configuration, remove txn_compaction log files from /mnt2 and /mnt3 directories:

   tiered_storage_options:
       strategy1:
           tiers:
               - paths:
                   - /mnt1
               - paths:
                   - /mnt2
               - paths:
                   - /mnt3

   The following example removes the files using the find command:

   find /mnt2 -name "*_txn_compaction_*.log" -type f -delete &&
   find /mnt3 -name "*_txn_compaction_*.log" -type f -delete

   Warning: Failure to complete this step may result in data loss.
6. Remove any previously installed JTS JAR files from the CLASSPATHS in your DSE installation. JTS (Java Topology Suite) is distributed with DSE 6.7.
7. Start the node.
   • Package installations:

     sudo service dse start

   • Tarball installations:

     installation_dir/bin/dse cassandra

8. Verify that the upgraded datacenter names match the datacenter names in the keyspace schema definition:
   • Get the node's datacenter name:

     nodetool status | grep "Datacenter"
     Datacenter: datacenter-name

   • Verify that the node's datacenter name matches the datacenter name for a keyspace:

     cqlsh --execute "DESCRIBE KEYSPACE keyspace-name;" | grep "replication"
     CREATE KEYSPACE keyspace-name WITH replication = {'class': 'NetworkTopologyStrategy, 'datacenter-name': '3'};

9. Review the logs for warnings, errors, and exceptions:

   grep -w 'WARNING\|ERROR\|exception' /var/log/cassandra/*.log

   Warnings, errors, and exceptions are frequently found in the logs when starting an upgraded node. Some of these log entries are informational to help you execute specific upgrade-related steps. If you find unexpected warnings, errors, or exceptions, contact DataStax Support.

   Tip: Non standard log locations are configured in dse-env.sh.
10. Repeat the upgrade process on each node in the cluster following the recommended order.
11. After the entire cluster upgrade is complete: upgrade the SSTables on one node at a time or, when using racks, one rack at a time.
    Warning: Failure to upgrade SSTables when required results in a significant performance impact and increased disk usage and possible data loss. Upgrading is not complete until the SSTables are upgraded.

    nodetool upgradesstables

    Tip: Use the --jobs option to set the number of SSTables that upgrade simultaneously. The default setting is 2, which minimizes impact on the cluster. Set to 0 to use all available compaction threads. DataStax recommends running the upgradesstables command on one node at a time or when using racks, one rack at a time.
    Important: You can run the upgradesstables command before all the nodes are upgraded as long as you run the command on only one node at a time or when using racks, one rack at a time. Running upgradesstables on too many nodes at once will degrade performance.

General post upgrade steps

After all nodes are upgraded:

1. If you use the OpsCenter Repair Service, turn on the Repair Service.
2. If you encounter serialization-header errors, stop the node and repair them using the sstablescrub -e option:

   sstablescrub -e fix-only keyspace table

   For more details on serialization-header errors and repairs, see DSE 5.0 SSTables with UDTs corrupted after upgrading to DSE 5.1, 6.0, or 6.7

3. DSE 6.7 introduces, and enables by default, the DSE Metrics Collector, a diagnostics information aggregator used to help facilitate DSE problem resolution. For more information on the DSE Metrics Collector, or to disable metrics collection, see DataStax Enterprise Metrics Collector.
4. Spark Jobserver uses DSE custom version 8.0.4.45. Ensure that applications use the compatible Spark Jobserver API from the DataStax repository.

Locking DSE package versions

If you have upgraded a DSE package installation, you can prevent future unintended upgrades.

RHEL yum installations

sudo yum versionlock clear

For details on the versionlock command, see http://man7.org/linux/man-pages/man1/yum-versionlock.1.html.

Debian apt-get installations

sudo apt-mark hold dse-*

sudo apt-mark unhold dse-*

For details on the apt-mark command, see http://manpages.ubuntu.com/manpages/bionic/man8/apt-mark.8.html.