Implement advanced replication features with Amazon RDS for MySQL and Amazon Aurora MySQL using intermediate replication servers
Database Blog
This article explains how to implement advanced replication features like multi-source replication and replication filtering for Amazon RDS for MySQL and Amazon Aurora MySQL using an intermediate replication server.
Specifically, the article covers:
- Overview of MySQL binary log replication
- Solution overview for multi-source replication and replication filtering
- Setting up the replication sources (Amazon RDS for MySQL instances)
- Setting up the intermediate MySQL instance in Amazon EC2
- Setting up the replication target (Amazon Aurora MySQL cluster)
- Configuring multi-source replication from RDS for MySQL to the EC2 instance
- Configuring replication from the EC2 instance to Aurora MySQL
- Demonstrating multi-source replication with schemas replicated from different sources
- Implementing replication filtering to ignore specific tables
- Using the BLACKHOLE storage engine as an alternative filtering method
- Conclusion on the benefits of this solution
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
Feb 6
2024
2024
Introducing multi-source replication on Amazon RDS for MySQL
Oct 21
2025
2025
Overview and best practices of multithreaded replication in Amazon RDS for MySQL, Amazon RDS for MariaDB, and Amazon Aurora MySQL
May 28
2024
2024
Create a fallback migration plan for your self-managed MySQL database to Amazon Aurora MySQL using native bi-directional binary log replication
Oct 21
2025
2025
Monitoring multithreaded replication in Amazon RDS for MySQL, Amazon RDS for MariaDB, and Aurora MySQL
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.