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