aws-aurora

Create an Aurora MySQL cluster

$ aws rds create-db-cluster --db-cluster-identifier [my-cluster] --engine aurora-mysql --master-username [admin] --master-user-password [password]

$ aws rds create-db-cluster --db-cluster-identifier [my-cluster] --engine aurora-postgresql --master-username [admin] --master-user-password [password]

$ aws rds create-db-instance --db-instance-identifier [my-instance] --db-cluster-identifier [my-cluster] --engine aurora-mysql --db-instance-class [db.r5.large]

$ aws rds describe-db-clusters --query "DBClusters[?Engine=='aurora-mysql' || Engine=='aurora-postgresql']"

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

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

aws rds command [options]

aws rds commands manage Amazon Aurora, a MySQL and PostgreSQL-compatible relational database built for the cloud. Aurora commands operate under the RDS service namespace rather than a separate Aurora namespace.
Aurora clusters consist of a primary writer instance and up to 15 read replicas. Create the cluster first with create-db-cluster, then add instances with create-db-instance. Aurora handles replication automatically across Availability Zones.
Aurora Serverless (engine-mode serverless) automatically scales capacity based on demand. Aurora I/O-Optimized (storage-type aurora-iopt1) provides predictable pricing for I/O-intensive workloads.
Use --manage-master-user-password to have AWS Secrets Manager automatically manage the master password instead of specifying it directly.

create-db-cluster

Create a new Aurora DB cluster

Create a database instance in a cluster

List DB clusters and their details

Modify cluster configuration

Delete an Aurora cluster

Create a manual snapshot of a cluster

Restore a cluster from a snapshot

Create a custom endpoint for read replicas

Force a failover to a replica

Unique identifier for the cluster

Database engine: aurora-mysql, aurora-postgresql

Specific engine version

Master user account name

Master user password (or use --manage-master-user-password)

Instance type (db.r5.large, db.r6g.xlarge, etc.)

Subnet group for the cluster

Security groups for network access

provisioned or serverless

Creating a cluster does not automatically create instances; you must add them separately. Deleting a cluster without --skip-final-snapshot requires specifying a final snapshot identifier. VPC, subnet groups, and security groups must be configured before cluster creation.

Amazon Aurora was announced at AWS re:Invent 2014 and became generally available in July 2015. It was designed to provide MySQL compatibility with significantly improved performance and availability. Aurora PostgreSQL followed in 2017, and Aurora Serverless launched in 2018 for variable workloads.

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