The Heap™ – Consultancy ©®

« first day (1202 days earlier) ← previous day next day → last day (3660 days later) »

Simon Righarts

7:59 AM

@rfusca Famous last words. Still not as deadly as "Hold my beer and watch this!" though. :D

rfusca

@SimonRigharts lol

Simon Righarts

@rfusca Also next time you're trying to seed replication down a 2Mb pipe, consider couriering a full copy of what you're starting with to the destination

still ain't nothing close to the bandwidth of a wagon full of drives speeding down a highway

rfusca

@SimonRigharts lol now there's an old quote ;)

Simon Righarts

@rfusca I should've said tapes not drives though :p

rfusca

oh....believe me I've had this discussion sooooooo much with him..."No, really we can't send over 1 TB across the 10Mbit pipe 'in a few hours'"

Simon Righarts

8:07 AM

Lemme see - 1 TB at 10 Mb/sec = 10MB/8s (assuming no overhead) = 1GB in 800s = 1TB in 800,000s (9.25 days). Assuming perfect utilization etc. Yeeah

@rfusca We were considering flying disks internationally last year (when we were moving our dev/test environments from one provider to another)

(rephrased - remembered we went with "meh, just create new images from the templates for all the environments. After all it's only test data right?")

famous last words - test data is apparently very important to QA. Who knew?

rfusca

ya, i mean the stupid part is the two boxes are about 6 ft from each other but he intentionally put them across the public network 'to see how it would handle it' - (its the first replication set for an exagrid box...so it does the whole thing and then just sends byte changes afterwards.)

@SimonRigharts lol indeed

Simon Righarts

@rfusca The stupid just reached "Ow. My head." levels.

rfusca

@SimonRigharts yuuuup

Simon Righarts

Also wait - your network is only 10Mb? wtf?

rfusca

@SimonRigharts wtf indeed...wtf indeed

5 hours later…

Marian

12:59 PM

A: MySQL schema for recurring events - Query by specific date

What you seek is a table like the one below, from which you could query: SELECT * FROM departures WHERE route_id = 'SOME_ROUTE' -- This is the code to a route, encompassing from/where AND departure_date = @some_day AND departure_time_min <= @target_time AND departure_time_max >= @t...