Thanks Jacques,
Some links are precious :)
Le 07/05/2015 09:13, Jacques Le Roux a écrit :
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
