AWS MySql RDS

Posted under » MySQL » AWS on 15 May 2025

Amazon Relational Database Service (or Amazon RDS) is designed to simplify the setup, operation, and scaling of a relational database for use in applications. Administration processes like patching the database software, backing up databases and enabling point-in-time recovery are managed automatically.

You can have the latest version of MySQL 8.4.5. You can choose to deploy to multi-AZ which is good for data redundancy.

I choose the smallest possible for dev class: db.m7g.large. 2 cores, RAM 8gb with 20gb storage (3k IOPS).

AWS does not offer an SSH connection to the underlying virtual machine as part of the managed service.

The basic default daily snapshot /backup is 7 days worth in case you messed up.

It is easy to backup and restore easily when running MySQL local db but it is a hassle in AWS.

The recommended way is to use percona xtrabackup and put the 'SQL dump' to S3. I've decided to install Percona using docker. AWS enable you to backup using S3 but you can also backup from a local MySQL db.

$ apt update