SitePoint Sponsor

User Tag List

Results 1 to 5 of 5

Hybrid View

  1. #1
    SitePoint Guru sowen's Avatar
    Join Date
    Feb 2001
    Location
    Stockport, UK
    Posts
    729
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Community Scalability

    Sorry I know this is a very broad subject but how do you plan from the outset for scaling up your community?

    I am using Snitz and MS access on a cheapo hosting plan (no sql databases, no ssl etc.). If things take off I know Access will not cope and I may need to swap to paid for community software.

    What sould I be doing now when only 2 people have signed up (you know who you are, I thank you! to allow for the possibility of lots of members in the future?

  2. #2
    Serial Publisher silver trophy aspen's Avatar
    Join Date
    Aug 1999
    Location
    East Lansing, MI USA
    Posts
    12,937
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Better to spring for something like phpbb which is a free php/mysql based board.

    Doesn't have all the features of vb, but for the price you can't beat it.

    That will allow you to have 1000's of members.
    Chris Beasley - I publish content and ecommerce sites.
    Featured Article: Free Comprehensive SEO Guide
    My Guide to Building a Successful Website
    My Blog|My Webmaster Forums

  3. #3
    SitePoint Guru sowen's Avatar
    Join Date
    Feb 2001
    Location
    Stockport, UK
    Posts
    729
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Cheers aspen,

    I am more worried about concurrent access as the number of members grow. My idea will either totally flop or increase to very large numbers of members, I don't think there will be any inbetween

    I think I actually have two questions don't I

    1. What backend do the big boys use (PHP, asp, a.n.other) with which forum script/software.

    2. What is a good host that supports 1. above and allows me to sign up for a cheap personal plan but smothly throttle up my bandwidth and services if required.

  4. #4
    SitePoint Zealot Overgrow's Avatar
    Join Date
    Jan 2001
    Location
    Your basement
    Posts
    192
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    1) The popular choice for mid-size communities is the obvious one you're on right now-- vBulletin running PHP and mySQL. Sitepoint runs it. I run it (220 peak concurrent). Larger forums run it (Somethingawful.com, 600+ peak concurrent). Get started with the vBLite version or phpBB if you want to avoid the $99. Luckily PHP and mySQL are both free so the startup cost is low.

    Anything bigger than that and you are probably going to have to write your own database layer and tie vB into Sybase / Oracle. Or look to a higher-traffic community like Web Crossings (CNN, ESPN). Here you're talking about server farms and 10's of thousands in licensing fees if not more.

    2) Read Sitepoint's hosting forum for the latest info. Also check vBulletin.com's host forum. Both will have many hosting options and lots of opinions on a suitable site for a community vB. I'm sure SP wouldn't mind if you clicked their new hosting sponsor to check prices as well.
    Overgrow the Government: The Edge Forums
    presented by Overgrow Marijuana Magazine

    *warning: adult content

  5. #5
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    Join Date
    Aug 1999
    Location
    Lancaster, Ca. USA
    Posts
    12,305
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    I don't really know the particulars about Snitz Forums but from what I do know they have scalability built. More than even vBulletin does currently.

    Right now you have MS-Access as a backend. You can probably support up to 20-30 concurrents with this software. That can be 300 posts a day. However if you are going to grow like you hope you can hit this ceiling quickly.

    Snitz also works with both MySQL and MS-SQL. Your next step up would be MySQL. This as Overgrow said can be scaled to over 600 concurrent users with the proper server environment. Not all servers will be capable of this.

    Your final choice is MS-SQL Server. This is a medium to large scale enterprise class database server and it is offered by many Windows hosting plans. It may even be offered by your current host as an account add-on. Upgrading from Access to MS-SQL Server is relatively easy and Microsoft distributes an upgrade tool to make it easier. This server is designed to handle 1,000s of concurrent users over multiple machines. In my opinion there is only one database system that is more scalable than this and that is Oracle. Alta Vista used MS-SQL Server exclusively for their search engine up until recently. They get millions of uniques a month.

    Check on the Snitz support forums and see what the members there have to say.
    Wayne Luke
    ------------



Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •