I am currently looking on how to set up replication for my application on Amazon RDS. I know that it is possible to have either read replicas for better read performance or Multi-AZ replication for better error handling. However from what I read in the documentation, it seems that I am only able to replicate the whole RDS instance.
In my database, there are only some smaller tables that need replication, others are log tables or could be easily recreated. So replicating the complete instance would be too expensive as this is only a minor part of my database.
In a "traditional" MySQL setup, I can replicate single databases or single tables only. Is this also possible on Amazon RDS?
