search

USGS-WiM / STNServices2

Web services for the Short-Term Network (STN) database
Other
0 stars 0 forks source link

Render a new Test database for STNServices from the current Prod database #153

Closed DanielJBeckman closed 4 years ago

DanielJBeckman commented 4 years ago

Aaron,

This definitely needs your oversight. We recently built out a container based STNservices backend but we believe that the current STNservices test dataset is stale and causing bugs in our testing of the new service. Can we produce a cloned dataset of the current STN Prod database to use to certify the new service?

Concerns: Storm Season is under way and the STN Prod database is taking data. How can we clone it safely?

HansVraga commented 4 years ago

Chiming in here - I think we can use the Prod STN RDS backups in S3 to build a new test STN RDS? A recent backup would suffice - we don't need Prod as it currently is.

aaronstephenson commented 4 years ago

Yes, we can repopulate test from prod using a backup. We have hourly backups available due to Laura. Which should probably be turned off now @lprivette ?

aaronstephenson commented 4 years ago

@PatrickMooreUSGS are you available to assist this week?

lprivette commented 4 years ago

@aaronstephenson last I checked they were still logging data. I'll checkin with athena and make an issue for it if it's time to turn it off.

aaronstephenson commented 4 years ago

Oh in that case no worries. I thought, with the storm past... ¯\_(ツ)/¯ but what do I know about field ops.

DanielJBeckman commented 4 years ago

Sounds like we have a plan then.

aaronstephenson commented 4 years ago

Restore complete. STNTest now has all the data from STN prod as of an hour or so ago.

lprivette commented 4 years ago

did we build a new test RDS or overwrite current test?

aaronstephenson commented 4 years ago

It's new, but has all the same connection info. It should "just work".

lprivette commented 4 years ago

ok whew was just worried for a sec that we have overwritten the existing test DB. SAWSC is doing a training today, but all good. Thanks Aaron!

lprivette commented 4 years ago

@aaronstephenson how does it work if it has all the same connection info? sorry, I'm not understanding how they're different but the same.