Transaction management during failover

Question

Does any one have configured failover server for OpenERP as an application server and/or PostgreSQL as a database server ?
Is it possible to spread postgres database across more than 1 partition (Raid4 partition) and then set up a failover server so, if the main server crashes in middle of the transaction, then the transaction will complete in the failover server.
Similar case for OpenERP Server, If the openerp server crashes, is there a possibility to setup a failover instance that would immedi

Stephane Wirtel (stw) · Accepted Answer

Since the version 6.1 of OpenERP, the cache is in the database, so you can configure a reverse proxy to serve two openerp servers.
If the first one crashes, you will have the second.
About the database, you can use pgpool2 for the replication and the load-balancing and it manage the fail-over.

Gerelateerde posts	Antwoorden	Weergaven
how to change summernote toolbar language (web_editor) transaction	0 aug. 22	2710
Managing transactions between countries (Multi-currency) transaction	0 mrt. 15	3607
Storing function field upon creation of resource in dependent model transaction	2 mrt. 15	5061
Use libpq target_session_attrs=read-write to connect to postgresql pool postgresql failover	0 jul. 21	3039
Inter company transfer transaction intercompany	1 aug. 20	8565

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!