Odoo Server (MOVED TO GITHUB)

Clustering deployment for OpenERP

Asked by OpenBMS JSC

I'm wondering if there are documentation regarding deploying OpenERP in a High Availability environment.I imagine that it depends on: HA for PostgreSQL and HA for OpenERP server. The first part is out of scope for OpenERP, but how about the 2nd area?

BTW, is there any plan to have OpenERP runs on Oracle (given that PostgreSQL is 99% SQL compatible with Oracle PL/SQL), just in case that a client is already having Oracle and he/she doesn't want to have PostgreSQL support contract.

Thanks.

Question information

Language:
English Edit question
Status:
Answered
For:
Odoo Server (MOVED TO GITHUB) Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Numérigraphe (numerigraphe) said : 		#1

OpenERP is 3 tiers : database + server + client (app or web server).
AFAIK you can cluster the server by just multiplying the machines (the protocols are stateless). Failover and load balancing should be easy (I didn't test it, mind you). There used to be small problems with the schedulers but nothing that can't be fixed I suppose.
You can also multiply the web clients for failover, but load balancing must be a bit tricky, being stateful sessions.

OpenERP doesn't support other DBMS because:
- no one really cares enough to pay to make it work and support it
- there was an initiative at OpenERP SA's, but AFAIK it used the wrong approach and failed.

Lionel.

Revision history for this message
OpenBMS JSC (openbmsjsc) said : 		#2

Thank you for the input. It seems that the main issues for clustering solution might be at the web-client

Can you help with this problem?

Provide an answer of your own, or ask OpenBMS JSC for more information if necessary.

To post a message you must log in.