552010 - Update config on personas.stage.mozilla.com

Status: RESOLVED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[Ryan Doherty (:rdoherty)]

From server/lib/personas_constants.php.dist copy the slave db info to server/lib/personas_constants.php and add the appropriate values. 

Need asap so we can push this live and alleviate load on the db servers.

Comment 1

[Aravind Gottipati [:aravind]]

The app looks like it lives on its own staging server, with its own staging db.. instead of living in the regular staging environment.  Justdave says its easier to clone the personas db into the staging server (and reuse the existing staging slave db for this), than setup an entirely new slave.

He is buried in dealing with graphs.m.o, and so punting this to Toby.

Comment 2

[timellis]

I dumped the data out of sm-personas01, copied the dump to Boris, then back over to tm-stage01-master01. Then I loaded up the dump into the master, which replicated to the slave.

Then I shut down sm-personas01 and announced this in #webdev.

I will now take a look at usernames and passwords in the file Ryan lists above to grant properly on tm-stage01-master01 and tm-stage01-slave01.

Comment 3

[Ryan Doherty (:rdoherty)]

Note: when I mentioned slave I mean master. I have added extra configuration for the master. The original config should point to the slave.

Comment 4

[timellis]

Also granted all perms on personas DB on tm-stage01-master01 to personas login on both sm-personas01 and mrapp-stage02. Also granted SELECT perms to same on tm-stage01-slave01.

The password remains unchanged and is the same on both master/slave.

Returning bug to Aravind!

Comment 5

[Aravind Gottipati [:aravind]]

Okay, config has been updated.  The original config points to the slave now, and the master points to the master.