[Pljava-dev] Developing a db-clustering system using PL/Java

From: daniel at winterwell(dot)com (Daniel Winterstein)
To:
Subject: [Pljava-dev] Developing a db-clustering system using PL/Java
Date: 2011-11-03 17:16:29
Message-ID: 4EB2CC6D.8080000@winterwell.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev


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

Responses

Browse pljava-dev by date

  From Date Subject
Next Message Johann 'Myrkraverk' Oskarsson 2011-11-03 17:36:06 [Pljava-dev] Developing a db-clustering system using PL/Java
Previous Message Johann 'Myrkraverk' Oskarsson 2011-11-01 01:22:46 [Pljava-dev] CVS HEAD is now Java 6.