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.