Monitoring for Datazilla DB servers

RESOLVED FIXED

Status

mozilla.org Graveyard
Server Operations
--
minor
RESOLVED FIXED
6 years ago
3 years ago

People

(Reporter: fox2mike, Assigned: ashish)

Tracking

Details

(Reporter)

Description

6 years ago
They are :

datazilla1.db.scl3.mozilla.com
datazilla2.db.scl3.mozilla.com

Standard MySQL checks, will CC sheeri for confirmation.
(Reporter)

Updated

6 years ago
Blocks: 764281
(Assignee)

Comment 1

6 years ago
sheeri - ping me on IRC for confirmation on this. Thanks!
Assignee: server-ops → ashish
Status: NEW → ASSIGNED
QA Contact: phong → jdow
[08:55:04] <sheeri> ashish re: monitoring of datazilla, yes please, keep in mind that datazilla is master/master, so read_only should be OFF on both, and both should be replicating.

[08:55:20] <sheeri> ashish or at least, that's how it's configured now.
(Assignee)

Comment 3

6 years ago
These are added and configured appropriately.

10:29:52 < nagios-scl3> | Fri 10:29:52 [514] datazilla1.db.scl3.mozilla.com:MySQL DB uptime is OK: mysql_varcomp OK - Comparison check passed: (Uptime) = 940072
10:30:52 < nagios-scl3> | Fri 10:30:52 [515] datazilla2.db.scl3.mozilla.com:MySQL DB uptime is OK: mysql_varcomp OK - Comparison check passed: (Uptime) = 937008
10:33:53 < nagios-scl3> | Fri 10:33:52 [516] datazilla1.db.scl3.mozilla.com:MySQL is OK: Uptime: 940312  Threads: 6  Questions: 3617280  Slow queries: 0  Opens: 813  Flush tables: 1  Open tables: 137  Queries per second avg: 3.846
10:34:52 < nagios-scl3> | Fri 10:34:52 [517] datazilla2.db.scl3.mozilla.com:MySQL is OK: Uptime: 937248  Threads: 3  Questions: 1783929  Slow queries: 0  Opens: 236  Flush tables: 1  Open tables: 74  Queries per second avg: 1.903
10:35:51 < nagios-scl3> | Fri 10:35:51 [518] datazilla1.db.scl3.mozilla.com:MySQL Replication is OK: Replication running.  Lag time: 0 seconds
10:36:51 < nagios-scl3> | Fri 10:36:51 [519] datazilla2.db.scl3.mozilla.com:MySQL Replication is OK: Replication running.  Lag time: 0 seconds
Status: ASSIGNED → RESOLVED
Last Resolved: 6 years ago
Resolution: --- → FIXED
Product: mozilla.org → mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.