答复: Horizontally scaling a database

you can also use shareplex / Streams to implement it ..

but has a little diff with your aim , it is not open source database. It's so expensive.

-----邮件原件-----

发件人: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 代 表 Sandeep Dubey
发送时间: 2007年3月15日 23:39
收件人: oracle-l_at_freelists.org
主题: Horizontally scaling a database

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.

Here are the main requirements:

We need to store apporx 300 GB of data a month. It will be OLTP system. We want to use commodity hardware and open source database. we are willing to sacrifice performance for cost. E.g. a single row search from 2 billion rows table should be returned in 2 sec.
Start with one server, when it reaches its capacity add one more server and so on.

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.

I am trying to emulate google type file system with RDBMS capabilities something like a database farm where each database work independently. A query is submitted to all databases in the farm, matching data found and gathered at one place and returned as single output.

Any ideas?

Thanks

Sandeep
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Mar 15 2007 - 21:06:40 CDT