Kitz Forum

Broadband Related => Router Monitoring Software => Topic started by: AArdvark on March 30, 2015, 01:57:55 AM

Title: Mydslwebstats is Down. [Not any more]
Post by: AArdvark on March 30, 2015, 01:57:55 AM
 ;DI am getting the following error message:

Warning: mysqli_connect(): (HY000/2002): No connection could be made because the target machine actively refused it. in C:\WampDeveloper\Websites\www.mydslwebstats.co.uk\webroot\_opendbHG.php on line 5
Database Connect Failed......

Anyone else ?

Update:
Main Website is down with Database error.
Title: Re: Mydslwebstats is Down.
Post by: les-70 on March 30, 2015, 07:11:16 AM
 Me too
Title: Re: Mydslwebstats is Down.
Post by: lloyd on March 30, 2015, 07:38:13 AM
Same here.
Title: Re: Mydslwebstats is Down.
Post by: tbailey2 on March 30, 2015, 08:13:44 AM
Same here.

Yes, well and truly down. The disk corrupted at 01:50, rebooted and couldn't load the database.

It's okay at the moment after a restart but I am going to take the server down in a while and recover to a new disk.
Title: Re: Mydslwebstats is Down.
Post by: tbailey2 on March 30, 2015, 11:24:55 AM
Okay, back up from 10:20 or so. Have cloned it to a spinning disk rather than an SSD as hopefully that will cope better. Once it's all cached the delivery speed isn't much different.

I'll mirror it as soon as another disk I just ordered arrives. A few more changes to come yet over the week but downtime shouldn't be too long (famous last words  :wry: )
Title: Re: Mydslwebstats is Down. [Not any more]
Post by: AArdvark on March 30, 2015, 01:49:38 PM
Thanks.

[Totally off Topic]
You have highlighted the concerns I still have with SSD's.
They are wonderful but if you are constantly writing/re-writing the possibility of exceeding the wear limits is possible in 10's of months not years.

I know I am now going to get 'hit' by the maths Arrgh !!!  ;D
Title: Re: Mydslwebstats is Down. [Not any more]
Post by: Ronski on March 30, 2015, 03:39:19 PM
What make of ssd was it?

Intel is my preferred choice.
Title: Re: Mydslwebstats is Down. [Not any more]
Post by: AArdvark on March 30, 2015, 03:44:51 PM
Intel of course, particularly at the enterprise end of the market. You do pay for it though.
Samsung is also good and getting better. But still concerned though 😃
Title: Re: Mydslwebstats is Down. [Not any more]
Post by: ip75 on March 30, 2015, 03:51:07 PM
I found this quite interesting: http://arstechnica.com/gadgets/2015/03/consumer-ssds-benchmarked-to-death-and-last-far-longer-than-rated/
Title: Re: Mydslwebstats is Down. [Not any more]
Post by: tbailey2 on March 30, 2015, 04:52:06 PM
What make of ssd was it?

Intel is my preferred choice.

Liteon - cost £250 (+VAT) odd to replace so didn't!

It lasted 4 months.... (it came with the machine)

Problem is that with at least one (actually more like 6) write per second, it never gets a chance to use its wear levelling software - they say to leave it quiet for 6 hours every so often!
Title: Re: Mydslwebstats is Down. [Not any more]
Post by: AArdvark on March 30, 2015, 07:00:15 PM
ip75,
See this one I have been following: http://www.kitguru.net/components/ssd-drives/zardon/ocz-challenge-kitguru-to-kill-5x-arc-100-ssd-drives/ (http://www.kitguru.net/components/ssd-drives/zardon/ocz-challenge-kitguru-to-kill-5x-arc-100-ssd-drives/)

Also very interesting.

tbailey2,
Could have use a mirrored pair of SSD's that you could drop one of the pairs out of, at regular intervals to 'Wear level', alternating the SSD each time.
Title: Re: Mydslwebstats is Down. [Not any more]
Post by: Ronski on March 30, 2015, 07:47:05 PM
Considering the usage it's getting, it's probably is better to use a conventional disk, I doubt donations stretch to an enterprise class SSD.

Interesting challenge on the OCZ ARC 100, first died at 322TB of data written, the last was still going at well over 500TB by the looks of it, last update I can find was 19th March, surely it's died by now!
Title: Re: Mydslwebstats is Down. [Not any more]
Post by: AArdvark on March 30, 2015, 08:12:34 PM
No still going as far as I can tell. There is a competition running to guess the final ssd's point of Failure.
Title: Re: Mydslwebstats is Down. [Not any more]
Post by: Chrysalis on March 31, 2015, 03:15:53 PM
yeah you should be using an hdd for this.

if you really want to use an ssd tho then get a 3d nand MLC model.  (samsung 850 pro)
Title: Re: Mydslwebstats is Down. [Not any more]
Post by: tbailey2 on March 31, 2015, 04:05:27 PM
yeah you should be using an hdd for this.

if you really want to use an ssd tho then get a 3d nand MLC model.  (samsung 850 pro)

It's been on a spinning WD red drive since that day as already noted (http://forum.kitz.co.uk/index.php/topic,15248.msg283477.html#msg283477). I have a NAS here with five in and that's been running for over 3 years.....
Title: Re: Mydslwebstats is Down. [Not any more]
Post by: Ronski on April 01, 2015, 08:30:08 PM
No still going as far as I can tell. There is a competition running to guess the final ssd's point of Failure.

Not any more, it died today at 695.5TB (http://www.kitguru.net/components/ssd-drives/zardon/ocz-competition-winner-final-arc-100-hits-695-5tb/) unless of course it's an April's fool!
Title: Re: Mydslwebstats is Down. [Not any more]
Post by: NewtronStar on April 01, 2015, 09:08:12 PM
Not any more, it died today at 695.5TB (http://www.kitguru.net/components/ssd-drives/zardon/ocz-competition-winner-final-arc-100-hits-695-5tb/) unless of course it's an April's fool!

Just like any other storage media always have a backup/image before it meets it's maker  ;)
Title: Re: Mydslwebstats is Down. [Not any more]
Post by: AArdvark on April 01, 2015, 09:23:32 PM
Ronski,
Still blindingly good for a ssd rated at 22TB.

Send from LG G3 via Tapatalk (Typos & bad formatting are free)

Title: Re: Mydslwebstats is Down. [Not any more]
Post by: Ronski on April 01, 2015, 10:24:25 PM
Yes, it very impressive and perhaps I might try one in laptop at work now.

Just like any other storage media always have a backup/image before it meets it's maker  ;)

Absolutely,  I have Raid 6, cloud and off site USB HDD backup of really important stuff.
Title: Re: Mydslwebstats is Down. [Not any more]
Post by: tbailey2 on April 02, 2015, 08:28:25 AM
Yes, it very impressive and perhaps I might try one in laptop at work now.

Just like any other storage media always have a backup/image before it meets it's maker  ;)

Absolutely,  I have Raid 6, cloud and off site USB HDD backup of really important stuff.

Likewise although I use a known data centre rather than out-there-somewhere cloud which has a habit of vanishing when you most need it...

Here there are two x RAID 5 NAS one backing up the other and physically separated, mirrored drives on the main machines, plus separate external USB drives for scheduled daily disk image backups. And the MDWS tables and other database material are also written live to duplicated databases at a London data centre.