Hi, Couple of things to consider when you are in for high traffic apps:
1. Code Number ONE is your code and how well you wrote it for your app. You need to use a lot of caching (OpenBD has the superb cachename and cache domain tags for an app server caching, else use memcache). Use NewRelic to analyze your code and tweak. We've used them in the past and found many places to improve our code. It's one of those tools you think you don't need it, until you used it and don' want to miss it anymore. 2. Database I'm in love with MongoDB. It works perfectly and especially with the build in tags from OpenBD, MongoDB in CFML is a piece of cake. Nevertheless, the decision to use MongoDB or MySQL is up to you. There are some impressive websites out there with zillions of users and traffic that uses MySQL. Here is a link for comparing; http://www.mongodb.org/display/DOCS/MongoDB,+CouchDB,+MySQL+Compare+Grid MongoDB comes with auto-sharding which is quite powerful. Take a look at: http://www.mongodb.org/display/DOCS/Sharding 3. Server Obviously, you will need some serious server setup for your project. You should look into load balancing, failover concepts and more. OpenBD is deployed on a J2EE server so you can scale Tomcat (a example) quite well. Front it with Apache or Nginx to take load off the J2EE server and so forth. Many more things to twelve into here… 4. DNS Seriously, one of the most unused techniques of many is the use of a professional DNS service. There are tones of differences in using DnsMadeEasy, Dyn, etc. or your "local" ISP when it comes to DNS. You can even achieve DNS load balancing and diverse network connections with DNS. Last but not least, I would worry about scaling when you have the problem! You will save a lot of money upfront and nowadays adding more RAM or servers is not a 3 month project anymore :-) Hope this helps. Kind Regards, Nitai On Sat, Mar 3, 2012 at 12:44 PM, Rick <[email protected]> wrote: > We've all participated in -or- have read on building for smaller traffic now > and dealing with scalability as things progress. > > While I agree with the sound wisdom, I am in a position to where I am > preparing to launch several projects - and a couple of them will use the > same type of user-having-multiple-categories-of-interest-or-expertise (user > one-to-many categories). I'd rather head in the more scalable direction > from now if it will only take a little bit longer to implement code-wise. > > I've been toiling with this thought in my mind on the best approach to > accomplish this. I've used nested sets in relational databases in the past > but never for anything with high traffic. There is one particular project > that I know without a doubt that will attract the masses on FB and other > social settings. Yes, scalability for this particular project is a major > concern. > > I have not taken the dive into nosql databases in any productive manner yet. > However, I am considering a solution with CassandraDB, Mongo, or AWS > Dynamo. Otherwise, it's back to MySQL and nested sets. > > Do the nosql DBs present an advantage for this type > of hierarchical "category" data / user relationship? > Is there a better open source db I did not mention that may be more fitting > for the task? > Side question: I've installed cassandra db on my laptop and hadn't gotten > around to connecting to it through OpenBD. There's no reason they should > not be able to work together- correct? > > Any insight would be helpful. > > > > -- > online documentation: http://openbd.org/manual/ > google+ hints/tips: https://plus.google.com/115990347459711259462 > http://groups.google.com/group/openbd?hl=en -- See for yourself how easy it is to manage files today. Join the revolution! Razuna - Hosted Digital Asset Management Solution http://www.razuna.com/ Razuna - Open Source Digital Asset Management http://www.razuna.org/ Twitter - http://twitter.com/razunahq Facebook - http://www.facebook.com/razunahq Support Platform - http://getsatisfaction.com/razuna -- online documentation: http://openbd.org/manual/ google+ hints/tips: https://plus.google.com/115990347459711259462 http://groups.google.com/group/openbd?hl=en
