PolarDB | Data Lifecycle Management - Automatic Table Partitioning & Cold Data Archiving
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.
⏰Timelines:
00:00 - What is PolarDB for MySQL Data Lifecycle Management (DLM)
02:48 - What you can use PolarDB DLM for?
03:40 - Demo | How to perform hot data partitioning and cold data archiving to OSS?
03:58 - Enable cold data archiving
04:34 - Create an event to run scheduled jobs to archive cold data
05:07 - Partition table by order time through interval range partition
06:59 - Check archiving data size
07:18 - end
🎁【Get PolarDB Free Trials】
https://www.alibabacloud.com/product/...
📚【Related Documentations】
https://www.alibabacloud.com/help/en/...
https://www.alibabacloud.com/help/en/...
https://www.alibabacloud.com/help/en/...
💡【PolarDB Hands-on Tutorial on Github】
https://github.com/ApsaraDB/PolarDB-H...
💡【More About PolarDB Table Partitioning】
https://www.alibabacloud.com/help/en/...