From what I can tell, one can't change the Amazon RDS (RDS) endpoint of an existing Elastic Beanstalk (EB) instance?
If that is the case, than you can't have your code deployed to a stage server, stage DB, tested, then promoted to use the prod DB?
So how do you deploy stage without having to test against the prod db?
Given prod and stage, I thought the strategy would be something like this:
- Snapshot prod RDS
- Create stage with new code and point it at the snapshot
- QA stage
- Point stage to prod RDS
- Change load balancer to send traffic to stage