Amazon Aurora MySQL now supports multi-source replication and delayed replication

Amazon Aurora MySQL Release Notes

Starting today, Amazon Aurora MySQL supports two new replication capabilities: multi-source replication and delayed replication.

Multi-source replication

Multi-source replication lets a single Aurora MySQL cluster replicate from multiple source databases at the same time, making it easier to consolidate data from separate MySQL databases. This enables critical use-cases, such as merging shards or aggregating data from separate databases into a central location for operational workflows.

Delayed replication

Delayed replication lets you configure a binlog replica to intentionally lag behind its source by a set period of time, providing a safeguard against human error and logical data corruption. If a harmful change is made on the source, you can recover quickly by stopping replication to the replica before the change is applied and promoting it.

What to do

• Refer to the MySQL multi-source replication documentation for more information.
• Refer to the MySQL delayed replication documentation for more information.

Source: AWS release notes

If you need further guidance on AWS, our experts are available at AWS@westloop.io. You may also reach us by submitting the Contact Us form.