Aurora MySQL creation guide for standard use

• outline

Creating Aurora MySQL have many options to choose and types. I will provide Aurora MySQL creation guide for standard use.

• requirement (before creating RDS)

VPC
Least 2 private subnets
Security Group for RDS
RDS Subnet Group 
RDS Custom Paramater group

• Options and type for RDS

Choose a database creation method : Standard create
Engine options
 Engine type : Aurora (MySQL Compatible) 
 Engine version : 3.05.1 (latest)
Templates : "Production"
Settings
 DB cluster identifier : rds-<project>-<env>
 Master username : <random-number>rds-<project>-<env><random-number>
 Master password : <random-number><project>-root-<env><random-number>
Cluster storage configuration
 Configuration options : "Aurora Standard"
Instance configuration
 DB instance class : "Serverless v2"
 Minumum ACUs : 2 // Maximum ACUs : 8
Availability & durability
 Multi-AZ deployment : "Create an Aurora Replica or Reader node in a different AZ (recommended for scaled availability)"
Connectivity
 Compute resource : "Don’t connect to an EC2 compute resource"
 Network type : "IPv4"
 Virtual private cloud (VPC)
 DB subnet group : subgrp-<project>-<env>
 Public access : No
 VPC security group (firewall) : "Create new"
 New VPC security group name : securitygroup-rds-<project>-<env>
 Certificate authority : rds-ca-rsa2048-g1
 Additional configuration : Database port : custom-port
Monitoring
 Performance Insights
  Turn on Performance Insights : Uncheck for Dev, check for Production
 Additional configuration
  Enable Enhanced Monitoring : Uncheck for Dev, check for Production  
Additional configuration 
 Database options 
  DB cluster parameter group : paramgrp-<project>-<env>-mysql<version>
 Backup
  Backup retention preiod
   3 days for Dev, 7 or 14 days for Production 
  Check "Copy tags to snapshots"
 Encryption : Uncheck "Enable encryption" 
 Maintenance
  Enable auto minor version upgrade" : Check for Dev, uncheck for Production
 Maintenance window : "Choose a window" : UTC and night time
 Deletion protection : Check "Enable deletion protection"