From: johann at 2ndquadrant.com (Johann 'Myrkraverk' Oskarsson) Date: Thu, 03 Nov 2011 17:36:06 +0000 Subject: [Pljava-dev] Developing a db-clustering system using PL/Java In-Reply-To: <4EB2CC6D.8080000@winterwell.com> (Daniel Winterstein's message of "Thu, 03 Nov 2011 17:16:29 +0000") References: <4EB2CC6D.8080000@winterwell.com> Message-ID: Daniel Winterstein 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/