GoDaddy as a host for vBulletin

[a squared]

I’ve read quite a bit about members’ experiences with GoDaddy as a host. None of which is great by any standard. But, one thing that everyone has failed to mention is if they have been using a shared or a dedicated server. The reason that I ask is that we are currently on a shared server with another host and of course PHP is being run in safe mode. And even with the search function turned off. We are experiencing databases outages 2-3 times a day due to the old 1226 exceeded the 'max_questions' resource (current value: 50000). Anyway, the host is unwilling to turn off safe mode. And, I understand why. So, I can’t hold that against them. In the end it’s time to move to another server or host. The owner of the forum that I am working on has a buddy that has recently picked a dedicated server at GoDaddy. Can any of you give me your experiences with GoDaddy’s dedicated servers? And what should I ask this fellow to do to optimize his server for hosting a small to medium size vBulletin forum. I know he has PHP installed (although I don’t know which version yet) and that safe mode is turned off. The current population is 560, slowly but steadily growing, and an average users online number is 25-50. I do expect some more growth in the upcoming year. The ezBoard forum we moved away from had over 2600 members.

[Marco van Herwaarden]

Safe mode has nothing to do with the max connection error. If your host is allowing you to have multiple MySQL users, and is measuring the connections per user, there might be a solution for you to trick your current host.

[Dead End Society]

I started out with them and had to leave, my forum was so slow and we had many downtimes. The support was terrible as well.

[Brandon Sheley]

I've never used Vb on godaddy hosting, but I have set several html and asp sites up,, I was not pleased with them, my boss ( who is the reason I used godaddy, they have hosting with them ) doesn't no 2 sh*ts about webdesing and hositing, but i expressed my deep feelings about how i dislike godaddy.
and also i belive the sever he used is a windows one, took me a week or talking to him, and talking to godaddy so I could CHMOD a few files on a site I was working on :|
i give them the lowest rating possible,
but they are good to buy url's from ..lol this is the ony things i use em for

[a squared]

MarcoH64, I've confirmed that there is no limit on users for MySQL. And you've intriged me. Could you elaborate on you statement, "...there might be a solution for you to trick your current host".

Dead End Society and Loco Macheen were you on dedicated servers?

PS it isn't my choice on hosting either.

[Marco van Herwaarden]

Sorry no time to post a finished solution for you now, i am on my way out. But what you basically do is create more MySQL users (and give them permission to the database). Then you change the ./includes/config.php to choose a random username out of the list, so you are spreading the load over a few users.

I think there are some examples posted at vb.com, but not sure.

[melodiq]

Don't Use Godaddy As A Webhost!!!!

[a squared]

MarcoH64, I've found it found it!!! A simple array. This thing should really be a sticky somewhere. Thank you for your help! :up:

PHP Code:

// ****** DATABASE USERNAME & PASSWORD ******
// This is the username and password you use to access MySQL.
// These must be obtained through your webhost.
$users[] = 'xxxxxxx';
$users[] = 'xxxxxxx';
$users[] = 'xxxxxxx';
$users[] = 'xxxxxxx';
$users[] = 'xxxxxxx';
$users[] = 'xxxxxxx';
$dbusername = $users[ rand(0, (count($users) - 1)) ];
$dbpassword = 'xxxxxxx';