[Bucardo-general] Master-master HA replication

[Greg Sabino Mullane]

On Wed, Sep 04, 2013 at 11:50:07AM +0200, Petr Tvaroha wrote:
> The maximum goal is to set up master-master replication when the clients
> (receptionists) could use www.master1.com or www.master2.com independently.
> They'd use master1 as default and if it's not accessible, they'd start
> using master2 (or vise versa). Hope my intention is clear.

Yes, this is a typical master-master setup.

> 1) In order to achieve my goal I would have to install Bucardo on both
> servers and on both servers set up as master-slave (the local server would
> be master and the remote one would be slave)? Or is it better to set it up
> as master-master on both sides?

You install Bucardo itself in one place. Bucardo requires a database, as 
well as some place to actually run the program from. It could be on either 
of the existing servers, or on a separate one entirely. Yes, you want 
master-master.

> 2) The only condition to avoid errors from replication would be to change
> the db design a bit - to treat autoincremental fields (even on master1, odd
> on master 2). Or is there any other catch I should be aware of?

That's pretty much it. And don't replicate those sequences.

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20130904/87c4f5d9/attachment.sig>