Okay folks, I'm currently hosting all of my stuff with my own Wild West Reselling Account, i.e., InnoDomains.com.
Problem is I'm running multiple Wordpress Installations and a few websites that have some pretty intense MySQL work going on in the background, and I use about 250GB per month in bandwidth.

My Account gets the 503 downtime errors because according to Customer Service I cannot run more than 50 MySQL queries in one second. Well, that's not much of a challenge because a lengthy wordpress page runs about 90 queries and loads in 2-3 seconds. Time this by three including the other websites and a couple of shopping stores, and I'm easily doing more than 100-150 queries a second more than several times a day, thereby seeing that nasty, irritating error.

My other option is to split up all the websites over basic $ 3.95 per month accounts. I don't want to switch to a dedicated server yet because I'm not really making a whole lot of money (about $ 30 per month). Another thing I could do is move my MySQL testing to a local machine, and that may actually reduce the load on the damn server.

Are there any hosts out there that will allow me to do more than 100 MySQL queries per second? If so, are there any that are any good?

Have you looked at installing WP Super Cache? It stores your pages in the file system like a plain HTML page basically eliminating MySql queries, except of course when someone leaves a comment which requires database interaction.

Give that a shot and monitor your queries.

Well, I was suspended for only 21 queries per second at namecheaphosting. Installing WP-Super-Cache made no difference. My opinion on this is stick to hosts that do not offer hosting as a side business from their reistrar services. WildWest domains is a GoDaddy thing, isn't it? You will be far better off at a place like Hostgator, or some of the others that have a good reputation around here. 50 queries per second shouldn't be that intensive.

Pushing 250GB with wordpress... 50+ simultaneous database connections... you're lucky to be getting to that level in what is a budget shared hosting environment, at Godaddy.

Shared hosting is not really an option anymore I'm afraid. I'd look for bigger and better things. The only other option I see is to split the usage by getting a number of shared hosting accounts.

The other option is to go for semi-dedicated - ie. a host that will only put a very limited number of sites onto a machine, and let them use whatever resources they need.

There shouldn't be a need for dedicated, yet. Try a VPS. It's what I switched to for my WordPress sites. And you can get a decent, managed one for around $30 monthly. I'd check out Knownhost, they have the best service around. And they are fully managed with cPanel.

I'll have to agree with the posts above, semi-dedicated or VPS should be the way to go.

Get a VPS with a high memory and CPU allocation. Install your site, and tweak the bejesus out of MySQL. Think high cache memory amounts. That should help tremendously.

I'd strongly recommend ServInt. Used them for a while and have nothing but positive remarks.

Everyone,

Thanks so much for all the advice. Here is the feedback I have so far:

- WP Supercache read very promising, but it really hasn't done much good. Almost all of my pages have comments, so as it turns out it is not doing me much good at all.

- The dedicated / semi dedicated / virtual dedication option: These are great, and in some instances even come within $ 50 per month, but the problem with such a server is takes too much time to set up. I have dedicated hosting in mind, but in due course. I'm working on developing a pretty big website (designerpottery.com/blog), and that's a for profit model, so paying for something dedicated actually makes sense there.

- The VPS option again sounds good, but it takes time setting up. I've looked into getting a VPS, and this may actually be the direction I go in shortly.

- Hostgator: Ah, yes! Indeed, I give them a pat on their back for service. I spoke to them, and they said anything over 65 queries a second and you're looking at using over 25% of the resources, which means you will lose connectivity. However, Host Gator also said that going with a VPS would not solve the problem, because resources are shared and, at least at Host Gator, 25% of system resources would equal account suspension. According to their customer support, dedicated or semidedicated is the only option.

I think in due course it may be a good idea to move all my sites over to a dedicated server, since I will be paying for one. But for now, maybe I should stick to an under $ 10 shared hosting plan probably still with innodomains just to host the blog asifism.com, and move all of my other sites over to a separate shared hosting plan so at least they don't get suspended. I've already done that with one site where a shopping store will go live later this week, but at this point I don't see another feasible option.

Designer Pottery is, at earliest, months from completion since I don't have development help either. At this point, I'd like to keep total hosting costs under $ 20 per month (I know I'm being cheap. I'm an accountant, can't help it).

Any other suggestions? Or anyone wanna split a dedicated / semi dedicated host?

imountain.com clustered vps offer a remote mysql, email and dns servers .
So, httpd got your server for itself.
I think it can easy cope for what you need.

I run Drupal with that configuration with no probl.

bob

iMountain seems like a good option. I'm actually considering cluster based hosting, although my experience with servage was horrid. VPS on clusters sounds like a better idea. Anyone else had any experiences with any other cluster based VPS hosts pulling heavy MySQL Queries and about 250GB monthly traffic?

Only use wordpress? I think you can try cos-html-cache, create static html files for wordpress when edit delete or comment a post.

I was with servage before i switched to imountain.com.
There is no way to compare those two.
imountain wins big time.
Their remote mysql server just roars.

bob