Configuring tiered storage
DSE Tiered Storage segregates hot and cold data. Configure the storage tier strategy and paths to each tier in an LCM configuration profile.
Procedure
- Click Config Profiles from the Lifecycle Manager navigation menu.
- Click the edit icon for the configuration profile to edit, or click Add config profile if you have not already created a profile.
- In the Config Profile pane under the Cassandra section, click dse.yaml.
-
Scroll down to the Miscellaneous pane and locate
tiered_storage_options
. -
Click + Add an item under the
tiered_storage_options
option.The Add tiered_storage_opions dialog displays. -
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. - 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 displays.
- Enter a key and value for each local option. For example, type max_tier_ages for key and 3600 for its value.
- Click Save.
-
Under tiers, click + Add an item to
define the paths to the storage tiers.
The Add tiers dialog displays.
- Click Save to save the Config Profile.
What's next
- Apply tiered storage to a table schema using
CREATE
orALTER
table statements, and define the maximum age of data in each tier. See Configuring DSE Tiered Storage and Testing DSE Tiered Storage configurations for complete details.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'};
- Go to the Clusters workspace in Lifecycle Manager and select the configuration profile to apply at the cluster, datacenter, or node level. Nodes can inherit configuration 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 and alerts to monitor data distribution amongst storage tiers using the tiered storage metrics available in OpsCenter.