News for hackers. Stuff that matters.
Re:Trello is running on a diesel generator and may go down a... by spolsky on Tuesday October 30, 2012 @10:15PM (#4720809)
Let me update this: we've been working all day on moving Trello to AWS, a project which is now underway. If all goes well (fingers crossed, etc) we'll be up and running on AWS very soon. There are still other services in the flooded New York data center (FogBugz, Kiln, Copilot) and we are making plans to physically move servers to a new data center as quickly as possible if the flooded data center falls over, but a physical move of 5 racks could take a whole day so I hope that doesn't happen.

Separately, Stack Exchange, which is in the same data center, is running off of its hot backup in Oregon.

We would have liked to have completely redundant data centers for FogBugz on Demand and Kiln on Demand to avoid even a few hours of downtime, but because those services rely heavily on giving every customer their own SQL database, there is almost no reasonable way to get fast failover to a different data center. We can do it with Stack Exchange because there are only a couple of hundred databases. We've been building a SAN solution which will make it possible to hot swap out to another datacenter, one day, but that project is not complete.

Re:Trello is running on a diesel generator and may go down a... by jmillikin on Tuesday October 30, 2012 @11:23PM (#4721004)
Why would you have needed fast failover in this case? Sandy's trajectory was predictable enough that even a day-long migration could have been completed with time to spare.
Re:Trello is running on a diesel generator and may go down a... by drewcrawford on Tuesday October 30, 2012 @11:18PM (#4720995)
> but because those services rely heavily on giving every customer their own SQL database, there is almost no reasonable way to get fast failover to a different data center

Why did you say you could do fast failover to LA in 2007? [1] It was the case then that every customer had their own SQL database too.

I'm not trying to be snarky, your team is obviously putting forth some heroic effort. I'm just an affected customer that is curious why the question seems to have two mutually exclusive answers.

[1] http://webcache.googleusercontent.com/search?q=cache:lHEK939...

Re:Trello is running on a diesel generator and may go down a... by guiambros on Wednesday October 31, 2012 @12:05AM (#4721123)
I'd be curious to see if there's any update to FBOD architecture. The idea of using self-hosted servers running SQL Server and IIS already sounded eccentric 5 years ago, but given the number of options today, it'd be hard to still justify such a monolithic solution.

In all fairness, Joel recognized in the article that the initial decision was based on their previous experience with Microsoft -- and AWS was still incipient in 2007 -- so it made sense at the time. I doubt this is still the case. Even less if you consider the costs of Sandy - duplicated servers, migration, hours lost, unhappy clients, etc.

Re:Trello is running on a diesel generator and may go down a... by patrickgzill on Tuesday October 30, 2012 @11:25PM (#4721010)
ISCSI over DRBD for Linux, seems to be one solution. I know of a highly available VOIP company that uses this in production.

And maybe this sounds snarky, but AWS is your "making it better" solution? Seriously?

Re:Trello is running on a diesel generator and may go down a... by notatoad on Tuesday October 30, 2012 @11:30PM (#4721022)
If aws is up and their DC is down, in what way is that not better?
Re:Trello is running on a diesel generator and may go down a... by patrickgzill on Wednesday October 31, 2012 @12:28AM (#4721206)
Sorry for not being clear - I was referring to AWS' not so stellar uptime.
Re:Trello is running on a diesel generator and may go down a... by donavanm on Wednesday October 31, 2012 @03:09AM (#4721578)
Except for this event. Where pretty much every DC in NY/NJ is compromised, yet no blips in us-east.
Re:Trello is running on a diesel generator and may go down a... by derobert on Wednesday October 31, 2012 @07:59AM (#4722374)
Probably because Amazon US-East is in Northern VA, not NY/NJ. http://aws.amazon.com/about-aws/globalinfrastructure/

NoVA didn't get hit that hard by Sandy, unlike NY/NJ. So data centers around here didn't tend to have problems, the few that I have equipment in didn't even loose utility power.