questions on scalability

Dear group,

we are currently building a database cluster with Oracle 10g on two Primepower 250 machines. Our goal is to start with small hardware equipment, because of the costs, but to be able to upgrade the equipment and make it stronger, as the load becomes stronger.

Currently we have two main questions concerning this long-term issue:

1. Measurement of load

How can we define the load with respect to hardware requirements? Or: Which hardware is required to serve a specific load and how is this load defined, e. g. number of users, connections and so on?

2) Scaling up

How can we ensure that the hardware equipment is always capable to meet the requirements? How should we upgrade the hardware? And the most important thing: What can we do when the PP 250 machine is at its maximum upgradable limit?

I would like to hear from people that are in a similar situation, or just talk about these things.

Regards,
Magnus Received on Fri Apr 14 2006 - 01:00:18 CDT