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#GuideClusteringHelmaAt 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
_______________________________________________
Helma-user mailing list
Helma-user@...
http://helma.org/mailman/listinfo/helma-user
