- Create an Aurora database with the following properties
- Edition: MySQL
- Instance type: db.t3.small
- A reader node in a different AZ
- Public access should be enabled
- Port should be set to 3306
- DB name: 'db'
- Backup retention: 10 days
- How many instances does your DB cluster has?
-
Go to RDS service
-
Click on "Databases" in the left side menu and click on the "Create database" button
-
Choose "standard create"
-
Choose "Aurora DB"
-
Choose "MySQL" edition and "Provisioned" as capacity type
-
Choose "single-master"
-
Specify Credentials (master username and password)
-
Choose DB instance type: Burstable classes, db.t3.small
-
Choose "Create an Aurora Replica or Reader node in a different AZ"
-
Choose a default VPC and subnet
-
Check "Yes" for public access
-
Database port should be 3306
-
For authentication, choose "Password and IAM database authentication"
-
Set initial database name as "db"
-
Increase backup retention period to 10 days
-
Click on "Create database" button
-
Two instances - one reader and one writer