MySQL & FastCGI Upgrades.

[GatorPatrick]

Originally Posted by USAM

OK guys. This is getting ridiculous. My database errors out about 1 - 2 times a day.

There is obviously a major problem with this new upgrade and it is wreaking havoc on all database driven sites on your servers.

This is starting to get very very annoying.

Are you still having issues with this? We have not had any reports of this still occurring over the past few days.

[USAM]

Originally Posted by GatorPatrick

Are you still having issues with this? We have not had any reports of this still occurring over the past few days.

No, the last few days have been uneventful with no noticeable problems.

However, I do want to say that this particular issue caused significant problems. Aside for the database errors that were occuring at the rate of 2 to 3 times a day, Friday night my site was crashed for hours to due a database problem on your end per the tech's statement in the ticket. It was something that was causing an error message regarding global.php. The site was working fine Friday night then it just crashed and stayed that way to the next day. Then subsequent action was the fun part. Tech support decided to restore a 7 day old back up of theirs to rectify the problem. Well, I lost a weeks worth of data that consisted of new member registrations, threads, posts, sponsor info, etc.. Honestly, I almost considered leaving hostgator at that point. Because in the last two or three weeks I've experienced very poor site performance, high server loads of above 5 and I've seen 20. And then the database problems following the upgrade were beyond frustrating. Fortunately, for some freak reason I made a full CPanel backup about a day and half prior to the big crash. So, instead of losing a weeks worth of data I only lost about 32 hours. It was still terribly inconvenient, but a more acceptable loss.

I'm going to set up a cron job to run a script to do daily automated backups of my database. And if you have any form of uptime gaurantee program, I can assure you that my account fell through the cracks on that for the month of January.

Sorry for being so long winded, but try and see this from my point of view. I am actually very shocked at all problems I've had recently. I've actually been a satisfied customer prior to the last couple of weeks. You guys are a good host to compared to others I've been on. I'm surprised at the arbitrary and careless action to push through a MySQL & FastCGI update that crashed many many database driven sites like myself. Logic dictates that was something that wasn't tested prior to roll-out.

[GatorPatrick]

Originally Posted by USAM

No, the last few days have been uneventful with no noticeable problems.

However, I do want to say that this particular issue caused significant problems. Aside for the database errors that were occuring at the rate of 2 to 3 times a day, Friday night my site was crashed for hours to due a database problem on your end per the tech's statement in the ticket. It was something that was causing an error message regarding global.php. The site was working fine Friday night then it just crashed and stayed that way to the next day. Then subsequent action was the fun part. Tech support decided to restore a 7 day old back up of theirs to rectify the problem. Well, I lost a weeks worth of data that consisted of new member registrations, threads, posts, sponsor info, etc.. Honestly, I almost considered leaving hostgator at that point. Because in the last two or three weeks I've experienced very poor site performance, high server loads of above 5 and I've seen 20. And then the database problems following the upgrade were beyond frustrating. Fortunately, for some freak reason I made a full CPanel backup about a day and half prior to the big crash. So, instead of losing a weeks worth of data I only lost about 32 hours. It was still terribly inconvenient, but a more acceptable loss.

I'm going to set up a cron job to run a script to do daily automated backups of my database. And if you have any form of uptime gaurantee program, I can assure you that my account fell through the cracks on that for the month of January.

Sorry for being so long winded, but try and see this from my point of view. I am actually very shocked at all problems I've had recently. I've actually been a satisfied customer prior to the last couple of weeks. You guys are a good host to compared to others I've been on. I'm surprised at the arbitrary and careless action to push through a MySQL & FastCGI update that crashed many many database driven sites like myself. Logic dictates that was something that wasn't tested prior to roll-out.

We actually tested it thoroughly on our development box and then we moved into a production test on 10 servers without issue. The issues didn't appear with the database corruption until we tried our first rollout to 100 servers. This is not something that normally happens and we try to take every opportunity to ensure there will be no problems whenever we upgrade our software.

[GatorNate]

During the past two days, we have continued to roll out fastcgi support to our shared hosting servers. We have decided not to move to mysql5.1 at this time.

I am finishing our upgrades to the shared servers tonight. We will be posting a schedule for our reseller boxes in the next little while.

[wii]

I guess my account was upgraded recently:

Apache v2.2.11 (cgi-fcgi)
MySQL Version 5.0.67-community

[archerws]

Is there any way we can as resellers get push information when things like this are scheduled? My clients' sites went down, and I had no idea why.

[kmaw]

Originally Posted by archerws

Is there any way we can as resellers get push information when things like this are scheduled? My clients' sites went down, and I had no idea why.

It will show up in the Announcements section of the forum. HG hasn't touched the reseller boxes yet, so your clients' sites going down would have nothing to do with this.

[striddy]

Originally Posted by kmaw

HG hasn't touched the reseller boxes yet, so your clients' sites going down would have nothing to do with this.

My reseller server now has FastCGI.

[kmaw]

Originally Posted by striddy

My reseller server now has FastCGI.

Sweeeet. I was going off Nate's post... oh well... who knows then... the magic shedule out there in cyberspace... lol

[wii]

Why has the upgrade of MySQL been dropped at this time ?

[GvilleRick]

Judging by previous posts there were a number of problems that arose in users' databases due to the upgrades to 5.1. There was a lot of complaining about corrupted databases and I suspect even more tickets.

[MegaHostUK]

Well i was wondering when the reseller boxs were gona be upgraded as some seam to already have been updated and others not aka mine lol. so i asked support and found out why

"Rory Sa: FastCGI is disabled on all servers for now due to security concerns we are looking into. "

[envygeeks]

What security concerns could you have with FCGI? It would certainly boost the speed of our sites. While we uses caches we certainly have no ability to control the extreme slowness of CGI vs. FCGI or Mongrel (not we don't necessarily need Mongrel). As well, does said FCGI only apply to Reseller?

[Kriz]

It's been about 2 weeks since I was told in a ticket "a new thread would be created in 24 hs" to talk about the security issue with FCGI on the reseller package.

Can any HG moderator post any news about it ?
Feels like is not going to happen...

Thanks-

[X Prime]

So, FastCGI is disabled on all servers, including shared hosting?

Will there be a general announcement when it is fixed?

[striddy]

Originally Posted by X Prime

So, FastCGI is disabled on all servers, including shared hosting?

Where did you read that? It's enabled on my server.

[X Prime]

Originally Posted by striddy

Where did you read that? It's enabled on my server.

I sent a ticket to support yesterday about enabling it (as I was told in Live Chat that I would have to do this to get it enabled) and got told, quote:

Currently there is a vulnerability that is currently preventing us from enabling this on the servers. This will be enabled within the coming weeks. You can find out more information in our forums.

Further, there is a post above indicating that it is disabled by MegaHostUK. Where does it say in cpanel or anywhere if it is enabled and usable?

[striddy]

Originally Posted by X Prime

Where does it say in cpanel or anywhere if it is enabled and usable?

Create a phpinfo page and you will be able to check it there.

[TheExoticFish]

I'm still having mysql errors.

[TheExoticFish]

This is ridiculous ! Two chats and a trouble ticket later and I'm basically told nothing is wrong and that someone on my site is causing the mysql errors !

[X Prime]

Originally Posted by striddy

Create a phpinfo page and you will be able to check it there.

I've been sick, I apologize for lateness.

Basically if it says 'cgi-fcgi' on it, it's enabled?

It's my understanding you have to use a wrapper to make PHP run in fastCGI mode, do you know how to do this?

[actionf]

Hi, on gator465 I cannot find the fast-cgi support. No Apache handler, no info in program version screen. I added an handler on .htaccess but I'm still not able to execute with .fcgi extension.

Any suggestion?

[newhall]

Originally Posted by archerws

Is there any way we can as resellers get push information when things like this are scheduled? My clients' sites went down, and I had no idea why.

Excellent point! All my MySQL sites started going down this morning without any warning. I had to open a trouble ticket and call support only to be told (on the second call only) that they're upgrading the servers. I've been told it may take up to 2 hours. Now, why is this being done in the middle of the day for all of the United States? Losing business and money!

[sharilynn1999]

on gator413.

receiving error:

MySQL said: Documentation
#145 - Table './sldhost_wrdp2/wp_posts' is marked as crashed and should be repaired

tried doing a repair myself and the syntax is wrong based on what is said in the documentation....

trying to use myisamchk -r -q on wp_posts in the *_wrpd2 table (*=hostgatorlogin id not printed for security reasons)

Was my gator upgraded and was it rebooted following that upgrade? were there any errors that occurred following it?

[sharilynn1999]

gator413 appears to have recovered... i will monitor in hopes it doesnt go wonky again...