Thanks Josh, that helps. I assume the v5 is this one right? https://github.com/bucardo/bucardo Hopefully it is stable for production use, what do you think? Can bucardo sync 100 - 200 tables? Last question, let's say I have this table HQ_HR ---------- ID | uid | Name 1 | john | susan 2 | john | michelle then in branch BR_HR ---------- ID | uid | Name 1 | Josh | Ally 2 | Josh | Rebecca If I sync one way from BR_HR to HQ_HR, will the expected results like below? HQ_HR ---------- ID | uid | Name 1 | john | susan 2 | john | michelle 1 | Josh | Ally 2 | Josh | Rebecca Note: ID is an auto increment number Wouldn't the above cause conflicts? Or will it be replicated as below? HQ_HR ---------- ID | uid | Name 1 | john | susan 2 | john | michelle 3 | Josh | Ally 4 | Josh | Rebecca Unless this table supports 2 primary keys, then below is possible right? HQ_HR ---------- ID | uid | Name 1 | john | susan 2 | john | michelle 1 | Josh | Ally 2 | Josh | Rebecca Any help? Thanks. > Date: Wed, 21 Aug 2013 14:50:21 -0600 > From: [email protected] > To: [email protected] > CC: [email protected] > Subject: Re: [Bucardo-general] Can bucardo do this? > > On Wed, Aug 21, 2013 at 05:44:55PM +0000, eric machine wrote: > > Is there a v5? I though the latest was v4.99.7? > > My fault -- 4.99.7 is "Bucardo 5 beta", so the version you suggested you'd try > to use is, in fact, "Bucardo 5" such as it exists now. > > > Is it possible when I use bucardo to sync from HQ to Branch, it will > > auto create the missing 10 tables for Branch? > > No, Bucardo won't create new tables for you. You'll need to create the tables > in both databases and tell Bucardo about them if you want them to be > replicated. > > -- > Josh Tolley [email protected] 801-987-0252 > End Point Corporation http://www.endpoint.com
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
