How much can Hosting plan MySQL servers handle.

[chepistolas]

Hello, I have a godaddy account which is I bought to test and develop websites. My question is now that I have a project that I want to unleash into the public I would like to know what I can expect of my shared host server. The MySQL databases which are the heart of my site, are hosted in a shared server, and the last thing I want my community to see is the diggeffected Wordpress error screen.

I want to know how:

1. How many users [general number] I can provide service too without going over my limit in processing power and quiting on me? Does any one know the general amount of users a basic plan can handle?
   

• 
  Or would I be better off to host a a freeBSD system with MySQL at home wit my cable connection with a 50 KB/s upload speed

• 
  Or is there a webhosting company that only sells a service for MySQL databases

• I would upgrade my hosting service when I do get more traffic, but would that help me with my databases? Should I just get a better host to host my databases?

If you want to see my site its http://www.luconline.com I still have to work on it but I see a launch date in the next week or two.

I would say my school has 5k students + 1-2K alumni that I want to help out.

Thanks for those who helped, I greatly appreciate it. I have tried to google but I wanted a custom answer to my needs.

 

[rogersmj]

This is really something you're going to have to ask your host, they will know the best. Most decent hosts don't have any problem with hundreds if not thousands of concurrent users. Most of the people whose sites get the Digg effect are on crappy hosts. My site has made the front page of Digg and I got 25,000 visitors in one day (15,000 of them within an hour), and my site never died; I use Dreamhost.

As for your second suggestion, good God NO DO NOT HOST IT AT HOME. For some reason there's a fair number of people that seem to think that is a good idea. First of all, your upload speed usually sucks. Second of all, even if it's decent, home connections are not necessarily the most reliable and are not designed to host sites. The routing is not very efficient, hops are longer, and of course you have to manage the machine yourself. I maintain a development server at home, which I can access from anywhere, but I would never want to host a real site there and I'm on a 15Mb/1.5Mb cable line.

Short answer, ask your host, but I'm quite certain you'll be fine, especially with GoDaddy. They know what they're doing and they don't use junk servers like some hosts. You say your school only has 5k students; that's a small number, and you'll never have anywhere near all of them on at once. My site gets that much in a week and that's still pretty small compared to really popular sites.

 

[D0ct0rteeth]

mrogers is absolutely right. your fine, and with specifically godaddy - you'll have no problems. They are a fine operation in that aspect.

I dont use them for my larger projects, but for something your size you'll be fine. If you are concerned give em a call and they can increase your plan for ya.

I run several sites, one with almost 100,000 users and we have mySQL databases and run TB's of data a day thru it. you have nothing to worry about. This particular site isnt hosted on godaddy, but it has been dugg very often and its never flinched - so the architecture and framework isnt an issue.

Lastly, do not. absolutely do not attempt hosting it at your house. bad plan.

 

[mac-convert]

Early last year I began a search for a hosting site that offered everything you are looking for and more. I learned quite a bit about the business, and after about three or four months of comparing and understanding I settled on one called bluehost.com that met all my needs. They went through a few bumps, but have been excellent to date, and I now have two sites with them. This is not an sales pitch for them, just a recommendation based on my experience.

 

[Stampyhead]

Early last year I began a search for a hosting site that offered everything you are looking for and more. I learned quite a bit about the business, and after about three or four months of comparing and understanding I settled on one called bluehost.com that met all my needs. They went through a few bumps, but have been excellent to date, and I now have two sites with them. This is not an sales pitch for them, just a recommendation based on my experience.

Yes, they are very good. Both they and GoDaddy are high up in my books for stability and ease of use.