778198 - Monitoring for Datazilla DB servers

Status: RESOLVED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[Shyam Mani [:fox2mike]]

They are :

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

Standard MySQL checks, will CC sheeri for confirmation.

Comment 1

[Ashish Vijayaram [:ashish]]

sheeri - ping me on IRC for confirmation on this. Thanks!

Comment 2

[Sheeri Cabral [:sheeri]]

[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.

Comment 3

[Ashish Vijayaram [:ashish]]

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