CODEWITHSUNDEEP
mysqlamazon-web-servicesreplicationsubsetrds
user3469997
user3469997

Reputation: 31

Replicate subset of tables from AWS RDS mysql to another RDS/external mysql instance

The MySQL database that I am using is in an Amazon AWS RDS 5.6. Only 1 of the tables needs to be replicated. The slave can be another AWS RDS MySQL instance. Read replica tables replicates the entire database.

Can what I am describing be done manually or through other means?

Upvotes: 1

Views: 2744

Answers (1)

at0mzk
at0mzk

Reputation: 1942

On RDS MySQL Engine the replication ignore/do table/db options cannot be set. You could create a read replica, set read_only of the read replica to 0 and change the tables you dont need on the slave to BLACKHOLE.

You could also install you own mysql on a EC2 instance where you would have control over all options.

Upvotes: 2

Related Questions