clustering postgresql

Julian Tree <[email protected]> Wed, 18 Jun 2008 19:40:13 -0400
Newsgroups gmane.comp.java.helma.general
Message-ID <[email protected]>
hi,

Is there anyone using postgresql with helma? what is general consensus  
on mysql vs postgresql? We will be using HelmaSwarm.  Should we take  
the primary key sequence generation into consideration?   is there  
there a way to cluster postgresql through jdbc like show here with  
mysql?  Thanks

http://adele.helma.org/download/helma/documentation/documentation.html#GuideClusteringHelma

At the db-node-level the clustering depends of course on the database  
system in use. If you use MySQL, then you can implement a Master/Slave  
setup on the db-side, and have the DB-requests being distributed on  
these instances via the ReplicationDriver that is part of MySQL's  
Connector/J (version 3.1.11 or higher; see  http://dev.mysql.com/doc/mysql/en/cj-replication-connection.html) 
.

### db.properties ###
antville.url      = jdbc:mysql://master,slave1,slave2,slave3/test
antville.driver   = com.mysql.jdbc.ReplicationDriver
antville.user     = user
antville.password = pass
antville.autoReconnect = true
antville.roundRobinLoadBalance = true


Julian