In the same situation we (when I worked with ilscipio) used pgPool-II, there
are other similar solutions
https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling
But I guess you were aware so why did you went this way? It would indeed be
interesting to know more about it!
Note that now also exists http://www.postgres-xl.org/
http://www.translattice.com/postgres_compare.shtml
With the new Json support Postgres now competes with noSql DBMs as long as there are not too much change
http://www.infoq.com/news/2015/04/Postgresql-JSON-Datastore , excerpt:
<<Is PostgreSQL going to be your next JSON database? It seems that, what PostgreSQL is good at, is storing the JSON document and retrieving it
quickly. What it isn’t still good at, is updating the JSON document in place. If your dataset is in JSON and mutable, then maybe one is better using a
dedicated JSON data store instead of PostgreSQL. If not, then PostgreSQL may be the best choice as it can combine both relational and non-relational
workloads at the same time.>>
This will hopefully quickly improve...
HTH
Jacques
Le 06/05/2015 21:32, Nicolas Malin a écrit :
Hello,
For a customer site I deployed an OFBiz instance connected with a readonly
postgres database (replicated slave).
To realize it, I created a new DAO implementation with only authorize the find and with some little entity engine configuration (disable eeca), this
work pretty fine.
Do you realized an equivalent OFBiz deployment on read only database ? and How did you do ? I will appreciate some other feedback to check If my
improvement toke the good ways and if it's interesting to contribute it on the project (code and wiki ;) ).
Nicolas
