Location: In front of a computer, who wants to know
Posted:
Fri Feb 27, 2004 8:51 am
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.
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]
simrin Support Mod
Joined: Jul 17, 2003
Posts: 524
Location: In front of a computer, who wants to know
Posted:
Fri Feb 27, 2004 9:32 am
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.
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]
simrin Support Mod
Joined: Jul 17, 2003
Posts: 524
Location: In front of a computer, who wants to know
Posted:
Fri Feb 27, 2004 10:10 am
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.
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