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
ApsaraDB - August 21, 2024
zhuoran - February 5, 2021
Alibaba Clouder - December 29, 2020
Alibaba Cloud PolarDB for MySQL is a cloud-native relational database service 100% compatible with MySQL.
Learn MoreTSDB 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 MoreSecure and easy solutions for moving you workloads to the cloud
Learn MoreMore Posts by ApsaraDB