答复: Horizontally scaling a database
- From: "jametong" <jametong@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 16 Mar 2007 10:06:40 +0800
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 代
表 Sandeep Dubey
发送时间: 2007年3月15日 23:39
收件人: oracle-l@xxxxxxxxxxxxx
主题: 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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
