What powers ScubaBoard (techie post)?

Please register or login

Welcome to ScubaBoard, the world's largest scuba diving community. Registration is not required to read the forums, but we encourage you to join. Joining has its benefits and enables you to participate in the discussions.

Benefits of registering include

  • Ability to post and comment on topics and discussions.
  • A Free photo gallery to share your dive photos with the world.
  • You can make this box go away

Joining is quick and easy. Log in or Register now!

Hello,

How about a second server and set sql up to replicate real time between the two and load balance?

Ed
 
Thats what I was going to ask namelz52... what about getting some P4EE chips in there? I know they add a lot to the costs but those things should smoke! Not litterally... that would be bad :wink:
What about the newer Atholon 64 FX chips? Anyone tried those yet?
What type of RAM are you using? 400MHz? or 333Mhz?Dual Channel? Is the system bus running at 800MHz?
Another interesting tidbit, some PowerMacG5's are dual proc'ed and the system bus runs at 1GHz! I believe the RAM is still the same. Would be interesting to benchmark between the Mac's and PC's...
Either way keep up the good work guys!

Oh - I use a PC... not a Mac. In case any of you were wondering... :wink:
 
Heh, I had a bunch of questions, but
http://www.servermatrix.com/servers.html
seemed to answer them (I just looked at what they offered).

Remaining questions:
1) Which version of mysql is installed, using what sorts of tables?
2) What filesystem do they install on the server?

Comments:
1) To those who suggested the AMD64 architecture - I wouldn't consider Linux's AMD64 support ready yet for prime time, and I have a cluster of them. Making it work reliably is still iffy, and the server hardware that I've seen I wouldn't consider extremely reliable. Regardless, the company that hosts scubaboard doesn't currently support it.
(in regards to future scaling)
2) Have y'all done profiling of your mysql server, and what queries are being run from memory, and which are requiring disk i/o ? With the proper tuning, you should be able to get everything used for rendering a typical vbulletin page into system memory.
3) If you have the administration skill, the Linux 2.6 kernel series has made some noticeable improvements in performance and scalability.
4) You've probably already considered it, but a Squid reverse proxy in a httpd-accelerator configuration in front of your Apache configuration could potentially reduce disk hits and improve site responsiveness, as well. It is possible to explicitly specify how much ram is used for cached objects, so a truly large number of commonly accessed objects (smilies, logos, etc.) can be served directly from RAM without ever hitting the disk.
5) It's worth asking the vbulletin folks if there are any known issues, but there is a free PHP cache add-on available at http://turck-mmcache.sourceforge.net/ . This eliminates some i/o, and the processing required to repeatedly compile unchanging PHP scripts.

I'm sure y'all already knew some or all of that, but hey it was a chance to open my big mouth on stuff I work with a lot, I couldn't pass up :wink:

Good job on the site,
jeff
 
I would definetly recommend using a cluster of Linux machine for Scubaboard, although I am very bias to Linux ;-). For the programmers of Scubaboard, I would think most processor time is devoted to queries done on site. Are you guys using SQL or a custom data structure? Hash tables would be an interesting implementation. Whatever you are doing, keep it up because the site runs nice the way it is right now.

Gerard

p.s. Hiring any programmers?? I have a MS in computer science where I focused in cryptography.
 
gerardnealon:
I would definetly recommend using a cluster of Linux machine for Scubaboard, although I am very bias to Linux ;-).

Why do they need a cluster? They aren't under any significant load, yet.

For the programmers of Scubaboard, I would think most processor time is devoted to queries done on site. Are you guys using SQL or a custom data structure?

http://www.scubaboard.com/t49285.html (they're using mysql)

Hash tables would be an interesting implementation. Whatever you are doing, keep it up because the site runs nice the way it is right now.

Gerard

Seconded, of course (about the site running nice. I know that mysql already uses a hash implementation).

jeff
 
Fetch:
Why do they need a cluster? They aren't under any significant load, yet.

More for redundency i guess. Cluster does not have to be big. Beowolf clusters I believe can range in all sizes. Never know when a server will go down. I would hate not being able to read these replies.... ;-)
 
https://www.shearwater.com/products/perdix-ai/

Back
Top Bottom