MySQL

MySQL major version 8 was released on April 2018. I introduce how to write MySQL 8 ansible playbook. Motivation I usually use AWS. AWS has a database managed service called RDS, and RDS supports MySQL 5.x series. To conduct in-house training using MySQL 8, I needed to make AMI of MySQL 8 with ansible. Environment CentOS 7 Ansible 2.6.1 Packer 1.1.3 Configuration sample of ansible playbook In this case, I describe only the main task definition part in Ansible, I omit Packer configuration because it becomes redundant.

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.