Has anyone gotten pg-Bouncer or Pg-Pool-II, to work with Odoo? We tried and it did not work. Pooling, failover, read/write splitting will not work with these proxies because:
Odoo requires data consistency
Odoo queries are in transactions
Has anyone tried the Heimdall Database proxy? https://www.heimdalldata.com/odoo
It supports Query Caching, Automated Failover, Read/Write split with ACID compliance. It was designed especially for Odoo. Would love to get your thoughts.
Nope, we even tried to power with https://www.phusionpassenger.com/.
Gonna try yours!