Cpanel, Php, And Mysql

[sour-lime]

My current host for another site is asking us to move, as he's unwilling to support our "invisionboard errors". With his recent CPanel upgrade, the database is becoming corrupted, and when he "runs a repair" the problems often multiply. CPanel has released another update to solve this problem, and we've been told by posters at invisionboard that the main issue is to make sure that PHP is using the libs from mySQL instead of it's own.

 

We'd like to move here, but we'd like to be sure that we won't run into the same problems with accessing our forums. Can anyone help us understand the situation, and let us know what we can expect here?

[TCH-JimE]

Hi,

 

Well what do you get?

 

Have a quick look here:

http://www.totalchoicehosting.com/

 

you can compare your hosting here:

http://www.totalchoicehosting.com/web_host...ting_plans.html

 

and some FAQ you might have are already answered here:

http://www.totalchoicehosting.com/help/faq.htm

 

Tech support is great here as you can see!

 

In response to your question at present:

CPANEL 6.4

MySQL 4.0.12

 

Invision board can be setup by a simple script in your CPanel. I would recommend backin up your database every so often though, its just good pratice!

 

Besides this place offers a 30 day money back gurantee. Give them a try, if you dont like it, u dont have to stay, but i dont think you will want to leave!

 

Jim

[TCH-Sales]

I think ya covered just about everything Jim!

[knucklehead]

Tell your current host the problem is this -

 

The following got wacked with the latest cpanel upgrades -

 

Mysql Priv Tables

DBD::mysql perl module

Improper permissions in the db and user tables

chkservd thinking mysqld was crashed when it was working

 

Tell him to run this at the 'root' command line -

 

/scripts/updatenow

/scripts/fixmysql

 

Mikey

[sour-lime]

Thanks, guys. Jimuni, I've already got a site hosted here, and I was assuming that from the use of invisionboard on the forums that the tech team is aware of what was going on and how to fix it. We just want to be sure of that before we move, so we don't get stuck with the same problems.

 

Mikey, that's the kind of answer I was looking for As long as there's someone on staff here whose aware of it, so we won't lose our boards again. I've been doing a semi-regular backup since the site started, and a daily backup since we started getting errors. Our host has refused to run any more repairs, stating that the problem is with the way that invisionboard works with MySQL and that he's not inclined to fix it. Well, publically he's said that he already fixed it, but when it wasn't complete, and we asked about it again, he let us know that we should start looking for another host. Which just pushed up our deadline anyhow, because we were planning on moving at the end of the pay schedule.

[TCH-JimE]

Hi,

 

I have learnt over the years that its best to find a hoster which not only is cheap but also provides good tech support.

 

No offence to your current hoster but he sounds like a load of twaddle.

 

Upgrades that are pushed here are always done with the upmost care and attention to insure that the smallest problems are sorted, and if not they always try there best to sort it out.

 

I look foward to seeing you around the forums soon

 

Jim

[sour-lime]

That kind of makes me laugh. Not your fault, of course, but because we chose that company because of it's good tech support; it was more expensive than other places offering similar packages. Not only could we see a lot of help being given through the forums, but we were friendly with a group that ran a site similar to ours that had fabulous experience with them. That was the main reason for choosing them; because we knew that they'd be able to support our size and needs, and that they provided good tech support in practice as well as on the forums. I require different guarantees for my personal site that will get just a small number of visitors, then for our forums that are still growing rapidly at 500 members.

 

Unfortunately, things change, and a site that offers great technical support one month, isn't always as great a few months down the road. The tech team here also comes across situations where it's not worth it for them to host a site because it uses up too many resources or has too particular needs as far as the software they require, even when a site otherwise fits within their contract. I do think our host was being unreasonable, but I'm also aware that it's common practice from hosting companies, and there's really no way to be sure that it won't happen to us again in the future as long as we're not using our own dedicated servers. A bit of a price jump required for that, though

[sour-lime]

Mikey, you've commented in another thread that you have noticed db problems with invisionboard, and Head Guru has mentioned plans to convert these forums to vBulletin. Personally, I'm happy with the performance I've experienced from invisionboard, both in the last three months as an administrator, and previously as a moderator. I know my fellow admins feel the same way, and our members have been very pleased with the software. In addition, I'm not inclined to devote the time and energy necessary to convert to and customize new forums, nor would we be able to afford vBulletin without asking our members for donations.

 

Our main concern about moving our site is, "will we be able to keep our forums up and active?" We know that we fall within the storage space and bandwidth of the lowest available plan, but we don't have the technical knowledge to know whether or not we'd be experiencing other problems, such as causing too many database queuries or having incompatibilities with invisonboard/mySQL. The group that recommended that host to us was just asked to leave recently, because their forums were making too many queries, even though their use has only increased minimally over the last 8 months. They've been told by their new host that their levels are very normal, and mostly caused by an indexing problem (with vB) which he helped them repair. We've been told that the problems we're experiencing with the database is because invisionboard "does not work well with MySQL4", even though the answers we're finding does not support that.

 

So, again, I ask, just to be sure.... If we move our site here, can we be reasonably assured that our forums will work correctly? Here's some information that I gathered that I think will help you understand our use. Let me know what's important and if there's any other data I can collect.

 

Ceiling Averages based on invisionboard's "Statistic Center"

750 private messages sent

3000 posts per month

75000 page views per month.

 

SQL Runtime Information

Bytes_received 47087607

Bytes_sent 2247820410

Com_update 2204312

Connections 1534443

Created_tmp_disk_tables 135562

Created_tmp_tables 999507

Key_blocks_used 375052

Key_read_requests 687076501

Key_reads 8182868

Key_write_requests 23139003

Key_writes 2147180

Max_used_connections 94

Qcache_hits 14991842 Qcache_free_memory 17442520

Qcache_free_blocks 5320

Qcache_total_blocks 24031

Select_scan 2522144

Threads_created 16583

 

By the nature of discussions, our forum use varies. We have days where there are more than 50 member connected at once, but also long periods with less than 10 at any given time. We expect the use to spike a bit over the next four weeks, and then dwindle down until the next increase in September.