Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
I have a huge loads of data into my database because I have a lot of writes onto my DB. I use SQS to be able to send the data to my DB, because there are around 5000 sale.orders on 8 hours with res.partner creations, etc sent by SQS. This means around 85000 creations/updates per 8 hours. Also the UI of OpenERP is active and users send a lot of Financial Reports.
I want to increase the performance of the User Interface because there are a lot of waitings only to server a couple of records. Today, It's a wating Hell.
I think implement Streaming Replication - Hot Standby, will solve my problem because if I separate Read / Write queries sending to 2 servers, Writes on DB will be fast and Reads too.
I want to implement an Streaming Replication on my OpenERP7 because I have a lot of writes (from SQS) on my DB and I want to split Read/Writes into different servers to improve User Interface performance.
For this purpose, I've thinking about:
2 Servers with Streaming Replication - Hot Standby.
Server 1: Only Writes.
Server 2: Only Reads.
So, while the SQS loads the write server, the read server can resolve queries fast and make the UI of OpenERP fast. Also, this should improve a lot Financial Reports performance.
I think this is the correct choice, but I don't find any information about the configuration in OpenERP, or if the queries are split (read/write queries) on the ERP or PostgreSQL.
Currently, I'm using: OpenERP 7, PostgreSQL 9.3, EC2 instance for OpenERP, RDS instance for PostgreSQL, SQS to send info to the BD.
Well, the questions are:
¿Am I making a good choice making replication to fix my problem?
¿Am I making a good choice with this kind of replication to separate read / write queries?
¿Are any guides to configure this Streaming Replication on OpenERP?
¿Queries are redirect on the PostgreSQL server or at ORM level?
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 10/20/16, 5:33 AM|
|Seen: 192 times|
|Last updated: 10/20/16, 5:35 AM|