What Is the Time Delay for Primary/Standby Replication?
When standby instances cannot keep up with the updates on the primary, this generates replication delay. If the standby SQL and I/O thread are running, the replication delay is a positive value measured in seconds. If the standby SQL thread is not running, or if the SQL thread has consumed all of the relay log and the standby I/O thread is running, then it is NULL (undefined or unknown)
The delay for primary/standby replication cannot be calculated using a formula as the delay is affected by the following factors:
- Network communication status
- Transaction workload on the primary DB instance in transactions per second (TPS)
- The size of the transaction executed by the primary DB instance (this affects the duration of transaction executions)
- Load balancing of the standby DB instance and read replicas
If the primary DB instance has a heavy load for a certain period of time and executes a large number of transactions per second, replication to the standby DB instance will be delayed. This delay is generally a few seconds.
- RDS for MySQL: Click the DB instance name on the Instances page. The replication source is the primary DB instance. When the replication status is normal, view Real-Time Replication Delay to obtain the value of the primary/standby replication delay.
- RDS for PostgreSQL: To check data consistency between the primary and standby DB instances, view Replication Lag on the Cloud Eye console to obtain the value of the primary/standby replication delay.
- RDS for SQL Server: To check data consistency between the primary and standby DB instances, view Replication Delay on the Cloud Eye console to obtain the value of the primary/standby replication delay.
Product Consulting FAQs
- What Should I Pay Attention to When Using RDS?
- What Is the Availability of RDS DB Instances?
- How Do I Distinguish Between General-Purpose and Dedicated RDS for MySQL Instances Using Cloud SSDs?
- Will My RDS DB Instances Be Affected by Other User Instances?
- Does RDS Support Cross-AZ High Availability?
- Can RDS Primary/Standby DB Instances Be Changed to Single DB Instances?
- What Can I Do About Slow Responses of Websites When They Use RDS?
- Can I Change the Replication Mode Between Primary DB Instances and Read Replicas?
- What Is the Time Delay for Primary/Standby Replication?
- Can Multiple ECSs Connect to the Same RDS DB Instance?
- Can I Encrypt the Disk After Purchasing an RDS DB Instance?
- Will Backups Be Encrypted After Disk Encryption Is Enabled for My RDS Instance?
- Does RDS for MySQL Support Encryption Functions?
- What Are the Restrictions on RDS for MySQL DB Instances After GTID Is Enabled?
- Will Different RDS DB Instances Share CPU and Memory Resources?
- How Many Databases Can Run on an RDS DB Instance?
- Is RDS for MySQL Compatible with MariaDB?
- Does RDS for MySQL Support TokuDB?
- What Is the Maximum Size Allowed for a Single Table in RDS for MySQL Instances?
Feedback
Was this page helpful?
Provide feedbackThank 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.
Chatbotmore