Revision as of 23:34, 28 March 2024

• From: https://www.howtoforge.com/how-to-manage-aws-rds-instance-using-aws-cli/

setup

 aws ec2 create-default-vpc --profile rds_driver_1
 aws ec2 create-default-subnet --availability-zone us-east-1a --profile rds_driver_1

develop

 aws rds describe-db-instances --profile rds_driver_1
 aws rds describe-db-snapshots
 aws rds describe-db-clusters

aws rds create-db-instance \
    --engine sqlserver-se \
    --db-instance-identifier mymsftsqlserver \
    --allocated-storage 250 \
    --db-instance-class db.t3.large \
    --vpc-security-group-ids mysecuritygroup \
    --db-subnet-group mydbsubnetgroup \
    --master-username masterawsuser \
    --manage-master-user-password \
    --backup-retention-period 3

aws rds create-db-instance --db-instance-identifier $dbname \
  --db-instance-class db.t3.micro \
  --engine mysql \
  --master-username $dbuser \
  --master-user-password $dbpasswd \
  --allocated-storage 5 \
  --profile rds_driver_1