[Bucardo-general] More Noob Questions
Greg Sabino Mullane
greg at endpoint.com
Wed Oct 3 03:39:30 UTC 2012
> * What is the best practive for handling DDL changes to a database?
Depends on what the change is. For small ones such as indexes,
constraints, and column type changes, nothing needs to be done
at all. For things like adding new columns, adding tables to a
sync, and practically everything else, a restart of the sync is
required (mostly because we cache all the column info at the
start of the sync - while this could be done on the fly, the
overhead is not worth it). The tricky cases come when you mess
with the primary keys of replicated tables, in which case the
best solution is to generally stop writing to the table, finish
replicating, drop the old triggers, remove the table from Bucardo,
re-add it to Bucardo, and run validate_sync.
--
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20121002/998fed72/attachment.sig>
More information about the Bucardo-general
mailing list