I am working on an open source side project called webmonitorhq.com It notifies you when your service goes down. It also stores the events when a service goes down and comes back up. And I wanted to show the uptime of a service for a duration of 24 hours, 7 days etc,.
This is the algorithm I came up with, Please point out any improvements that can be made to it. I’d love to hear them.
The prerequisite to this algorithm is that you have data for the UP events and the DOWN events
I have a table called events with an event string and an event_at datetime
| events |
|---|
| id |
| event (UP or DOWN) |
| event_at (datetime of event occurence) |
Algorithm to calculate downtime
- Decide the duration (24 hours, 7 days, 30 days)
- Select all the events in that duration
- Add an UP event at the end of the duration
- Add a inverse of the first event at the beginning of this duration e.g. if the first event is an UP add a DOWN and vice versa
- Start from the first UP event after a DOWN event and subtract the DOWN event_at from the UP event_at, do this till you reach the end. This gives you the downtime
- Subtract duration from downtime to get uptime duration
e.g.
- 24 hour duration. Current Time is 00hours
- UPat1 DOWNat5 UPat10
- UPat1 DOWNat5 UPat10 UPat24
- DOWNat0 UPat1 DOWNat5 UPat10 UPat24
- UPat1 - DOWNat0 + UPat10 - DOWNat5 Downtime = 1 + 5
- 24 - 6 => 18
I am currently working on LiveForm which makes
setting up contact forms on your website a breeze.