[Bucardo-general] Automatic Cascading Replication
Greg Sabino Mullane
greg at endpoint.com
Wed Dec 19 02:51:25 UTC 2012
On Tue, Dec 18, 2012 at 03:42:13PM -0800, David E. Wheeler wrote:
> ...“frobisher,” that needs access to the "customers" table.
> Ideally, I would not change the existing MM config between
> the two databases, but just add a new sync that just syncs
> "customers" with both the main databases as sources and
> “frobisher” as a read-only target: `A:source B:source frobisher:target`.
Is customers is already a part of the other A:B MM sync, why not
just have the new sync be: "A:source forbisher:target"
Then do: bucardo update table customers makedelta=A
> We discussed on #bucardo having triggers exit if session_replication_role
> is set to "local", and to set it to that for bulk inserts.
Yeah, but that still means firing that trigger for every single row
on the bulk insert. Not so bulky anymore. :)
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Size: 163 bytes
Desc: not available
More information about the Bucardo-general