Re: Mutli-database vs. multi-schema for Shared-Web-Hosting ?

In article <8tdc9u$oho$1_at_nnrp1.deja.com>,   nm1638_at_my-deja.com wrote:
> Anyone have experience setting up a Oracle server
> for Shared-Web-Hosting in an ISP ?
>
> Is there any traps and pitfalls we can avoid.
> Should we set it up mutliple databases (one
> database for each customers) ? Or should we set
> it up as one database with multiple schemas (each
> customer have one schema) ?
>
> My company is planning to offer Share-Web-Hosting
> services to our customers. Our customer can put
> their web site on our web servers and their web
> site can read and write to an Oracle server as
> well.
>
> The number of customer we have probably affect
> the answer to the above questions.
> If we are haveing 50 customers what is the best
> approach.
> Or if we have 200 customers, what is the best
> approach.
>
> Thanks,
> Nelson Mak
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

I agree to this disagree with Howard on this one. Somehow it all ends up with available resources. You'r hopefully not planning to run 50 instances from one server, aren't you? That would be clearly outrageous, let alone with 200 users (Are you going to manage 200 database instances? Lucky you) So one way or another, there will be multiple users in a single instance, and that's simply unavoidable. However, Howard is correct, if you assign them all to one tablespace, you'r going to be in trouble. So they should get their own tablespaces. Question: do you think they are going to have the privilege to create their own tablespaces? I for me wouldn't do that. Just my 2 eurocents as to possible pitfalls, critical sucessfactors and DBA nightmares. Maybe you should just buy the biggest RS6000 or Sun you can get, buy huge disk-arrays, and wait until the system starts to profuse smoke.

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.