Status

Data & BI Services Team
DB: MySQL
RESOLVED FIXED
3 years ago
3 years ago

People

(Reporter: fubar, Unassigned)

Tracking

Details

(Whiteboard: [treeherder][data:onboard][2014q4])

(Reporter)

Description

3 years ago
We're setting up a staging environment for treeherder in SCL3 that closely matches production (and will handle comparable load). We'll need new DBs for it. I believe the plan is to only store 1-2 months of data, unlike the 6+ months for prod (and are getting increased). Prod db set up is in bug 998491.

I expect you'll have questions that I can't answer, so I've CCed the treeherder team. :-)

Thanks!
Product: mozilla.org → Data & BI Services Team
(Reporter)

Comment 1

3 years ago
ping?
So we're realistically looking at 300GB disks and db machines identical to prod otherwise.

I'm in talks with the virt team about seeing if this can be a reality now.
Assignee: server-ops-database → bjohnson
Depends on: 1085507
(Reporter)

Updated

3 years ago
Whiteboard: [treeherder]
These exist but haven't been setup prior to my departure. Please set them up and communicate with the folks in #treeherder for it's use. I believe we won't be transferring any data to it but I'm not 100% certain.
Assignee: bjohnson → server-ops-database
(Reporter)

Comment 4

3 years ago
ping? need to have these set up soon, please. no data needs to be xferred.
Started building them, got the MySQL packages on it, need to change the root pw to get puppet running properly, then will make a user and pass.
(Reporter)

Comment 6

3 years ago
checking in to see where we are. do we have VIPs yet so I can get flows set up? thx, sheeri1
Depends on: 1104797
Got replication working, still need to set up monitoring and backups. bug for VIP is bug 1104797.
Whiteboard: [treeherder] → [treeherder][data:onboard][2014q4]
(Reporter)

Comment 8

3 years ago
The th_admin user is missing privs, I think. IIRC, it actually needs to create a database *per tree*, in addition to the treeherder_stage db. Looking at prod, I see a whole bunch of dbs, which seems to bear this out.

Can the staging db users have their privs set to match prod, please? Thanks!
I've matched privileges (not passwords) with production. 

th_admin - GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EVENT ON *.*

th_user - GRANT SELECT, INSERT, UPDATE, DELETE ON *.*
added both treeherder machines to nagios monitoring groups:
                'virtual',
                'mysql2-puppetized-servers',
                'db-swap-high',
                'mysql-masters',
                'mysql-slaves',
                'mysql-checksum',
                'mysql-rw'

MacBook-Air:hosts scabral$ svn commit -m "adding treeherder machines to nagios stage"
Sending        scl3.pp
Transmitting file data .
Committed revision 97966.

pushed to Nagios, all is green.

Left to do-  backups.
backups are complete. Resolving.
Status: NEW → RESOLVED
Last Resolved: 3 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.