Thread: Replication DB scenario
Hi, I would like to request some help from the community understanding what would be the best solution for my problem.
Ricardo Oliveira
I have been presented with the following db scenario:
(Using PostgreSQL 9.4)
Customer A has DB A;
Customer B has DB B;
Customer C has DB C;
All the databases should "see" changes between them. For example: DB A should be updated with changes in DB B and DB C, DB B should be updated with changes in DB A and DB C, etc..
All the databases are hosted in windows servers and should be updated as quick as possible. Also the servers are connected via Internet and can at times be disconnected (not accessible).
- What would be my best choices for data replication between these databases? Windows solutions would be preferable but Linux solutions are not excluded.
- What would be your main advice regarding a complex scenario like this? What should I be looking for?
Any help and hints are appreciated.
Thank you in advance,
-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 Ricardo Oliveira wrote: > All the databases should "see" changes between them. For example: DB A > should be updated with changes in DB B and DB C, DB B should be updated > with changes in DB A and DB C, etc.. ... > - What would be my best choices for data replication between these > databases? Windows solutions would be preferable but Linux solutions are > not excluded. Bucardo can handle this. I'm not aware of anything else that can. > - What would be your main advice regarding a complex scenario like this? > What should I be looking for? A different scenario? :) If you want replication to continue while one of the databases is down, that will also add more complexity. You will of course need to arrange so that updates do not conflict, and/or have some tight business logic about how to handle conflicts. For more details, email the Bucardo mailing list at bucardo-general@bucardo.org - -- Greg Sabino Mullane greg@turnstep.com End Point Corporation http://www.endpoint.com/ PGP Key: 0x14964AC8 201507170940 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iEYEAREDAAYFAlWpBjsACgkQvJuQZxSWSsivRwCgh57SzL/ibik3T1+2pXxmTgUI iXsAoLn+eW/OYJ9eEbnfUxX9lWQye3xw =pI7V -----END PGP SIGNATURE-----