[Bucardo-general] Questions regarding synchronization and sequences

[Kevin Behr]

Hello,

I am going to use Bucardo in the near future for multi-master replication of two databases located on two separate Amazon EC2 instances (servers), load balanced with Amazon's Elastic Load Balancing.  In order to save money, my company is going to shut off the load balancing over the weekends.  This means that one of the databases will be inaccessible. Is it possible to configure Bucardo in such a way that a sync will not occur during a given timeframe?

Perhaps the best way to go about it is to write a cronjob that will "bucardo_ctl stop" on Friday night, and "bucardo_ctl start" on Monday morning.  Is this advisable?  What would other people recommend?

Also, I have one other question.  Do table sequences need to be explicitly added to Bucardo?  I ran a basic example consisting of two source tables, each with a sequence.  I did not explicitly add the sequences, and everything seems to be OK.  In what situation would you want to explicitly add them?  The reason that I am asking is because the sequences in my database are controlled by Hibernate.  There is a hibernate_sequence that is used to generate the sequence ID's for every table in the database.  The default Hibernate sequence generator uses a Hi/Lo algorithm, so the numbers can jump around quite a bit.  I just want to make sure that this wouldn't cause any problems with Bucardo.

Thanks!

Kevin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20121008/c227c9cb/attachment.html>