552701 - Update getpersonas.com to latest production revision on 3/16

Status: VERIFIED FIXED

(Infrastructure & Operations Graveyard :: WebOps: Other, task)

Description

[Ryan Doherty (:rdoherty)]

Got an update to turn search back on using sphinx once bug 552700 is resolved. It was turned off to alleviate db load, but it's causing lots of user grief and actually increasing load b/c users are paging through hundreds of pages in the gallery.




Setup:
1) Copy docroot/server/lib/sphinx/localsettings.py-dist to
docroot/server/lib/sphinx/localsettings.py
2) Edit docroot/server/lib/sphinx/localsettings.py, adding db and sphinx
configuration. (db configuration is in
docroot/server/lib/personas_constants.php)
3) Run docroot/server/lib/sphinx/sphinx.conf, it will print out the
configuration for sphinx
4) Add that config to the sphinx cluster
5) Copy sphinx config at bottom of
docroot/server/lib/personas_constants.php.dist to
docroot/server/lib/personas_constants.php and change appropriate configuration 
6) Run indexer to index content, put on cron job to run every 5 minutes (indexing takes ~6 seconds)

Comment 1

[Ryan Doherty (:rdoherty)]

r64245 is the revision to update to

Comment 2

[Ryan Doherty (:rdoherty)]

Attachment: sql to run (not related to sphinx)

Small sql statement to change 2 persona author's per bug 551715

Comment 3

[Stephen Donner [:stephend] Not actively reading bugmail]

We shouldn't update while https://personas.stage.mozilla.com/en-US/ is still broken, should we?  (Bug 552839.)

Comment 4

[Ryan Doherty (:rdoherty)]

(In reply to comment #3)
> We shouldn't update while https://personas.stage.mozilla.com/en-US/ is still
> broken, should we?  (Bug 552839.)

Correct, that bug completely slipped my mind. We should figure out bug 552839 first.

Comment 5

[chizu]

Sphinx cluster configuration for this is done. Delaying the update to enable it until bug 552839 is solved.

Comment 6

[chizu]

This update is live:

U    server/templates/nav.php
 U   server/locale/sq/LC_MESSAGES/messages.po
 U   server/locale/ja
 U   server/locale
 U   server/lib/user.php
 U   server/lib/personas_functions.php
A    server/lib/sphinx
A    server/lib/sphinx/localsettings.py-dist
A    server/lib/sphinx/sphinxapi.php
A    server/lib/sphinx/sphinx.conf
UU   server/lib/storage.php
U    server/lib/personas_constants.php.dist
U    server/revisions.php
U    server/viewpersonas.php
U    static/css/style.css
 U   static/js/script.js
 U   .
Updated to revision 64245.

mysql>  update personas set author = 'WordPress.org' where id IN(85612, 85447);
Query OK, 2 rows affected (0.03 sec)
Rows matched: 2  Changed: 2  Warnings: 0

Comment 7

[Ryan Doherty (:rdoherty)]

re-opening, tried pinging Trevor in IRC, we need another svn up to fix some cached css. Seems like certain pushes end up with css being cached.

Comment 8

[chizu]

Ok, updated:
U    server/revisions.php
U    static/css/style.css
Updated to revision 64255.

Comment 9

[Stephen Donner [:stephend] Not actively reading bugmail]

Verified FIXED; Ryan and I see the fixes once we shift+reload (I re-tested search on prod, too).