• 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.
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!