Create AWS RDS Multi-AZ
1. Go to AWS RDS console.
2. In the left sidebar,
- Choose Databases.
- Click Create database.
3. In the Choose a database creation method section, select Standard create.
4. In the Engine options section,
- For Engine type, select PostgreSQL.
- For Engine Version, select PostgreSQL 16.3-R2.
5. In the Templates section, select Production.
6. In the Availability and durability section, select Multi-AZ DB instance.
7. In the Settings section,
- For DB instance identifier, enter
awsome-books. - For Master username, enter
postgres. - For Credentials management, choose Managed in AWS Secrets Manager - most secure.
8. In the Instance configuration section, select Burstable classes (includes t classes) and db.t3.micro.
9. In the Storage section,
- For Storage type, select General Purpose SSD (gp3).
- For Allocated storage, enter 20.
10. In the Connectivity section,
- For Virtual private cloud (VPC), select the VPC named fcj.
- For DB subnet group, choose awsome-books.
- For Public access, select No.
- For VPC security group (firewall), select Choose existing.
- For Existing VPC security groups, select fcj-db.
11. In the Monitoring section, turn off Turn on Performance Insights.
12. In the Additional configuration section,
- For Initial database name, enter
awsome_books.
- For Deletion protection, turn off Enable deletion protection (do not do this in real world projects).
13. Scroll down to the bottom, click Create database.
It migh take a while to create AWS RDS intances and the secret in AWS Secrets Manager.
14. Note down the Endpoint of the database server you have just created.
15. Go to AWS Secrets Manager console.
16. Note down the Secret name, you might need it later!
