We are using Amazon RDS and would like to know (if even possible) if we can setup several slave databases to have different master databases? For example:

Slave #1 will have his master slave as Master #1 When needed we can change the master slave for Slave #1 to be Master #2 instead.