RDS best practices are as follows:
- Create an individual AWS IAM user to perform DBA tasks. Grant the minimum privileges required to perform day-to-day tasks. Remove unused access key and secret key. Have a strong password policy and rotate the password periodically.
- Before creating an RDS instance, identify Amazon RDS essential characteristics to be specified such as VPC, security group, failover or Read Replica requirement, the region and AZs to use, and storage and backup requirements.
- Before creating an RDS instance, it is recommended that you create a DB options group and DB parameter group.
- Monitor Amazon RDS instance resources, such as CPU, memory, and storage, to avoid performance bottlenecks.
- It is recommended that you keep some extra buffer in memory and a storage volume while choosing RDS instance types.
- It is recommended that you test your environment...