Replication: External MySQL to Aurora MySQL - Replication filters

Question

Hi,  We are considering a replication setup where we would like to replicate only a few tables from an "external" MySQL instance (replication source - hosted in EC2) to Aurora MySQL (replication target).   I am wondering whether Aurora MySQL supports replication options similar to `--replicate-do-table` and `--replicate-rewrite-db` MySQL options so that we could replicate only a few select tables to Aurora.

I have provided links to the documentation of the above MySQL options below:
* https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html#option_mysqld_replicate-do-table 
* https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html#option_mysqld_replicate-rewrite-db

Accepted Answer

Hi,

Thank you so much for asking your question.

Yes, Aurora MySQL supports replication filter using parameters below as cluster-level parameter since Aurora MySQL3. However, unfortunately, `replicate-rewrite-db` is not supported.

* replicate-do-db
* replicate-do-table
* replicate-ignore-db
* replicate-ignore-table
* replicate-ignore-db
* replicate-ignore-table
* replicate-wild-do-table
* replicate-wild-ignore-table

For more detail, please refer to the Aurora MySQL document.
- https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Reference.ParameterGroups.html

I hope this might help.

Replication: External MySQL to Aurora MySQL - Replication filters

Relevanter Inhalt