On 10/17/2014 2:35 AM, Jerome Wagner wrote:
Hello,
I am considering (postgres 9.3+) the idea of opening a R/W access into
a clustered application by creating one fdw server from a central
database to each server a cluster.
That would imply opening a port on each server inside the application,
listening for incoming connections from the database and this way all
the servers would become visible with R/W access.
Is that a sound idea or does it look horrible ? Would it be reasonable
to connect in this way to a cluster of 1, 10, 100, 1000 or more servers ?
is there an existing xxxx_fdw wrapper that would look like a good
candidate for such a direct access inside an application ? Then I
would have to implement the protocol corresponding to this xxxx_fdw
inside my application.
is the application running on these 10, 100, 1000 nodes something
resembling a table oriented relational database?
I would suggest instead you look at using a MQ style message queueing
system, with publish-subscribe semantics for your distributed remote
procedure calls. and not from within a database, rather, from your
central control application to your distributed application workers...
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
