SQL

Add partitions periodically in AWS RDS Aurora Cluster (MySQL compatible) with the SQL Procedures

Add partitions periodically in AWS RDS Aurora Cluster (MySQL compatible) with the SQL Procedures

Introduction RDS Aurora is a managed service provided by AWS. Aurora is a OSS compatible relational database built on cloud. In this article, I explain table partitioning with date in RDS Aurora MySQL compatible. Goals Create table partitioned by date on RDS Aurora (MySQL compatible) Add a partition for a day periodically (once a day) Drop records after a certain period of time Handle errors in these operation running As an example, I handle the following hoge table.