[Bucardo-general] Can bucardo do this?

[eric machine]

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: josh at endpoint.com
> To: eric.machine at hotmail.com
> CC: bucardo-general at bucardo.org
> 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   josh at endpoint.com   801-987-0252
> End Point Corporation  http://www.endpoint.com

 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20130822/5e71d8bb/attachment.html>