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 should be aware of AWS MySQL deprecation timeline.

You can have the latest (as of May 26) version of MySQL 8.4.8. 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. You can connect via 3306 using mysql client. In order to do this, you have to enable inbound both for the RDS and the EC2.

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

It is easy to backup and restore when running MySQL locally db but in AWS you will need to use the same version. I am using MySQL 8.4.8 version and I need to use this because locally I am using version 8.3.6

$ mysqldump --set-gtid-purged=OFF --single-transaction --routines --triggers --events -u admin --host=db.coblhguv.ap-southeast-1.rds.amazonaws.com -p anoneh > 01.sql
$ mysql --host=db.coblhguv.ap-southeast-1.rds.amazonaws.com -u admin -p anoneh < lti.sq

AWS RDS MySQL standard support is 1 year. For eg. MySQL RDS 8.4.8 version was released on 3 February 2026. Standard support will end on 3 February 2027.

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