MySQL down

[JLR]

on Jupiter

Why was my last post deleted

[cjdj]

I dont think I've ever seen the mysql database have a longer uptime than a couple of weeks (and normally less than a few days).

Is it really crashing that often? Or is it being restarted periodically? We website is not time critical, so the impact has been minimul, but I expect to introduce features soon which will rely on the sql server much more. can I rely on it? Or should I start looking for another host?

[cjdj]

err... sorry about my terrible spelling and misplaced words.. was wrestling with putting a 3 year old to bed who didnt want to go..

[Starr]

The only thing that can cause a properly setup mySQL server to "crash" or more accurately, stop responding, is memory (or running out of memory).

mySQL is kind of like a Harley, as long as it has oil (memory) it will run forever. ;)

We do limit the amount of memory each mySQL server can use. This keeps a problem w/ mySQL from overwhelming the machine and causing the whole system to stop responding.

[cjdj]

I'll admit I am a really big fan of mySQL and have used it in other projects that arent web related. However, I've never used one with as many databases on it as powweb have on pluto. I was concerned that it might be an issue.

I think I'll keep a record on the uptime's reported just in case the impression I had was wrong.

I really do like the powweb server and have no actual complaints. Its fast, full of features, and currently fits my needs very well. My concern is focused on the sql server though, because my sites use it a great deal. (So much so in fact, that the first thing almost all my scripts do is connect to the database, I have very few .html files). If the database is not reliable from a connectivity and responce viewpoint, then my site will become useless.

Back to my question though... is it going down because maintenance is being performed (maybe on other stuff), or is it having to be reset because it stopped responding?

There are currently 97 databases on pluto. I'll admit that it is responding very fast for me, so my concern isnt overloading. But how many databases (customers) do you plan on putting on each mysql server?

Oh, another thing... I currently have two databases on pluto... they are for two different sites... is it possible to have one moved to another powweb server so that I can at least use the other one as an alternate (or mirror) of critical information if one goes down?