Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Use db-config pre-seeding to handle database updates #30

Open
abmargb opened this issue Sep 2, 2014 · 2 comments
Open

Use db-config pre-seeding to handle database updates #30

abmargb opened this issue Sep 2, 2014 · 2 comments

Comments

@abmargb
Copy link
Collaborator

abmargb commented Sep 2, 2014

Although our deb packages support db-config, right now we don't use it in the Dockerfiles. We simply install the packages with a fake connection info and then stage the proper configuration.

Having db-config pre-seeding in place will make DB upgrades a lot smoother.

@abmargb
Copy link
Collaborator Author

abmargb commented Sep 2, 2014

@imaginator
Copy link
Member

What about having the server startup and apply any new versions to the DB automatically? I generally don't like this servers changing database schemas behind the admin's back ([schema upgrade starts]"Why is this taking so long to startup? I'm going to restart again. And again" leading to db corruption.)

I guess wrapping the entire upgrade in a transaction could help. Either way, I think it's dangerous to have a new version of a server roll a schema forward. Then if something doesn't work, there's no easy rollback.

I'll have another coffee and think about this more.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants