Configuring tiered storage

DSE Tiered Storage segregates hot and cold data. Configure the storage tier strategy and paths to each tier in an LCM config profile.

CREATE TABLE ks.tbl (k INT, c INT, v INT, PRIMARY KEY (k, c)) 
WITH COMPACTION={'class':'org.apache.cassandra.db.compaction.TieredCompactionStrategy',  
    'tiering_strategy': 'TimeWindowStorageStrategy', 
    'config': 'strategy1',  
    'max_tier_ages': '3600,7200'};

1. Click Config Profiles from the Lifecycle Manager navigation menu.
2. Click the edit icon for the config profile you want to edit, or click Add config profile if you have not already created a profile.
3. In the Config Profile pane under the Cassandra section, click dse.yaml.
4. Scroll down to the Miscellaneous pane and locate tiered_storage_options.

   

5. Click + Add an item under the tiered_storage_options option.
   The Add tiered_storage_opions dialog appears.

   

6. Enter a strategy_name.
   For DSE clusters to use the tiered storage strategy, the strategy must be referenced in the config of the table schema. See Configuring DSE Tiered Storage.
7. Optional: Under local_options, click + Add an item to add local configuration options to overwrite the tiered storage settings in the table schema.
   Note: The class or the tiered storage configuration name cannot be overwritten. For more details and an example, see Testing DSE Tiered Storage configurations.
   The Add local_options dialog appears.

   

8. Enter a key and value for each local option and click Save. For example, type max_tier_ages for key and 3600 for its value.
9. Under tiers, click + Add an item to define the paths to the storage tiers.
   The Add tiers dialog appears.

   

10. Enter the paths to the directory for each tier in the strategy and click Save.
    Tier order of each path matters. Add the paths for each tier in the order that represents each successive tier in a strategy. Each tier added is used in the order listed, with the top tier typically routing data to the fastest storage media.

    Important: Ensure the directories referenced in the path already exist. LCM does not create the directories. If the directories do not exist when the installation or configuration job runs, DSE does not start up.
    The strategy and tiers are added to the config profile.

    

11. Click Save to save the Config Profile.