On Mon, Aug 24, 2015 at 11:55:16AM -0700, Florin Andrei wrote: > I'm running PG in the cloud, currently single instance. I want to > have more than one instance, to improve reliability and > availability. I'd prefer a master/master scheme, to increase > availability of not only the read endpoints, but also the write > endpoints. > > We do bulk uploads almost exclusively - a Python script waking up > once in a while, that dumps more data into the DB. Internal users > may query the DB for data analytics whenever they like. > > Is Bucardo a good fit for this scenario?
It should be. If all the dumps go to a single server, all the better. > What would be some things I would need to pay special attention to > while installing / configuring / running the cluster? All your tables will need to have primary keys or unique indexes. If there is a chance for conflicts, you should think about the best way to handle them. You might want to use the offset-sequence trick [1] as well to help prevent conflicts and for better auditing. [1] Server A does 1,3,5,7,... Server B does 2,4,6,8, etc. -- Greg Sabino Mullane [email protected] End Point Corporation PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
