From: daniel at winterwell.com (Daniel Winterstein)
Date: Thu, 03 Nov 2011 17:16:29 +0000
Subject: [Pljava-dev] Developing a db-clustering system using PL/Java
Message-ID: <4EB2CC6D.8080000@winterwell.com>


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