Quote:
Originally Posted by Bobblehead
Thanks, I'm always curious how the backend works.
Can you pass on any DB statistics? I'm assuming it is MySQL. (I'm an Oracle dba, so I'm curious about your table sizes, schemas, etc.)
|
Yes, it is MySQL. You'll need to hassle Photon for details on the db details.
I can tell you that we've been successful in offloading most of the static content which has dropped our bandwidth usage by about 30%. We've also implemented some aggressive caching policies to make sure that your browser caches as much javascript, css, and image content as possible. Bandwidth savings should continue to improve as more CPers cache the static content.
The goal is to have the server only serve PHP generated HTML, with everything else being served by our content distribution network servers. Filling the pipe with avatars is not the most efficient use of our bandwidth!
The end result should be faster page loads (content loads much faster from your browser cache) and a server that is much more responsive under load. Apache is definitely doing a LOT less work than it was at this time last week.
It will take some *serious* concurrent page requests (~15-20 pages per second) before we fill the pipe again...