Closed Bug 661979 Opened 13 years ago Closed 11 years ago

[input] read-only access to input.stage and input.prod databases

Categories

(Data & BI Services Team :: DB: MySQL, task)

Product:
Data & BI Services Team
Component:
DB: MySQL
Platform:
All
Other
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: davedash, Assigned: scabral)

References

Details

For Input we could benefit from RO access to input.stage and input.prod.  We often need to verify data that can't be verified via the web app itself.
Assignee: server-ops → mpressman
Let's do this with the new setup..
Assignee: mpressman → cshields
Blocks: 651148
Corey: Is this on for Q4 or when can the input team expect this to unblock them? Thanks!
Summary: [input] RO access to input.stage and input.prod databases → [input] read-only access to input.stage and input.prod databases
(In reply to Chris More [:cmore] from comment #2)
> Corey: Is this on for Q4 or when can the input team expect this to unblock
> them? Thanks!

This is as soon as we can resolve 651148..  Which is hung up on some problems deploying a fresh copy of input.  (I've worked on it some more this morning, still a lot of issues)

If input installed cleanly in our environment we'd have this all done today  :(
jd is going to start working on the new imput environment, then this will get unblocked (he can work this out with sheeri)
Assignee: cshields → server-ops-database
Component: Server Operations → Server Operations: Database
QA Contact: mrz → cshields
Whiteboard: [waiting on new input env]
Triage : Since this is in DB ops and per comment #4, I'm going to assign this to Sheeri.
Assignee: server-ops-database → scabral
cc'ing :jsocol and :willkg, would you need SQL level read-only access to the new cluster when Fjord goes live?
I haven't had a compelling need to see the db directly for -dev, so I don't think we need it. If we did at some point in the future, we could always deal with it then.

James: Do you think it'd help to have readonly access to the input databases?
:Cww probably does, but that would be to production, so I'm not really sure what the steps are there.
Well, we've moved to the new environment. Do we actually need this still? Adding :cww to this bug.
Whiteboard: [waiting on new input env]
Nope, not if we can get copies of them to sumotools.
Oh! OK, then. will fix invalid and note that bug 850017 is where this lives.
Status: NEW → RESOLVED
Closed: 11 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.