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.

However, I do have success using backup and restore in MySQL Workbench.

AWS recommend to use percona xtrabackup and put the backup to S3. I've decided to install Percona using docker.