Asteroid MySQL is down!

[Tien]

Yup Asteroid MySQL is down! just now

[LexF]

Looks like PHP is running very high on asteroid. Admins investigating. Once they find the source, they'll get the machine back up. Should be just a few moments.

[Tien]

This is what so cool about powweb
respond within few minute!
Thanks LexF!

[Xinil]

I'm curious, because Tien said that mySQL is down on Asteroid, wouldn't that mean that everyone's mySQL would be down too? Because I was under the impression that mySQL is now hosted on its own server (not on a server to server basis). Then again, maybe Tien is just mistaken in the fact that mySQL wasn't the problem? :)

[LexF]

Our legacy servers (the ones named after celestial objects) still run MySQL on the same machine that serves pages. Only users on asteroid would have been affected.

It was actually just a 'high server load' issue, and not a MySQL issue, this time around. The problem was spotted and eliminated within seconds.

[scarter]

If it was fixed within seconds, why is MySQL still crashed on Asteroid?

(2:18 p.m. PST, site www.garcoteencourt.org, click on "docket".

[LexF]

MySQL's running on the server right now, and your DB is responding in OPS. Try setting your hostname to asteroid.powweb.com instead of localhost within the script.

[pamturner]

If you use PHP you can put in an if statement for mysql server connection types the syntax will have to be customised for your self but the idea is the same.
For instance, if mysql cannot connect to the database using the hostname, the username, and/or the pass is invalid. then try another database host. If all three fail then say the database is unavailable.

[scarter]

Originally posted by LexF
Try setting your hostname to asteroid.powweb.com instead of localhost within the script.

That worked.

[Tien]

Edit*
It work!