How much is too much?

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
User avatar
neophyte
DevNet Resident
Posts: 1537
Joined: Tue Jan 20, 2004 4:58 pm
Location: Minnesota

How much is too much?

Post by neophyte »

Okay over the last four months my db has been down five times, apache once and ftp once. So the question is how much is too much?

How many times is too many times to have your DB down on your site? And when would you leave your hostng company?
alex.barylski
DevNet Evangelist
Posts: 6267
Joined: Tue Dec 21, 2004 5:00 pm
Location: Winnipeg

Re: How much is too much?

Post by alex.barylski »

neophyte wrote:Okay over the last four months my db has been down five times, apache once and ftp once. So the question is how much is too much?

How many times is too many times to have your DB down on your site? And when would you leave your hostng company?
Once....

That doesn't sound 99.9% uptime garuntee to me :)
User avatar
trukfixer
Forum Contributor
Posts: 174
Joined: Fri May 21, 2004 3:14 pm
Location: Miami, Florida, USA

Post by trukfixer »

depends on what is causing teh db to be down - if it is *your* script that causes mysql to load up and crash, the problem will move with you. (we had a client once that claimed our hosting was worthless because mysql kept going down, though the response time to getting it back up was always < 300 seconds .. finally, he moved to a "bigger" server (dual xeon and SCSI drives, etc) and THAT server started crashing too. He had been told by us every time that mysql crashed that the problem was being caused by *poor* programming and sql in an application he was running, he refused to believe it, because he had paid over $300 for the software he was running... and the developer told him there had been no problems from anywhere else..

I think he has changed hosting twice more since then, and each time, the problem has followed his move.

the key is to find out from the hosting company *WHY* the database is going "down" and figure out whose script or queries are causing the issue, and if they cant tell you , then yes, I would move.. (or Id also move if they can tell what the problem is, but dont fix it or boot the user causing issues) but otherwise, I'd want to know why MySQL was going down, because if it was your script causing it, and you moved, the problem will just follow you around like a stray dog that you gave a handout to :)
User avatar
Buddha443556
Forum Regular
Posts: 873
Joined: Fri Mar 19, 2004 1:51 pm

Post by Buddha443556 »

How's the service? Fast? Polite? Are they on top of things? Keeping you informed? There's always going to be downtime sooner or later however good service will make it less stressful.

I'm always looking for better hosting ...
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post by Chris Corbyn »

OK... shared hosting (I'm guessing)... not bad.... it provides a service.

Dedicated hosting... fantastic

Virtual Dedicated/UML hosting... spot on...

IMO... try VDS... it's cheap and it works the way you make it work. My server has had almost 3 months without a reboot, and if I need PHP/Apache/MySQL re-configured I just do it.... I can't complain at all.

IMO... 5 times DB down in a month is lame... it should be a rarity ;)
Roja
Tutorials Group
Posts: 2692
Joined: Sun Jan 04, 2004 10:30 pm

Re: How much is too much?

Post by Roja »

Hockey wrote:That doesn't sound 99.9% uptime garuntee to me :)
Gotta nitpick here. As a former webhost provider, I constantly had people misunderstand that number.

31 days in a month
x24 hours in a day
x60 minutes in an hour
------
44640
x0.01 allowed downtime
------
446.4 minutes (almost 8 hours).

Also note that it doesn't include *planned* and scheduled downtime.
Hockey wrote:How many times is too many times to have your DB down on your site?
Depends on what you need to do. If your site is paying your rent, any outage better have a refund attached. If you are running a little-used homepage, who cares?
Hockey wrote:And when would you leave your hostng company?
The exact moment I thought I could get a better deal elsewhere. The challenge is that a "better deal" includes SO many things.. security, support, network (speed AND latency), server upgrades, software supported, versions, and much - much more.
sheila
Forum Commoner
Posts: 98
Joined: Mon Sep 05, 2005 9:52 pm
Location: Texas

Re: How much is too much?

Post by sheila »

Roja wrote: 31 days in a month
x24 hours in a day
x60 minutes in an hour
------
44640
x0.01 allowed downtime
------
446.4 minutes (almost 8 hours).
I think you missed a decimal place there.
1.000 - 0.999 = 0.001

44640
x0.001
-------
~ 45 minutes / month
User avatar
neophyte
DevNet Resident
Posts: 1537
Joined: Tue Jan 20, 2004 4:58 pm
Location: Minnesota

Post by neophyte »

I have two shared plans with this company on two different servers. I've had almost no problems on one server. The other server has been a disaster. As I said earlier the DB has been down on multple occassions. The worst was the first time. I set up my tables the day or the day after the account was set up. Within a couple of days after that the DB and user was completely wiped out. This time they say the permissions on my dbuser was changed and that the MYSQL server was okay. But I know I didn't change permissions. So who did? Still trying to find that out. I agree with d11wtq virtual and dedicated is the way to go if you have the money to do it. I've only once got something for a 99.9% up time violation. In that case they deleted my user account from the server -- oops... They gave three months hosting.
d3ad1ysp0rk
Forum Donator
Posts: 1661
Joined: Mon Oct 20, 2003 8:31 pm
Location: Maine, USA

Post by d3ad1ysp0rk »

That's kinda funny, the second I finished reading this topic, I went to my own site (http://lanp245.com/) and the database was down for the first time in 2 months. Damn.
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

Post by onion2k »

I've been with clook.net for about 2 years now. As far as I'm aware it's never been down.
alvinphp
Forum Contributor
Posts: 380
Joined: Wed Sep 21, 2005 11:47 am

Re: How much is too much?

Post by alvinphp »

neophyte wrote:Okay over the last four months my db has been down five times, apache once and ftp once. So the question is how much is too much?

How many times is too many times to have your DB down on your site? And when would you leave your hostng company?
It depends on how much you are paying. If you pay $25/year then you should expect downtime. If you pay $20/month and it goes down more then 2 times in a year I would be <span style='color:blue' title='I'm naughty, are you naughty?'>smurf</span>. At 3 I would leave. And if you have a lot of sites (like me), then moving is a major pain in the butt.

I personally pay the higher price because I want reliability, 24/7 live support, and real daily backups so when I screw up a DB I can msg them and get yesterdays DB in less then an hour.
Ree
Forum Regular
Posts: 592
Joined: Fri Jun 10, 2005 1:43 am
Location: LT

Post by Ree »

Hey, how do you crash mysql via a query? :lol:

Didn't think it was possible.
User avatar
trukfixer
Forum Contributor
Posts: 174
Joined: Fri May 21, 2004 3:14 pm
Location: Miami, Florida, USA

Post by trukfixer »

Ree wrote:Hey, how do you crash mysql via a query? :lol:

Didn't think it was possible.
Oh yeah , It is most assuredly possible :)

where I work, there are two applications that , under high traffic, will bring not only mysql, but the entire server to a crashing , grinding halt (at ssh login, it takes over 3 minutes, on average just to get to the root prompt due to extreme high loads ) due to poor mysql query and/or index design...

I prefer not to list them here, as the developers of those applications have been informed countless times, (and shown evidence and proof of the problem) but have so far done very little ot alleviate the problem - so we ended up (at least on one- the other is send encoded) fixing the problem ourselves, so that the issue would not be as severe (would you believe something as sinple as creating an index on a single database table will improve an applications performance by as much as 300% ?)

Anyhow- speaking from first hand experience on the sysadmin side of things, yes, MySQL can most certainly crash via a query (or a bad or non-existent index)

Bri!
User avatar
Ambush Commander
DevNet Master
Posts: 3698
Joined: Mon Oct 25, 2004 9:29 pm
Location: New Jersey, US

Post by Ambush Commander »

MySQL query done, inspected 129831202931 rows.

A DBM's worst nightmare.
Grim...
DevNet Resident
Posts: 1445
Joined: Tue May 18, 2004 5:32 am
Location: London, UK

Post by Grim... »

I've been with Dataflame for 2 years and ukhost4u (shudder - that name sucks) for about 1 year.
The only time anything went down on either (to my knowledge) was when a silly web game I made got really popular when I wasn't looking and crashed their server :D
Post Reply