902012 - create database and user permission for bedrock dev/demo{123}/stage/prod environments

Status: RESOLVED FIXED

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

Description

[Chris Turra [:cturra]]

per bug 901078, bedrock (www.mozilla.org) will be using a database moving forward. it looks like there was a bug for this in the past (bug 753566), but to keep things clean, i wanted to open a new one for the purpose of this change.

we need databases and users setup for the following environments:

 dev:
  - www-dev.allizom.org

 demo:
  - www-demo1.allizom.org
  - www-demo2.allizom.org
  - www-demo3.allizom.org

 stage:
  - www.allizom.org

 prod:
  - www.mozilla.org


all of these requests will be coming through zeus.

Comment 1

[Sheeri Cabral [:sheeri]]

The db in bug 753566 is for production. 

Do you actually want the db names to have . in them? I have no problem with that, but traditionally we've used _

Also, - in db names is somewhat annoying, because it has to be escaped. 

We have separate dev and stage servers in scl3, where should demo go? on stage or dev?

Comment 2

[Chris Turra [:cturra]]

i didn't mean to state those were the database names i was looking for, just the environments we need to have databases available in.

looks like dev and stage had previously been created, so we can skip those. prod however still needs to be done. to ahead and make that with whatever name names sense to you :)

Comment 3

[Sheeri Cabral [:sheeri]]

dev/demo should all be in dev on phx, stage should go to stage in scl3, and prod should go to bedrock.

We'll need ro and rw users for all of these.

Comment 4

[Sheeri Cabral [:sheeri]]

correction:

dev/demo/stage should all be in dev on phx, and prod should go to bedrock.

We'll need ro and rw users for all of these.

Comment 5

[Sheeri Cabral [:sheeri]]

All rw and ro users and dbs made, there's a key in your homedir on bedrock1 in scl3 called bedrock.txt with a guide to the users, dbnames, passwords and grants.