How to make two Elastic Beanstalk environments share one database instance

Question

I have a rails elastic beanstalk application with two environments, staging and production. When creating the application and staging environment with eb init i created a database instance. I used the eb console to create the production environment and created a new database instance which i perceive is obviously a wrong move.

How do i make my two environments share the same database instance? If that happens, how about when i update the database migrations in my app and deploy to the staging; it means my users would see it because the same database is used by staging environment.

How to i handle this issue?

I also noticed git aws.push doesn't overwrite my database but it doesn't remove rolled back migrations. Am i missing something?

Vadym Fedorov · Accepted Answer · 2013-05-06 19:03:26Z

5

I would recommend to you following option: Create rds instance outside of the elastic beanstalk environment. Create separate schemas for production and staging. Pass connections strings to your EBS application. Shared rds instance between EBS environments will help to you:

Decrease cost of your environment, because to have several rds instances running is expensive.
Help to you isolate production and staging environments.

answered May 6, 2013 at 19:03

Vadym Fedorov

2,4352 gold badges23 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Femi Over a year ago

If i want to agree with you, how do i push my database from localhost independently to the new RDS instance? Remember its rails and a <code>git aws.push</code> does the deployment but with your solution not anymore. So how?

Vadym Fedorov Over a year ago

You can add to your application folder .ebextentions with config files which will contain configuration settings like connection string to db and scripts to run migrations. I would suggest to read article: docs.aws.amazon.com/elasticbeanstalk/latest/dg/…

Vadym Fedorov Over a year ago

I will try to explain my idea one more time be steps: 1. You can manually create rds instance and schemas for production and staging. 2. You can add to your application elastic beanstalk configuration files, where you can define connection string for current database related with staging or production, also you can define here commands for running migrations. 3. To do git aws.push :)

Collectives™ on Stack Overflow

How to make two Elastic Beanstalk environments share one database instance

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related