Forum software for 10 million users? - GoFuckYourself.com

Varius · 11-21-2004, 02:24 PM

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

xclusive · 11-21-2004, 02:26 PM

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...

Varius · 11-21-2004, 02:36 PM

Quote:

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

gxer · 11-21-2004, 02:46 PM

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.

xclusive · 11-21-2004, 02:49 PM

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...

jimmyf · 11-21-2004, 02:57 PM

gxer is right

and it ain't cheap

Varius · 11-21-2004, 02:58 PM

Quote:

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.

xclusive · 11-21-2004, 03:00 PM

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...

Varius · 11-21-2004, 03:00 PM

Quote:

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)

http · 11-21-2004, 04:00 PM

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

Project-Shadow · 11-21-2004, 04:05 PM

Quote:

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)

Varius · 11-21-2004, 04:08 PM

Quote:

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

http · 11-21-2004, 04:20 PM

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

11-21-2004, 02:24 PM	#1
Varius Confirmed User Industry Role: Join Date: Jun 2004 Location: New York, NY Posts: 6,890	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

11-21-2004, 02:26 PM	#2
xclusive Too lazy to set a custom title Join Date: Apr 2004 Location: Buffalo, NY Posts: 35,218	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 /

11-21-2004, 02:49 PM	#5
xclusive Too lazy to set a custom title Join Date: Apr 2004 Location: Buffalo, NY Posts: 35,218	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 /

11-21-2004, 02:57 PM	#6
jimmyf OU812 Join Date: Feb 2001 Location: California Posts: 12,651	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

11-21-2004, 03:00 PM	#8
xclusive Too lazy to set a custom title Join Date: Apr 2004 Location: Buffalo, NY Posts: 35,218	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 /

11-21-2004, 02:46 PM	#4
gxer Confirmed User Join Date: Dec 2002 Location: Location Posts: 846	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.

11-21-2004, 04:00 PM	#10
http Confirmed User Join Date: Oct 2001 Posts: 1,811	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

11-21-2004, 04:20 PM	#13
http Confirmed User Join Date: Oct 2001 Posts: 1,811	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