842744 - create database and user permission for badges prod environment

Status: RESOLVED FIXED

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

Description

[Chris Turra [:cturra]]

we are launching a new web app on the generic web cluster called badges for the openbadges initiative. there are currently dev and stage databases through dev-zeus-rw.db.phx1, which you can reference.

we now need a production database with the following:

  - name: badges_mozilla_org
  - user: badges_rw 
  - comes from: zlb

*no ro user required at this point*

feel free to him me up on irc if you have any questions.

Comment 1

[Brandon Johnson [:cyborgshadow]]

Database created on generic1.db.phx1.mozilla.com

Database: badges_mozilla_org
user: badges_rw@'10.8.70.20_' and badges_rw@'10.8.70.21_'
privileges: ALL privileges on badges_mozilla_org.*  (no grant option)

password was delivered to cturra via IRC.

Let me know if you have any extra questions or concerns.