Re: database replication

2017-03-08 Thread Jacques Le Roux
Thanks Paul! Jacques Le 08/03/2017 à 17:49, Paul Mandeltort a écrit : We actually haven’t migrated our live setup yet - we are finishing up a few other projects including getting some docker stuff sorted out to make our IT headaches a lot easier. The outage only affected the S3 service

Re: database replication

2017-03-08 Thread Paul Mandeltort
We actually haven’t migrated our live setup yet - we are finishing up a few other projects including getting some docker stuff sorted out to make our IT headaches a lot easier. The outage only affected the S3 service which is separate from RDS, and as far as I know there was no data loss,

Re: database replication

2017-03-08 Thread Jacques Le Roux
Hi Paul, I just wonder, are you using Amazon RDS in production? And if so how went the last big outage? Thanks Jacques Le 17/01/2017 à 21:42, Paul Mandeltort a écrit : Honestly, probably not. There are several HA Postgres hosts nowadays that are very cost-effective. Amazon RDS is one, for

Re: database replication

2017-01-21 Thread Bahaa Alamood
Dear All, thanks for all the replies, yes, I tested it and it works. I am deploying it now on 2 machines and my set up is like the: server A is a VPS with OpenVPN server (this server has a Public IP) which will be used for all people that are not local to the remote office server B is a VM

Re: database replication

2017-01-21 Thread Jacques Le Roux
Le 21/01/2017 à 08:58, Nicolas Malin a écrit : Hi Bahaa, for your sequence pb like spot jacques and I thhink you already ready the delegator prefix save your pb on all creation || || Le 17/01/2017 à 17:15, Bahaa Alamood a écrit : [...] I have a questions regarding the sync. So i

Re: database replication

2017-01-20 Thread Nicolas Malin
Hi Bahaa, for your sequence pb like spot jacques and I thhink you already ready the delegator prefix save your pb on all creation ||entity-group-reader=||"main"| |entity-eca-reader=||"main"| |||distributed-cache-clear-enabled=||"false"| |sequenced-id-prefix=||"A"||>|

Re: database replication

2017-01-17 Thread Mike
BDR handles this exact scenario. It will be an excellent choice for ofbiz. Most multi master solutions are trigger based. BDR can easily handle the 800 tables that ofbiz has and it doesn't need a table to have a primary key, nor does it use triggers. If two or more masters updates the same

Re: database replication

2017-01-17 Thread Paul Mandeltort
Honestly, probably not. There are several HA Postgres hosts nowadays that are very cost-effective. Amazon RDS is one, for example, and just a few clicks and boom you have a replicated fail-over Postgres instance available to you for practically nothing. Set up good backup scheme and you have a

Re: database replication

2017-01-17 Thread Bahaa Alamood
Hi Paul, Thanks for the advice :), but this is not the point here. The point is having such a solution will provide you with the clustered environment that will make your important business data always stored in more than one machine (I think you know how important that is) We can forget

Re: database replication

2017-01-17 Thread Paul Mandeltort
How expensive would it be to just upgrade the office’s internet connectivity? With my business hat on, that will almost always be MUCH cheaper than investing in a corner case of development that the rest of the community isn’t using anyway. Take a look at the new generation of microwave data

Re: database replication

2017-01-17 Thread Jacques Le Roux
The now removed POS component used a solution for similar cases. This solution still exists and is reliable on a LAN ("less" on Internet) You can find the documentation at https://cwiki.apache.org/confluence/display/OFBIZ/Sync+Setup+Notes+and+Example Disclaimer: it's not very easy to

database replication

2017-01-16 Thread Bahaa Alamood
Hello All, We have a situation that we need to have more than 2 servers of ofbiz running, server A, B, and C. The scenario is like this 1. Server A is the main server and it is online all the time with its own database. some people do connect to that and make changes to the data (create,