Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Cluster EIS tier?

 
James Turner
Ranch Hand
Posts: 194
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Guys,

I have been reading up on tier architecture and have seen that for 2-tier architectures, performance can be bad under heavy loads because access to the database can become a bottleneck.

With 3-tier architecture, it seems that performance is good because due to the ability of clustering individual tiers.

My question is:

a. Is it possible to cluster the database/EIS tier?
b. All of the projects I have ever worked, regardless of web and business-tier clustering, don't cluster the database, doesn�t this mean access to the database is still a bottleneck, therefore giving the same performance as a 2-tier architecture since they both have the same issue?

Thank you for any help.

James.
 
Pavel Grushetzky
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
a. I believe that the answer for your question is "it depends". For example, you can definitely do that with Oracle, but I can't say the same for all vendors.

b. Again, it depends on application nature. For example, data access overhead can be much less than data processing overhead and vice versa. You can't say for sure where the bottleneck is unless you collect the numbers.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic