Step 1 – Setup MySQL Read Replica instance
- Select RDS MySQL instance
- Click on Actions > Create read replica
Step 2 – Configure read replica DB instance
- DB instance class
Select Database instance class of your choice.
- Multi-AZ deployment
Choose Multi-AZ deployment for high availability (i.e. for production workloads)
- Storage type
Choose Provisioned IOPS (SSD) for high performance (i.e for production workloads)
Network & Security
- Destination region
- Destination DB subnet group
- Availability Zone
- Publicly accessible
Strongly recommended to keep database instances in private subnets and not publicly accessible.
- VPC security groups
Enable encryption if required for compliance.
Verify Read replica source and name DB instance identifier
Default port is 3306
Enable IAM DB authentication for easier user authentication.
Configure enhanced monitoring for production workloads.
Configure Error log, General log and Slow query log for production workloads.
Allow minor version upgrades.
Step 3 – Wait for instance to be created
Primary instance will go to Modifying state for a few minutes. If the primary is not using Multi AZ setup, performance of the primary may have an impact.
Primary instance will go to Available once a copy of the database is taken.
Primary and Replica will go to Available once replication is successful.
Check Connectivity & security tab Replication area to ensure that Replication state is Replicating
Step 4 – Connect to the instance
Connect to bastion instance.
Connect to database instance.