Closed Bug 791712 Opened 12 years ago Closed 12 years ago

Need to set up slow-log copies for addons*.versioncheck.db.phx1

Categories

(Data & BI Services Team :: DB: MySQL, task)

Product:
Data & BI Services Team
Component:
DB: MySQL
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: dustin, Assigned: dustin)

References

Details

[root@addons1.versioncheck.db.phx1 dmitchell]# cat /var/log/backup-slowlogs.log
Running /usr/local/sbin/backup-slowlogs.sh in /root at Mon Sep 17 04:00:01 PDT 2012
Copying /var/log/mysql/mysql-slow.log to webdev1.db.scl3.mozilla.com ...
ssh: connect to host webdev1.db.scl3.mozilla.com port 22: Connection timed out
lost connection

They'll also need their SSH key added to webdev1's node definition.

I can do this - is it just addons1..3, or are/will there be more?
That's all there will be for now, as far as I know (e.g. no other hardware is on order for this, etc)
Assignee: server-ops-database → dustin
Depends on: 792423
Puppet change done, flow bug filed.
Somehow the authorized_hosts file had been deleted on webdev1, and puppet was broken so it wasn't replacing it.

I fixed puppet (mysql2::checksums won't work without mysql2::server, so I commented it out), and it seems OK now.
Status: NEW → RESOLVED
Closed: 12 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.