521597 - personas database needs to move off of C01

Status: RESOLVED FIXED

Description

[Dave Miller [:justdave] ([e-mail])]

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

[matthew zeier [:mrz]]

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.

Comment 2

[Dave Miller [:justdave] ([e-mail])]

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.

Comment 3

[Dave Miller [:justdave] ([e-mail])]

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.

Comment 4

[Dave Miller [:justdave] ([e-mail])]

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.

Comment 5

[Dave Miller [:justdave] ([e-mail])]

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.