1023561 - New staging mysql database for RelEng mapper application (https://wiki.mozilla.org/ReleaseEngineering/Applications/Mapper)

Status: RESOLVED FIXED

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

Description

[Pete Moore [:pmoore][:pete]]

Mapper is a RelEngAPI application. We are currently sharing a mysql schema for staging mapper with staging RelEngAPI itself:

mysql://[e-mail]/relengapi_stage

However, we would like to have a separate database for Mapper and RelEngAPI to separate these concerns.

It would be good if they could be hosted on the same instance.

Please note, the primary user of the Staging Mapper database will be the RelEngAPI staging cluster, which currently has the following (one) host:

web1.stage.releng.webapp.scl3.mozilla.com

Database size is likely to be ~ 1GB or less.

No strict backup requirements - we can blow away and create from scratch relatively easily.

I've raised a very similar bug for production too (bug 1023555). The difference between these two bugs is that this one pertains to staging - the other pertains to production.

Many thanks,
Pete

Comment 1

[Matt Pressman [:mpressman]]

stage database named mapper created on same host as releng_api_stage. I will email you the credentials

Comment 2

[Matt Pressman [:mpressman]]

sorry database name is mapper_stage

Comment 3

[Matt Pressman [:mpressman]]

Credentials emailed

Comment 4

[Pete Moore [:pmoore][:pete]]

Thanks for that Matt. I was able to migrate our staging environment to use the new schema, populate it, remove the tables from the old schema etc - so all good!

Pete