You are missing our premiere tool bar navigation system! Register and use it for FREE!

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
Modules
· Home
· FAQ
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· PHP-Nuke HOWTO
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 217 guest(s) and 0 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
Nuke Cops :: View topic - NC DB and Performance? [ ]
 Forum FAQ  •  Search  •   •  Memberlist  •  Usergroups   •  Register  •  Profile •    •  Log in to check your private messages  •  Log in

 
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
Author Message
simrin
Support Mod
Support Mod


Joined: Jul 17, 2003
Posts: 524

Location: In front of a computer, who wants to know

PostPosted: Fri Feb 27, 2004 8:51 am Reply with quoteBack to top

I have some ideas (find some of my recent posts) for a collaboration of websites that both maintain independant but also some shared dbs. The ideas I have could potentially generate 10 times the traffic that NC does and I want to know what are you guys using for your DB and how is the performance. I have been thinking a lot about postgres but not sure. Any thoughts on that?

_________________
NC Support Mod

Are you there? No I am a figment of your imagination.

www.hostileguild.net
Find all posts by simrinView user's profileSend private messageSend e-mailVisit poster's website
Zhen-Xjell
Nuke Cops Founder
Nuke Cops Founder


Joined: Nov 14, 2002
Posts: 5939


PostPosted: Fri Feb 27, 2004 9:20 am Reply with quoteBack to top

Right now the NC DB size via MySQL-Tap is:

162,639.914 KB (160+MB)

Computer Cops mysql-tap states:

1,374,719.107 KB (1.2+GB)

10 times more traffic than NC would be roughly 800,000 hits per day. CCSP currently sees about 1.9 times more daily traffic than NC: 152,000 (rough rough estimates).

MySQL at these levels needs to reside either on distributed systems or SCSI drives (single server). It will bog down server performance close to these current levels.

_________________
Paul Laudanski, Microsoft MVP Windows-Security
CastleCops: [de] [en] [wiki]
Find all posts by Zhen-XjellView user's profileSend private messageSend e-mailVisit poster's website
simrin
Support Mod
Support Mod


Joined: Jul 17, 2003
Posts: 524

Location: In front of a computer, who wants to know

PostPosted: Fri Feb 27, 2004 9:32 am Reply with quoteBack to top

What do you think of postgres. I have heard from a lot of people that it is really solid and reliable for production sites. My thoughts are to have a distributed network of sites that share user information and say private message information so you can create one login but other than have independant sites with unique content. The user tables would be the ones getting mauled if you had say 100 or so users but 9-10 sites with that many people on them.

_________________
NC Support Mod

Are you there? No I am a figment of your imagination.

www.hostileguild.net
Find all posts by simrinView user's profileSend private messageSend e-mailVisit poster's website
Zhen-Xjell
Nuke Cops Founder
Nuke Cops Founder


Joined: Nov 14, 2002
Posts: 5939


PostPosted: Fri Feb 27, 2004 9:36 am Reply with quoteBack to top

CCSP sees 1500-2000 users on at the same time any time using MySQL with no issues.

If you expect that much traffic against a shared database, then I would recommend using distributed database systems on SCSI. Pass off as much as you can from the CPUs to the SCSI controller cards.

I've never had the need for postgres. My world is Oracle and MySQL. MySQL suits my needs wonderfully.

As an aside, I have been a staffer at http://broadbandreports.com for over two years now. That site sees about the traffic you refer to... all MySQL driven.

_________________
Paul Laudanski, Microsoft MVP Windows-Security
CastleCops: [de] [en] [wiki]
Find all posts by Zhen-XjellView user's profileSend private messageSend e-mailVisit poster's website
simrin
Support Mod
Support Mod


Joined: Jul 17, 2003
Posts: 524

Location: In front of a computer, who wants to know

PostPosted: Fri Feb 27, 2004 10:10 am Reply with quoteBack to top

Thanks Zhen I may discuss some more things with you in private in reguards to this. To get your thoughts and impressions about the feasibility of the idea.

_________________
NC Support Mod

Are you there? No I am a figment of your imagination.

www.hostileguild.net
Find all posts by simrinView user's profileSend private messageSend e-mailVisit poster's website
Display posts from previous:      
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2005 phpBB Group

Ported by Nuke Cops © 2003 www.nukecops.com
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::
Powered by TOGETHER TEAM srl ITALY http://www.togetherteam.it - DONDELEO E-COMMERCE http://www.DonDeLeo.com - TUTTISU E-COMMERCE http://www.tuttisu.it
Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.246 Seconds - 122 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::