PolarDB is compatible with MySQL partition types of hash, range, list, range-hash, and list-hash. PolarDB 8.0.2.2.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】
https://www.alibabacloud.com/product/polardb
📚【Related Documentations】
https://www.alibabacloud.com/help/en/polardb/latest/overview1
https://www.alibabacloud.com/help/en/polardb/latest/async-metadata-lock-replication
https://www.alibabacloud.com/help/en/polardb/latest/create-an-interval-range-partition
💡【PolarDB Hands-on Tutorial】
https://community.alibabacloud.com/series/155
💡【More About PolarDB Table Partitioning】
https://www.alibabacloud.com/help/en/polardb/latest/partitioned-tables
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 MoreAlibaba Cloud provides big data consulting services to help enterprises leverage advanced data technology.
Learn MoreAlibaba Cloud PolarDB is a cloud-native relational database service that decouples computing resources from storage resources
Learn MoreDesigned to address database challenges such as ultra-high concurrency, massive data storage, and large table performance bottlenecks.
Learn MoreMore Posts by ApsaraDB