Abnormal Replication Between Primary and Standby RDS DB Instances

Scenario

The replication relationship between primary and standby RDS DB instances is abnormal. The default security group rule may have been deleted.

Solution

1. Log in to the management console.
2. Click in the upper left corner and select a region.
3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
4. On the Instances page, click the target instance name.
5. On the Overview page, click the security group name.
6. On the Inbound Rules tab, click Add Rule. In the displayed dialog box, select All for Protocol & Port and Security group for Source. In the drop-down list, select the same security group as the displayed one on the Basic Information page.
7. Wait until the rule is added. Check that the replication relationship between primary and standby DB instances is restored.