Skip to Content
This question has been flagged
1 Reply
7983 Views
Avatar
Damien DALY

Hi,

I would like to know how  I can do to install databases and Odoo to have servers (db+app) on many sites, replicated, and seen as only one virtual instance. So if a site can loose its connection with others, and sync when connection is up again, or do load-balancing in one site (multiple servers).

Thanks.

Avatar
Discard
Avatar
Jon Knowles
Best Answer

Our setup running odoo 11, we use cloudflare for our load balancing.  We have 3 internet IP addresses that that NAT to 3 nginx reverse proxy servers, which each use nginx ip_hash; to 3 odoo upstreams. The 3 vlans run to 3 different physical ESX servers..   These all connect to a separate physical postgre server ubuntu. which replicates to 3 additional  vPostgre 9.3 vApp, per server. Failover for the postgresql server pops over to the first vPostgre in the event our main DB goes down.

                vPG1                vPG2            vPG3

                                    PGSQL main server


We recently added a VPN to AWS using for offsite database backup.  


SubnetA,B,CSubnetA,B,CSubnetA,B,C

ESX1ESX2ESX3
VLAN1odoo1Aodoo1Bodoo1C
VLAN2odoo2Aodoo2Bodoo2C
VLAN3odoo3Aodoo3Bodoo3C
Avatar
Discard
Akram Malik

Hi Jon,

Greetings!

I know this thread is 4 years old, but I have similar requirements and wanted to ask you a few questions, please let me know if you can help. You can reach out to me on my email, it is akram.malik@dymaxel.com

Looking forward to talk to you soon!