Forum software for 10 million users?

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Varius
    Confirmed User
    • Jun 2004
    • 6890
    #1

    Forum software for 10 million users?

    Does anyone think vBulletin or phpBB will handle 10 millions users in their mysql database? What if I alter all their tables to InnoDB.

    Note: There may be 10 million rows in the user table, but that doesnt mean they all post or do anything......so I'm just worried about their myISAM table having the 10 million rows (re: possible corruption), not load issues though
    Skype variuscr - Email varius AT gmail
    Tags: None
    • xclusive
      Too lazy to set a custom title
      • Apr 2004
      • 35218
      #2
      vbulletin is the better option for this but even that is a little shakey I would look into a custom build of a bulletin board if you are really looking to back it big time...

      I support MediumPimpin.com / Shemp's Outlawtgp.com /


        Comment

        • Varius
          Confirmed User
          • Jun 2004
          • 6890
          #3
          Originally posted by xclusive
          vbulletin is the better option for this but even that is a little shakey I would look into a custom build of a bulletin board if you are really looking to back it big time...
          Yeah I was thinking custom code too....but was curious if simply modifying their DB from myisam to innodb would work.

          I may try and test that out to see what happens
          Skype variuscr - Email varius AT gmail

            Comment

            • gxer
              Confirmed User
              • Dec 2002
              • 846
              #4
              I really doubt that any version of MySQL will handle such amount of users.

              There is a solution called Oracle.

              Mysql can't handle 10 million users and even a half of that.

                Comment

                • xclusive
                  Too lazy to set a custom title
                  • Apr 2004
                  • 35218
                  #5
                  Well you could try and do that but i'm thinking it would just lead to more hassles in the long run... I would optimize some custom code and make sure your server has as much ram as possible...

                  I support MediumPimpin.com / Shemp's Outlawtgp.com /


                    Comment

                    • jimmyf
                      OU812
                      • Feb 2001
                      • 12651
                      #6
                      gxer is right

                      and it ain't cheap
                      Epic CashEpic Cash works for me
                      Solar Cash Paysite Plugin
                      Gallery of the day freesites,POTD,Gallery generator with free hosting

                        Comment

                        • Varius
                          Confirmed User
                          • Jun 2004
                          • 6890
                          #7
                          Originally posted by gxer
                          I really doubt that any version of MySQL will handle such amount of users.

                          There is a solution called Oracle.

                          Mysql can't handle 10 million users and even a half of that.
                          MySQL with InnoDB can supposedly handle 100 million rows+ in a single table....I know some people who have that much data and they don't have problems.
                          Skype variuscr - Email varius AT gmail

                            Comment

                            • xclusive
                              Too lazy to set a custom title
                              • Apr 2004
                              • 35218
                              #8
                              As long as you keep it clean and maintain it I believe you would be fine. I say give it a shot and let us know how it turns out...Remember get a server with as much ram as humanly possible or it will lag big time...

                              I support MediumPimpin.com / Shemp's Outlawtgp.com /


                                Comment

                                • Varius
                                  Confirmed User
                                  • Jun 2004
                                  • 6890
                                  #9
                                  Originally posted by xclusive
                                  Well you could try and do that but i'm thinking it would just lead to more hassles in the long run... I would optimize some custom code and make sure your server has as much ram as possible...
                                  Yeah our matser DBs have 3-4 gigs ram and are dual-xeons (or I think one is a quad-xeon)

                                  I can't wait for MySQL Cluster to be fully released though, allowing us to have true Synchronous replication (and thus multiple Masters)
                                  Skype variuscr - Email varius AT gmail

                                    Comment

                                    • http
                                      Confirmed User
                                      • Oct 2001
                                      • 1811
                                      #10
                                      This one is running on PhpBB

                                      Not 10 Mio but still probably the biggest on PhpBB

                                      Gaia has 226927422 articles posted, with 175262033 in storage
                                      We have 1159755 registered users
                                      Most users ever online was 20919 on Mon Nov 15, 2004 8:30 pm




                                      This one has over 5 Million members but it's not PhpBB, looks like a custom software

                                        Comment

                                        • Project-Shadow
                                          Confirmed User
                                          • Feb 2003
                                          • 7340
                                          #11
                                          Originally posted by gxer
                                          There is a solution called Oracle.
                                          Oracle is probably your best bet, but MySQL would be able to push the 10mil as long as you kept it clean, up to date, and had one hell of a box(s)

                                            Comment

                                            • Varius
                                              Confirmed User
                                              • Jun 2004
                                              • 6890
                                              #12
                                              Originally posted by http
                                              This one is running on PhpBB

                                              Not 10 Mio but still probably the biggest on PhpBB

                                              Gaia has 226927422 articles posted, with 175262033 in storage
                                              We have 1159755 registered users
                                              Most users ever online was 20919 on Mon Nov 15, 2004 8:30 pm




                                              This one has over 5 Million members but it's not PhpBB, looks like a custom software
                                              Cool thanks....I emailed them to see if they used it as-is, or modified it to InnoDB or other changes.....hopefully they'll let me know
                                              Skype variuscr - Email varius AT gmail

                                                Comment

                                                • http
                                                  Confirmed User
                                                  • Oct 2001
                                                  • 1811
                                                  #13
                                                  If you want to be safe on the hardware side, you may want to consider this extremely competitively priced Quad system from LayeredTech (I have 8 servers there, they have - real - 24/7 support, and the Quad Opteron will be on their Savvis network (former Cable & Wireless, good network)

                                                  ? 4 x AMD Opteron 842+ w/1MB L2 cache
                                                  ? 3 x 73GB U320 SCSI Hard Drive (RAID5)
                                                  ? RAID 1/0/5 or JBOD available depending on OS
                                                  ? 4GB ECC DDR RAM
                                                  ? Bandwidth: 10Mb/s Un-Metered (Savvis)
                                                  ? IP Addresses: 32 (29 usable)
                                                  ? Private VLAN
                                                  ? Number Of Servers: 1
                                                  ? Basic Resource Monitoring
                                                  ? FreeBSD, Linux, Windows*
                                                  ? 100% Self Managed and Dedicated

                                                  Monthly Fee Options:
                                                  ? $999.99 (Plus One-time Setup Fee of $179.00)

                                                  This system can hold 16 GB with (relatively) cheap 1 GB dimms (and up to 32 GB with 2 GB dimms).

                                                  Based on the price for the above system, the same with 16 GB RAM should be around $1,500 / month

                                                    Comment

                                                    Previous template Next
                                                    Working...