Skip to Content
This question has been flagged
postgresqlreadonlyawscontainerodoo
1 Reply
5048 Views
Avatar
Vilas Bhumare

I have odoo setup on AWS fargate containerized and filestore stored in AWS EFS and RDS Aurora PostgreSQL with multi AZ setup and everything is working fine with cluster endpoint of AWS postgresql. there are two endpoints when we use Multi-AZ setup one is Writer which is master and another is Reader. 

For example: 
Writer endpoint: write .cluster-abc.us-east-1.rds.amazonaws.com 
Reader endpoint:  reader..cluster-ro-abc.us-east-1.rds.amazonaws.com

My running odoo containers pointing to writer endpoint and let say the website is erp.abc.com but I want to create another website like report.abc.com and this odoo container should point to my reader endpoint which is a read replica of my master postgresql.


Getting below exception and containers are not coming up. 

ERROR: cannot execute INSERT in a read-only transaction

does anyone have any idea why this exception coming or how to start odoo service with read replica of the database? Odoo Version :13


dFeatured snippet from th

Avatar
Discard
Avatar
Roland Lee
Best Answer

If you are splitting the read/write queries to replicas, you need to guarantee strong data consistency. Else, Odoo will output errors. You may want to try out the Heimdall Proxy on the AWS Marketplace. It was specifically designed for Odoo applications to support 1) Strong consistency and 2) Queries in transactions. The Heimdall Proxy can support:

  • Automated Query caching

  • Read/Write splitting with ACID compliance

  • Connection Pooling

We have seen cache hit rates of over 90% with Odoo applications.

Avatar
Discard
Theis Dræberg

Really? Nice. We need to try it out with our database!

Related Posts Replies Views Activity
Digitalocean issue
postgresql odoo
Avatar
0
Dec 21
1481
2018-11-28 10:40:01,906 9672 CRITICAL ? odoo.service.server: Failed to initialize database `abc`
postgresql odoo
Avatar
Avatar
2
Feb 19
8418
How to access database of Odoo using pgAdmin III Solved
postgresql odoo
Avatar
Avatar
Avatar
Avatar
14
Dec 17
99049
How to get second and fourth saturday of given month in posstgresql ?
postgresql odoo
Avatar
0
Sep 17
1866
how odoo communicates with postgresql technically ?
postgresql odoo
Avatar
0
Mar 15
2451