Stats are down

[Bok]

Think I need a miracle It's not responding so it's going to be down for a while. I do have one spare SSD which I'll plug in over the weekend when I get home and see what can be done.

[LAURENU2]

Does the server work with a Raid so there is a backup copy ?

[Bok]

RAID slows it down too much and it's not that great with SSD's anyway.

I do my own custom replication instead. Backups are on separate drives. This is the web facing database anyway which is read only, so it's 'mostly' duplicated from the main one. Means it gets LOTS of writes though and I guess it's finally taken it's toll.

[LAURENU2]

Have you looked into the pciE drives at all there faster and have more capacity

[Jim1900]

Means it gets LOTS of writes though and I guess it's finally taken it's toll.

A write-caching program can cut down on writes by an order of magnitude or more. I have used both FancyCache (Romex Software) and PerfectCache 5.0 (Raxco), and they both give very good results for limiting the writes to my SSD when I run the CEP2 project on World Community Grid. Writes will typically go from 80 GB/day down to less than 1 GB/day, but that depends a lot on the statistics of what you are doing of course, and the size of the DRAM cache you set.

FancyCache is currently in Beta (free 90 day trial), and PefectCache 5.0 is $80 (30 day free trial), but well worth it if you have the right situation.

[LAURENU2]

Think I need a miracle It's not responding so it's going to be down for a while. I do have one spare SSD which I'll plug in over the weekend when I get home and see what can be done.

Any Update yet

[Bok]

I only got home a few hours ago after travelling overnight, afraid to look at it right now when I'm still so tired. I *think* statstool is gone unless I can recover the drive though as well as a few other things, possibly historical miestones too. It looks like the backups were failing for the last 10 days or so and I didn't get warned. I only keep last 5 days.

[LAURENU2]

looks like it got your Sig to
Well if you need off line storage
I have over 20 Terabytes of open space here

[Zydor]

Bok

When you get her going again, if you dont use Diskeeper, go to Diskeeper - Hyperfast.

I have used Diskeeper for years, and its excellent massive defrag and disc i/o savings, however, with the onset of SSDs, they brought out Hyperfast, and the difference thats made to my SSDs is astonishing, not only performance, but arguably more important disc life as it prevents a huge number of disc writes/IO. As SSDs are hugely sensitive in terms of their lifespan on minimising disc writes, Hyperfast hits the button superbly.

I recenly crunched some WUs who are very heavy on disc writes - this particular WU type create literaly thousands of directories as part of its routine. During my time time crunching them, the Hyperfast pulled out an average of 600,000 saved disc io per day, compared to a WU that is not disc dependent where Hyperfast pulled only 25,000 or so disc writes per day. It works brilliantly, and frankly is a must have for Server SSDs - sprint dont walk and get it together with the main diskeeper program for the servers.

Regards
Zy

[gopher_yarrowzoo]

hmm dang I guess you aren't meant to leave the house for more than a day...
Let me know if there is anything I can help with...

[LAURENU2]

I bet gopher broke trying to install my long rang Radar
come on confess

[Bok]

Bok

When you get her going again, if you dont use Diskeeper, go to Diskeeper - Hyperfast.

I have used Diskeeper for years, and its excellent massive defrag and disc i/o savings, however, with the onset of SSDs, they brought out Hyperfast, and the difference thats made to my SSDs is astonishing, not only performance, but arguably more important disc life as it prevents a huge number of disc writes/IO. As SSDs are hugely sensitive in terms of their lifespan on minimising disc writes, Hyperfast hits the button superbly.

I recenly crunched some WUs who are very heavy on disc writes - this particular WU type create literaly thousands of directories as part of its routine. During my time time crunching them, the Hyperfast pulled out an average of 600,000 saved disc io per day, compared to a WU that is not disc dependent where Hyperfast pulled only 25,000 or so disc writes per day. It works brilliantly, and frankly is a must have for Server SSDs - sprint dont walk and get it together with the main diskeeper program for the servers.

Regards
Zy

It's all on linux, so products like this wouldn't be of any use. RAID 10 arrays might work, but multiple SSD's with good controllers start getting expensive. I really should have been checking the backups a bit better. I plan to pull the server apart tomorrow and see what can be done. At worst I'll plug in the extra SSD drive I have. (Have to pull apart my windows machine for that, but I'll just use my laptop in the meantime).

[Bok]

Good news, looks like I've recovered all of the data as far as I can tell. A few tables gave me errors but they are replicated versions anyway so no big deal. Running tests which will take some time but I think it will be back up no later than noon tomorrow. I'll have to put the drives in correctly as they are just loose right now.

I'm going to look into getting 2 external drives (500Gb or would be fine) and running parallel backups to them.