Hi,
thank you for the links
I read through the presentation
and they did not solve the issue for me -- which presenting a e table from multiple
shards as one single table (at least for reads) for ODBC clients.
I also do not think that skypetools do that
they have implemented essentially an API on top of their shards (separate db servers)
that does the table querying. That means that I have to write a separate API for every time
a user decides on a new query.
May be I misunderstood the approaches, but none of them actually figures out how to
utilize the computing power/memory of multiple servers to satisfy requests that spawn across
servers.
I think Oracle supports the ability to at least reference a table in another server, I do not think
PG does that
It is possible that I have to look into the free DB2 server offering (as the free version is exactly meant
to run on underpowered computers)
I just wanted to ask the list first.
thank you
On Tue, 14 Jul 2009 13:04 +0530, "Ransika de Silva" <ransika@xxxxxxxxx> wrote:
Hello,
We were also in search of having a table split across multiple databases but then found out about skypetools and at the same time the following article; http://www.jurriaanpersyn.com/archives/2009/02/12/database-sharding-at-netlog-with-mysql-and-php/, true that it's not done with PG, but the same thing can be done with PG as well.
Assume this will be helpful for you.
Regards,Ransika
On Tue, Jul 14, 2009 at 4:20 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote:
On Mon, Jul 13, 2009 at 11:16 PM, V S P<toreason@xxxxxxxxxxx> wrote:I think that skype's skytools could be used to create such a solution,
> Hello
>
> I am researching how to store the data for easy 'user-driven'
> reporting (where I do not need to develop application for
> every user request).
>
> The data will typically be number ranges and text strings with
> unique Id for each row
>
> I hope there will be a lot of data :-).
>
> So in that anticipation I am looking for a way
> to allow
> SQL/ODBC access to the data
>
> but in a way that each table resides on more than one
> PG server
>
> for example:
>
> table 1 lives in 3 PG instances (I can partition the data by date range)
> table 2 lives in the same 3 instances plus another one (because it's
> bigger)
>
>
> and I would like users to be able to issue SQL from within ODBC that
> joins them.
in particular pl/proxy.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Ransika De Silva
SCMAD 1.0, SCJP 1.4,
BSc.(Hons) Information Systems
-- Vlad P author of C++ ORM http://github.com/vladp/CppOrm/tree/master
-- http://www.fastmail.fm - The professional email service
