Total War Center Down?

**King Doom** · 07-07-2010, 17:11

So TWC will be back up sometime today?

**Strelok** · 07-07-2010, 17:18

Originally Posted by Simetrical

We have 16 GB of RAM, so you're right, reads are no problem at all. Writes are the issue. When the database commits a transaction, it will fsync(), so it blocks until the data actually hits the physical disk. So memory buffering doesn't help you here. For other writes, memory does help, but only so much – you can do write combining and less seeking if you buffer in memory for a while, but you still have to do the writes.

I see. I didn't really take into account the frequent random writes that would be performed as I was thinking more of sequential write differences in my mind.

**Simetrical** · 07-07-2010, 17:19

Originally Posted by Strelok

To get a reliable, non-sequential write friendly you are looking at around $300-$400+ for 64GB at a time.

Pretty much. An X25-M 80 GB might be good enough, and that's only $215 each, so $430 for two in RAID 1. Not completely out of our budget, and our database would fit in that space (although not all our other stuff), but it's just not worth it.

Originally Posted by King Doom

So TWC will be back up sometime today?

That's the plan, sometime late today. I don't see anything further that's likely to go wrong. But then, one never does.

**Strelok** · 07-07-2010, 17:23

Originally Posted by Simetrical

I don't see anything further that's likely to go wrong. But then, one never does.

Not really relevant to context, but I once had memory allocation errors because of one bit of dust in a singular RAM slot. That...was really weird.

**Simetrical** · 07-07-2010, 17:28

Originally Posted by Strelok

Not really relevant to context, but I once had memory allocation errors because of one bit of dust in a singular RAM slot. That...was really weird.

Yeah, crazy stuff can happen. This is why you really really need redundant servers. You can have redundant power supplies, RAID, ECC RAM, but you never know when some fluke is going to take down a server regardless. With any luck we'll have the second server installed physically this week, and I might be able to get it working properly next week (although I've never set up this kind of thing before, Heartbeat and all that jazz).

**Irishguy** · 07-07-2010, 17:39

great update! thanks :)
And yes, thanks Guild for letting all the TWC refugees hang around here!

**anshuvio2** · 07-07-2010, 17:50

Yeah we really appreciate it. Maybe I'll chill in both forums from now on.

On another note: I had a dream that the TWC was back up....something is wrong with me.