Posted On: Jan 16, 2024

Amazon Relational Database Service (Amazon RDS) for MySQL now supports multi-source replication, which allows you to configure multiple RDS for MySQL database instances as sources for a single RDS for MySQL target database instance. Multi-source replication on RDS for MySQL enables you to merge multiple shards into a single target, or consolidate data in one RDS for MySQL instance for analytics, or long-term backups.

For every target RDS for MySQL instance, you can configure up to 15 RDS for MySQL source database instances. For read scaling, you can configure read replicas on the multi-source replication target instance. Multi-source replication is available on RDS for MySQL versions 5.7.44, 8.0.35 and higher minor versions. To learn more about multi-source replication on Amazon RDS for MySQL, refer to the Amazon RDS for MySQL User Guide.

You can launch a new RDS for MySQL DB instance in the Amazon RDS Management Console or using the AWS CLI. To learn more about the pricing for Amazon RDS for MySQL, please refer to the pricing page.