agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] Developing a db-clustering system using PL/Java
Date: Thu, 03 Nov 2011 17:36:06 +0000
Message-ID: <x6ehxp152x.fsf@2ndquadrant.com> (raw)
In-Reply-To: <4EB2CC6D.8080000@winterwell.com>
References: <4EB2CC6D.8080000@winterwell.com>

Daniel Winterstein <daniel at winterwell.com> writes:

> Hello,
>
> I'm considering building a clustering solution for Postgres using
> PL/Java. Before embarking on this ambitious task, I'd like to ask
> your advice.

> 1. What state is PL/Java in and is it actively maintained?

It is actively maintained.  Though slow on development.

> 2. Am I re-inventing the wheel?

> My immediate requirements are to do _partial_ master-master
> replication.  I've checked out several existing solutions such as
> Slony-I, but they seem to offer all-or-nothing replication.

Below, you seem to be describing Londiste.  Have you looked at that
project?

> 3. The architecture I'm considering is to use triggers to maintain a
> table of local edits, with edits then sent across the cluster, using
> embedded Jetty servers to handle the low-level networking via http.
> Do you see any objections to this?

> Is there anything about how PL/Java works that might cause problems?
> Is there a better architecture I should be considering?

There shouldn't be anything in PL/Java that should hamper you.
Compared to Londiste, it seems like a duplication of effort though.

What part of Londiste does not suit your purpose?


-- 
   Johann Oskarsson                http://www.2ndquadrant.com/    |[]
   PostgreSQL Development, 24x7 Support, Training and Services  --+--
                                                                  |
   Blog: http://my.opera.com/myrkraverk/blog/

view thread (3+ messages)  latest in thread

Message-ID: <x6ehxp152x.fsf@2ndquadrant.com>
Permalink:  ../x6ehxp152x.fsf@2ndquadrant.com/
Also on:    postgresql.org/message-id/x6ehxp152x.fsf@2ndquadrant.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] Developing a db-clustering system using PL/Java
  In-Reply-To: <x6ehxp152x.fsf@2ndquadrant.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox