cybergreen-net / pm

Tech project management repo (issue tracker only)
2 stars 1 forks source link

Reduce / remove API data downtime during updates #58

Closed chorsley closed 7 years ago

chorsley commented 8 years ago

When we load data into RDS, there's currently a 20 minute site outage while the data is loaded.

This should be performed as a near-atomic operation (e.g. loaded into temp tables first), so there is very little downtime.

rufuspollock commented 8 years ago

@chorsley i'd suggest that we load into a new RDS instance and switch the frontend to a new database instance. That also allows for fallback if something breaks.

aaronkaplan commented 7 years ago

okay. when and how? And what's exactly needed to test this? (note: that's part of atomatic SoW). @rgrp please propose an actionable solution which we can test in the next weeks.

rufuspollock commented 7 years ago

@aaronkaplan i would say this is a dependency on the orchestrator setup so this will be blocked on that. Also this issue was moved to https://github.com/cybergreen-net/infrastructure/issues/6 - let's update there.

rufuspollock commented 7 years ago

DUPLICATE of https://github.com/cybergreen-net/infrastructure/issues/6