Closed
Bug 521597
Opened 16 years ago
Closed 16 years ago
personas database needs to move off of C01
Categories
(mozilla.org Graveyard :: Server Operations, task)
Tracking
(Not tracked)
RESOLVED
FIXED
People
(Reporter: justdave, Assigned: justdave)
Details
(Whiteboard: 11/03/2009 @ 7pm)
The personas database is currently in the C01 cluster. With the amount of attention marketing is giving this site lately, it really should have higher than a C-level SLA on it, not to mention being in a cluster with some measure of redundancy in place.
I'm not quite sure where to move it to, however... In theory if we promote it to A-level it gets its own cluster with redundancy, which means a minimum of 3 new hardware machines to support it. The database portion of personas doesn't use a lot of horsepower, though, so it might make sense to combine it with another A-level cluster. The question then becomes which one?
The choices: sfx, sumo, bouncer, amo, bugs
All of those sound like sites we wouldn't want to risk if personas gets buried... and all of those are also pretty heavy DB users, making them a bad choice. Maybe we should make a generic A01 cluster that can collect low-intensity sites that need the redundance?
Comment 1•16 years ago
|
||
I commented to justdave offline but will include it here.
I think you need to better understand how the db is used before knowing where to move it. It's minimal access and primarily used for adding new Personas. Traffic to this db is light (you should even be able to grab status off the current db server).
I'd argue that it doesn't need a dedicated master/slave cluster.
zandr should offer more insight.
Assignee: server-ops → justdave
Assignee | ||
Comment 2•16 years ago
|
||
I think I said that in my initial description, that it doesn't use a lot of horsepower, and probably ought to be combined with something else. I'm just suggesting that we probably want the redundancy for it.
Assignee | ||
Comment 3•16 years ago
|
||
The winning idea at the moment seems to be to add a slave to the SFX cluster so that it's redundant, and then move this database there.
Assignee | ||
Updated•16 years ago
|
Flags: needs-downtime+
Updated•16 years ago
|
Whiteboard: 11/03/2009 @ 7pm
Assignee | ||
Comment 4•16 years ago
|
||
OK, the plan continues to be to move it to the SFX cluster. Still don't have the second slave there, but it'll still be better than where it is now (c01), and we can get the extra slave added later.
zandr/Toby: Need to know everywhere the database config is stored so we can get the configs fixed to point at the new DB while we're at it.
Assignee | ||
Comment 5•16 years ago
|
||
ok, for future reference:
AMO:
site/app/config/config.php:323:define('PERSONAS_DB_HOST','10.2.70.147');
Personas:
server/lib/personas_constants.php:6:if (!defined('PERSONAS_HOST')) { define('PERSONAS_HOST', '10.2.70.147'); }
Everyplace else appears to pull it from one of those two places.
This is all done.
Status: NEW → RESOLVED
Closed: 16 years ago
Resolution: --- → FIXED
Updated•10 years ago
|
Product: mozilla.org → mozilla.org Graveyard
You need to log in
before you can comment on or make changes to this bug.
Description
•