I'd like to create one larger RDS instance and share it across OpsWorks stacks so I can pool the database resources across multiple applications. Here is a reference to the OpsWorks docs for configuring the data sources for an app:
I've tried using the RDS option (under Data Sources) to select an existing RDS instance. However, Opsworks only displays instances that are currently not attached to another Stack.
The only option I can think of is to choose None under Data Sources and then manually configure the deploy JSON for the database settings. One downside to this approach is the hookup is not "automatic" so I'm not sure if any functionality will be lost. Also, I would have to store the database user and password in the Stack JSON which is possibly less secure than the automatic hookup.
Any advice is appreciated.