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.
DSE Tiered Storage segregates hot and cold data to designated paths on different gradations of storage media, which can facilitate cost savings for data storage. Configure the storage tier strategy and paths to each tier in dse.yaml within an LCM config profile. Run an install or configure job in Lifecycle Manager to push the configuration to all applicable nodes.
After completing this procedure, additional steps are required in DSE to apply tiered
storage to a table using CREATE or ALTER table
statements:
CREATE TABLE ks.tbl (k INT, c INT, v INT, PRIMARY KEY (k, c))
WITH COMPACTION={'class':'TieredCompactionStrategy',
'tiering_strategy': 'DateTieredStorageStrategy',
'config': 'strategy1',
'max_tier_ages': '3600,7200'};
Configure the age policy for each tier at the schema or local node level. For more
information, see configuring and testing configurations for DSE tiered
storage.Procedure
What's next
- Apply tiered storage to a table schema and define the maximum age of data in each tier. See DSE Tiered Storage for complete details.
- Go to the Clusters workspace in Lifecycle Manager and select the config profile to apply at the cluster, datacenter, or node level. Nodes can inherit config profile settings from the cluster or datacenter levels, or have settings at the node level that take precedence.
- Run a configuration job to push the configuration to all of the applicable nodes.
- Add dashboard graphs to monitor data distribution amongst storage tiers using the tiered storage metrics available in OpsCenter.