Configuring Auto Scaling for Read Replicas
Scenarios
RDS for PostgreSQL supports auto scaling for read replicas. When the primary instance's CPU usage exceeds the limit for read replica scale-out, RDS will automatically add read replicas. When it falls below the limit for scale-in, read replicas will be automatically removed. Auto scaling for read replicas can handle changes in database load, helping you optimize resource costs and utilization.
Permissions
- To use this feature, submit a service ticket to request required permissions.
- Permissions are required for configuring this feature. For details, see Permissions.
- To use this feature, the RDSAccessProjectResource agency is required and IAM actions (for example, creating and deleting read replicas) must be added. For details, see Permissions.
Constraints
| Phase | Constraints |
|---|---|
| Before auto scaling |
|
| Auto scaling in progress |
|
| After auto scaling |
|
Billing
Auto scaling for read replicas is billed based on the cost of the automatically added read replicas. For details, see RDS Pricing Details.
Configuring Auto Scaling for Read Replicas
- Log in to the RDS console.
- Click
in the upper left corner and select a region. - On the Instances page, click the name of the target primary/standby instance to go to the Summary page.
- Find Auto Scaling for Read Replicas and click Configure. Figure 1 Configuring auto scaling for read replicas
- In the displayed dialog box, configure the required parameters. Figure 2 Configuring the parameters
Table 2 Parameters Parameter
Description
Auto Scale-Out for Read Replicas
It controls whether to enable auto scale-out for read replicas.
Observation Period
- If auto scale-out for read replicas is enabled and the average CPU usage of the primary instance reaches the specified threshold within the observation period, the system automatically adds read replicas. The system then enters a silent period after each successful change.
- The observation period ranges from 5 minutes to 30 minutes.
Max. Read Replicas
It specifies the maximum number of read replicas the system can add. If the total number of manually and automatically created read replicas reaches five, auto scale-out will not be triggered.
Trigger If Avg. vCPU Usage Exceeds
If the average vCPU usage of the primary instance exceeds this threshold during the observation period, the system automatically adds read replicas.
Specifications of New Read Replicas
Specifications of read replicas the system will automatically add.
Auto Scale-In for Read Replicas
Enable it if needed.
Min. Read Replicas
Minimum number of automatically created read replicas the system can keep. Manually created read replicas are not included.
Trigger If Avg. vCPU Usage Drops To
If auto scale-in for read replicas is enabled and the average CPU usage of the primary instance drops below the specified threshold within the observation period, the system removes read replicas. The system then enters a silent period after each successful change.
Silent Period
It is the minimum interval between two changes (triggered automatically or manually). During a silent period, no more auto scaling tasks can be triggered.
NOTICE:The silent period for CPU and memory auto scaling is independent of that for read replica auto scaling. If both features are enabled and neither is in the silent period, the CPU and memory auto scaling task takes precedence. If both are in the silent period, the task whose silent period ends first is executed first.
- Click OK.
Checking the Change History
- On the Instances page, click the name of the target primary/standby instance to go to the Summary page.
- Find Auto Scaling for Read Replicas and click Change History.
- In the displayed dialog box, check the change time, change type, status, original specifications, and new specifications of the historical tasks.
What is your overall rating for this page?
Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot