Can I Change the Replication Mode Between Primary DB Instances and Read Replicas?
- For the MySQL engine:
A read replica uses a single-node architecture (without a standby node). Changes to the primary DB instance are also automatically synchronized to all associated read replicas through the native MySQL replication function. The synchronization is not affected by network latency. Even if a DB instance does not have a primary key ID, its data is synchronized to the associated read replicas.
The replication mode displayed on the RDS console indicates the data synchronization method between primary and standby DB instances. Semi-synchronous and asynchronous are both supported. The semi-synchronous mode is more secure but the asynchronous mode improves performance.
The default synchronization between primary DB instances and read replicas is asynchronous and cannot be changed.
- For the Microsoft SQL Server engine:
The synchronous-commit mode is supported between primary and standby instances and cannot be modified.
The asynchronous-commit mode is supported between primary instances and read replicas and cannot be modified.
For more information, see official documentation.
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