“aws rds” Command Examples

The aws rds command is a part of the AWS Command Line Interface (CLI) and serves as a CLI tool for interacting with AWS Relational Database Service (RDS). AWS RDS is a fully managed database service that simplifies the process of setting up, operating, and scaling relational databases in the cloud.

Here’s an overview of the aws rds command and its functionality:

  • Database Instance Management: The aws rds command allows you to create, modify, and delete database instances in AWS RDS. You can specify the database engine (such as MySQL, PostgreSQL, Oracle, or SQL Server), allocate resources (CPU, memory, storage), and configure various settings for your database instances.
  • Database Engine Options: AWS RDS supports multiple database engines, and the aws rds command provides options to manage specific engine-related configurations. You can set parameters, adjust storage, enable backups and automated snapshots, and configure replication for supported engines.
  • Multi-AZ Deployments: AWS RDS offers Multi-AZ deployments for high availability and failover protection. The aws rds command allows you to create and manage Multi-AZ database instances, ensuring that a standby replica is automatically maintained in a different Availability Zone.
  • Database Backup and Restore: With the aws rds command, you can manage database backups and restores. You can initiate automated backups, create manual snapshots, restore databases from snapshots, and configure backup retention settings.
  • Monitoring and Performance: AWS RDS provides monitoring and performance insights for database instances. The aws rds command enables you to retrieve and configure metrics, set up alarms, and analyze database performance using Amazon CloudWatch.
  • Security and Access Control: The aws rds command allows you to manage security and access control for your RDS instances. You can configure database instance security groups, set up encryption for data at rest and in transit, manage database credentials, and control user access to the database.
  • Database Parameter Groups: AWS RDS supports parameter groups that allow you to manage database engine configurations. The aws rds command provides options to create, modify, and delete parameter groups, enabling you to fine-tune the behavior and settings of your database engines.

The aws rds command provides a convenient way to manage and automate various tasks related to AWS RDS through the command line. It allows you to create, configure, and manage your relational databases, ensuring efficient operations and scalability for your applications.

aws rds Command Examples

1. Show help for specific RDS subcommand:

# aws rds subcommand help

2. Stop instance:

# aws rds stop-db-instance --db-instance-identifier instance_identifier

3. Start instance:

# aws rds start-db-instance --db-instance-identifier instance_identifier

4. Modify an RDS instance:

# aws rds modify-db-instance --db-instance-identifier instance_identifier parameters --apply-immediately

5. Apply updates to an RDS instance:

# aws rds apply-pending-maintenance-action --resource-identifier database_arn --apply-action system-update --opt-in-type immediate

6. Change an instance identifier:

# aws rds modify-db-instance --db-instance-identifier old_instance_identifier --new-db-instance-identifier new_instance_identifier

7. Reboot an instance:

# aws rds reboot-db-instance --db-instance-identifier instance_identifier

8. Delete an instance:

# aws rds delete-db-instance --db-instance-identifier instance_identifier --final-db-snapshot-identifier snapshot_identifier --delete-automated-backups
Related Post