PolarDB is compatible with MySQL partition types of hash, range, list, range-hash, and list-hash. PolarDB 22.214.171.124.0 and later support composite partitions and more partition types.
Through partition table, you are able to manage data lifecycle easily and decide when to remove cold data into lower-cost storage (OSS) to save costs, similar to data tiring technology. It's suitable for scenarios like E-Commerce and retail.
To achieve historical data archiving and hot data partitioning, you would need Data Lifecycle Management (DLM) which provides you the most efficient way of data management.
Watch video to learn more.
🎁【Get PolarDB Free Trials】
💡【PolarDB Hands-on Tutorial】
💡【More About PolarDB Table Partitioning】
ApsaraDB - December 29, 2021
Alibaba EMR - February 20, 2023
Alibaba Clouder - December 21, 2020
zhuoran - February 5, 2021
Alibaba Clouder - December 29, 2020
Alibaba Cloud MaxCompute - January 15, 2019
TSDB is a stable, reliable, and cost-effective online high-performance time series database service.Learn More
Alibaba Cloud provides big data consulting services to help enterprises leverage advanced data technology.Learn More
Alibaba Cloud PolarDB is a cloud-native relational database service that decouples computing resources from storage resourcesLearn More
Designed to address database challenges such as ultra-high concurrency, massive data storage, and large table performance bottlenecks.Learn More
More Posts by ApsaraDB