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

EPIC: Support a secondary database #13

Open
obscurerichard opened this issue Dec 26, 2024 · 0 comments
Open

EPIC: Support a secondary database #13

obscurerichard opened this issue Dec 26, 2024 · 0 comments
Labels

Comments

@obscurerichard
Copy link
Member

obscurerichard commented Dec 26, 2024

Story

As a Freezing Saddles administrator, I want to be able to switch between two databases, in order to support database migration between multiple database servers.

Implementation Details

It would be great to have a secondary database source available to freezing-web and freezing-sync so that it would be possible to scale down from the in-season configuration with MySQL Aurora RDS to a built-in MySQL Docker container database server. That would save probably $800 per year in AWS costs.

If the app knew about 2 database sources, and could switch live between them, pausing syncs and new logins/registrations while the transition was underway, this could even be done live during the season.

The extra small version of this would rely on a manual backup / restore procedure and pausing the sync process and maybe configuring the site to prevent logins for a time while maintenance is underway.

The extra large version of this would have database backup and restore included, and be coordinated via messaging between the system components and shared state, either filesystem or an in-memory cache (why don't we have that already?)

@obscurerichard obscurerichard transferred this issue from freezingsaddles/freezing-web Jan 5, 2025
@obscurerichard obscurerichard changed the title Epic: Support a secondary database EPIC: Support a secondary database Jan 5, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
Status: Icebox
Development

No branches or pull requests

1 participant