Re: Horizontally scaling a database

Sandeep,

   It sounds like you are describing a "federated database". A quick google search on this term might help you find a lot of information about this technique, RDBMS systems that can support it (actually, if you're willing to do enough work yourself, any RDBMS should be able to), and perhaps most importantly some of the reasons that "federated databases" are not always the marvelous idea they sound like - especially if you plan to use extremely inexpensive components...

On 3/15/07, Sandeep Dubey <dubey.sandeep_at_gmail.com> wrote:
>
> Hi all,
>
> I am looking for ideas how to scale database horizontally as opposed
> to adding more CPUs, memory and disks on a single machine.
>
> ...
>
> Oracle RAC doesn't fit as it is single storage system. MySQL cluster
> database replicates data to all its cluster- we don't want to
> replicate the data.
>
> ...

-- 
Cheers,
-- Mark Brinsmead
   Senior DBA,
   The Pythian Group
   http://www.pythian.com/blogs

--
http://www.freelists.org/webpage/oracle-l