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:16:29 +0000
Message-ID: <4EB2CC6D.8080000@winterwell.com> (raw)


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.

Any feedback on the following Qs would be greatly appreciated!
Also, let me know if this project would be of interest to you.

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

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.

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?

Thank you for your time & any advice you have.

Best regards,
  -Daniel

--------------------------------------------
Dr Daniel Winterstein
tel: 0772 5172 612              @winterstein
http://winterwell.com      http://sodash.com
Registered in Scotland, company no. SC342991

view thread (3+ messages)  latest in thread

Message-ID: <4EB2CC6D.8080000@winterwell.com>
Permalink:  ../4EB2CC6D.8080000@winterwell.com/
Also on:    postgresql.org/message-id/4EB2CC6D.8080000@winterwell.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: <4EB2CC6D.8080000@winterwell.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