aws-rds

Create a MySQL database instance

$ aws rds create-db-instance --db-instance-identifier [my-db] --db-instance-class db.t3.micro --engine mysql --master-username admin --master-user-password [password] --allocated-storage 20

$ aws rds describe-db-instances

$ aws rds describe-db-instances --db-instance-identifier [my-db]

$ aws rds create-db-snapshot --db-instance-identifier [my-db] --db-snapshot-identifier [my-snapshot]

$ aws rds restore-db-instance-from-db-snapshot --db-instance-identifier [new-db] --db-snapshot-identifier [my-snapshot]

$ aws rds modify-db-instance --db-instance-identifier [my-db] --db-instance-class db.t3.small --apply-immediately

$ aws rds create-db-instance-read-replica --db-instance-identifier [my-replica] --source-db-instance-identifier [my-db]

$ aws rds delete-db-instance --db-instance-identifier [my-db] --skip-final-snapshot

aws rds command [options]

aws rds is the AWS CLI interface for Amazon Relational Database Service (RDS), a managed service for relational databases. RDS handles provisioning, patching, backups, and recovery for MySQL, PostgreSQL, MariaDB, Oracle, SQL Server, and Amazon Aurora.
RDS provides automated backups, point-in-time recovery, read replicas for scaling, Multi-AZ deployments for high availability, and encryption at rest. Aurora extends RDS with MySQL and PostgreSQL-compatible databases with enhanced performance.

create-db-instance

Create a new database instance

Terminate a database instance

List and describe instances

Change instance configuration

Restart a database instance

Start a stopped instance

Stop a running instance

Create a manual backup

Restore from backup

Create a read replica

Create an Aurora cluster

Trigger Aurora failover

Instance modifications may cause brief downtime unless Multi-AZ is enabled. Storage can only be increased, not decreased. Some engine versions cannot be downgraded. Final snapshots are recommended before deletion but incur storage costs.

Amazon RDS launched in October 2009 with MySQL support. PostgreSQL was added in 2013, Aurora in 2014. Multi-AZ deployments, read replicas, and encryption options have expanded over time. Blue/Green deployments for zero-downtime upgrades launched in 2022.

aws(1), aws-aurora(1), mysql(1), psql(1)