dbTalk Databases Forums  

cluster,performance, 6k clients and lobs

comp.databases.oracle.server comp.databases.oracle.server


Discuss cluster,performance, 6k clients and lobs in the comp.databases.oracle.server forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
hehehe
 
Posts: n/a

Default cluster,performance, 6k clients and lobs - 07-09-2010 , 01:52 AM






Hello!

Wa are trying to create application for archive lots of documents about
15mln(1mb each). We will use oracle 11g database with cluster and
partitioning. There wiill be 3k to 6k parallel clients connection. All
documdnts will be in blob tables. So my question is what kind of servers and
diskk arreys we need to buy to meet the demands and to develop application
in the future? What is very important and what is not ? We weill use redhat
5.x 64bit server. We will create middle tier applications in cluster to. So
maybe someone have similar production app ? Every opinion,info etc will be
very helpfull

regards -MJ

Reply With Quote
  #2  
Old   
Mark D Powell
 
Posts: n/a

Default Re: cluster,performance, 6k clients and lobs - 07-10-2010 , 08:08 AM






On Jul 9, 2:52*am, "hehehe" <antoni... (AT) poczta (DOT) onet.pl> wrote:
Quote:
Hello!

* *Wa are trying to create application for archive lots of documents about
15mln(1mb each). We will use oracle 11g database with cluster and
partitioning. There wiill be 3k to 6k parallel clients connection. All
documdnts will be in blob tables. So my question is what kind of servers and
diskk arreys we need to buy to meet the demands and to develop application
in the future? What is very important and what is not ? We weill use redhat
5.x 64bit server. We will create middle tier applications in cluster to. So
maybe someone have similar production app ? Every opinion,info etc will be
very helpfull

regards -MJ
MJ, your description is a little unclear but what you want to do is
estimate how many IO per second you need to handle and then spec the
hardware especially the disk farm to be able to handle the load. The
number of concurrent sessions is very important for determining the
server specifications: number cpu and memory.

Being that I work for HP I will recommend that you look over our
offerings. If you want Intel base X86 processors we have the DL380
line which is pretty good and we also have Itanium based product. We
also offer storage solutions and network switches. We can provide the
complete package which can make our solutions very cost effective.
Just visit our web site.

But to get truely useful sizing help you need to determine your IO
requirements and concurrent user load. You will also need your total
storage requirements. With this you can make informed decisions.
Without decent estimates you might as well just buy as much hardware
as you can afford. Once you have this information you can contact
various vendors and ask them to submit bids with appropriate equipment
to meet your performance specifications.

HTH -- Mark D Powell --

Reply With Quote
  #3  
Old   
Eric Stahl
 
Posts: n/a

Default Re: cluster,performance, 6k clients and lobs - 07-10-2010 , 04:12 PM



On Sat, 10 Jul 2010 06:08:55 -0700 (PDT), Mark D Powell
<Mark.Powell2 (AT) hp (DOT) com> wrote:

Quote:
On Jul 9, 2:52*am, "hehehe" <antoni... (AT) poczta (DOT) onet.pl> wrote:
Hello!

* *Wa are trying to create application for archive lots of documents about
15mln(1mb each). We will use oracle 11g database with cluster and
partitioning. There wiill be 3k to 6k parallel clients connection. All
documdnts will be in blob tables. So my question is what kind of servers and
diskk arreys we need to buy to meet the demands and to develop application
in the future? What is very important and what is not ? We weill use redhat
5.x 64bit server. We will create middle tier applications in cluster to. So
maybe someone have similar production app ? Every opinion,info etc will be
very helpfull

regards -MJ

MJ, your description is a little unclear but what you want to do is
estimate how many IO per second you need to handle and then spec the
hardware especially the disk farm to be able to handle the load. The
number of concurrent sessions is very important for determining the
server specifications: number cpu and memory.

Being that I work for HP I will recommend that you look over our
offerings. If you want Intel base X86 processors we have the DL380
line which is pretty good and we also have Itanium based product. We
also offer storage solutions and network switches. We can provide the
complete package which can make our solutions very cost effective.
Just visit our web site.

But to get truely useful sizing help you need to determine your IO
requirements and concurrent user load. You will also need your total
storage requirements. With this you can make informed decisions.
Without decent estimates you might as well just buy as much hardware
as you can afford. Once you have this information you can contact
various vendors and ask them to submit bids with appropriate equipment
to meet your performance specifications.

HTH -- Mark D Powell --



MJ,

I too work for HP (on a large records management project), so I won't
mention any more about the HP product line :-) but will agree that
Mark has provided the correct response i.e. you need, among other
things (like a business plan), a detailed requirements analysis.

It sounds like you've picked a database and an OS, plan to write an
in-house app, and know how many users there will be, along with a
very rough and initial storage estimate.

Here's a basic condieration - how will you be recording, documenting,
and communicating your design process? How will you be presenting this
as a business proposal? You have a long way to go - and once under
way, how do you plan to identify and measure milestones?

It's important that you quantify the specifics of the [concurrent or
otherwise] projected load, testing/researching towards identifying
your resource requirements - and to perform ongoing testing (for a
range of things) throughout your development and deployment. Along the
lines of simple storage requirements, what about projected growth
and retention?

Add in your uptime, failover, available facilities, etc requirements.
Realize that downtime is necessary, and can be expensive to minimize.

Factor in ongoing maintenance and upgrade requirements etc.

Spend some time considering any third-party multivendor
software/firmware/driver etc requirements.

Will you have separate development, test, and production environments?
How would those environments be isolated and managed? Think about
development life cycles, revision control, and change management.

Consider virtualization and how it might help to add agility and elbow
room to your infrastructure.

Think about application/web load balancing, IO mulitpathing from
server to storage, differing performance levels of storage being used
for in specific places for specific needs.

How about backups, and offsite storage? Start thinking about disaster
recovery.

Early on, design your network - don't just think about servers and
disks. Plan for security, firewalls etc. How and when will you need to
move files around for daily app and admin operations - and how will
that be facilitated, managed, and controlled? How and under what
conditions wll developers and users access the systems, using what
tools and applications?

Consider the existing skill sets of your organization and where you
may need external technical support/consulting. There are companies,
who shall remain nameless :-) who design, implement, and maintain
these types of systems for a living.

From there, it's a business decision$

Happy Trails,
Eric Stahl

Reply With Quote
  #4  
Old   
Mladen Gogala
 
Posts: n/a

Default Re: cluster,performance, 6k clients and lobs - 07-11-2010 , 01:11 AM



On Fri, 09 Jul 2010 08:52:49 +0200, hehehe wrote:

Quote:
So my question is what kind of servers and diskk arreys we need to buy
to meet the demands and to develop application in the future?
Try buying the adequate equipment.



--
http://mgogala.byethost5.com

Reply With Quote
  #5  
Old   
Noons
 
Posts: n/a

Default Re: cluster,performance, 6k clients and lobs - 07-11-2010 , 07:31 AM



Mladen Gogala wrote,on my timestamp of 11/07/2010 4:11 PM:

Quote:
So my question is what kind of servers and diskk arreys we need to buy
to meet the demands and to develop application in the future?

Try buying the adequate equipment.
You mean you're not psychic?
Tsktsk, Mladen: I'm disappointed!
))

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.