This is an automated email from the ASF dual-hosted git repository.
dataroaring pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new 6dd75a08b9f Enhance tiering documentation for SSD and HDD (#3254)
6dd75a08b9f is described below
commit 6dd75a08b9f8f22438200c5293407c88e315afec
Author: Vitalii Zurian <[email protected]>
AuthorDate: Mon Jan 5 04:21:32 2026 +0100
Enhance tiering documentation for SSD and HDD (#3254)
Added instructions for manually tiering partitions and managing
heterogeneous clusters.
## Versions
- [ ] dev
- [x] 4.x
- [ ] 3.x
- [ ] 2.1
## Languages
- [ ] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
.../table-design/tiered-storage/tiered-ssd-hdd.md | 37 ++++++++++++++++++++++
1 file changed, 37 insertions(+)
diff --git
a/versioned_docs/version-4.x/table-design/tiered-storage/tiered-ssd-hdd.md
b/versioned_docs/version-4.x/table-design/tiered-storage/tiered-ssd-hdd.md
index 112bc83b96e..89beffcbe1e 100644
--- a/versioned_docs/version-4.x/table-design/tiered-storage/tiered-ssd-hdd.md
+++ b/versioned_docs/version-4.x/table-design/tiered-storage/tiered-ssd-hdd.md
@@ -97,3 +97,40 @@ You should have 7 partitions, 5 of which use SSD as the
storage medium, while th
p20210522：["2021-05-22", "2021-05-23") storage_medium=SSD
storage_cooldown_time=2021-05-24 00:00:00
p20210523：["2021-05-23", "2021-05-24") storage_medium=SSD
storage_cooldown_time=2021-05-25 00:00:00
```
+
+### 3. Manually tiering a partition
+
+You can manually move an individual partition between storage tiers by
updating its `storage_medium` property. For example, to move a partition to HDD
storage:
+
+```sql
+MODIFY PARTITION (partition_name) SET ("storage_medium" = "HDD");
+```
+
+This operation updates the partition’s storage policy and triggers Doris to
relocate the data accordingly.
+
+### 4. Manual tiering in heterogeneous clusters
+
+In heterogeneous cluster setups, it is common to deploy a mix of SSD-backed
nodes for hot data and HDD-backed nodes for cold data. A frequent pitfall in
such environments is failing to distinguish these nodes using location tags.
+
+If all backends share the default location tag, Doris may be unable to tier a
partition down to HDD. This happens because the partition was originally placed
on an SSD node, and Doris cannot locate an HDD storage medium on the same
backend.
+
+To avoid this issue:
+
+1. **Tag cold (HDD) backends with a distinct location**
+
+For example:
+
+```sql
+ALTER SYSTEM MODIFY BACKEND "cold_node1:9050" SET ("tag.location" = "archive");
+```
+
+2. **Explicitly target the tagged backends when modifying the partition**
+
+Specify both the desired storage medium and the replication allocation:
+
+```sql
+MODIFY PARTITION (partition_name) SET ("storage_medium" = "HDD",
"replication_allocation" = "tag.location.archive:1");
+```
+
+
+By assigning location tags and referencing them in the partition’s replication
policy, Doris can correctly place cold data on HDD-backed nodes in
heterogeneous clusters.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
