[Bucardo-general] Bucardo 5 has arrived!

Alex Balashov abalashov at evaristesys.com
Fri May 13 04:15:54 UTC 2011


Exciting!  I will test tonight!

On 05/13/2011 12:15 AM, Greg Sabino Mullane wrote:

> On Fri, May 13, 2011 at 12:08:49AM -0400, Alex Balashov wrote:
>> On 05/13/2011 12:07 AM, Greg Sabino Mullane wrote:
>>
>>> * Much more efficient than the previous swap sync (2 masters).
>>
>> How much more efficient?  :-)
>
> You tell us! :)
>
> For starters, it doesn't pull back the entire row from the actual
> data table. It also no longer does an update on the other end. The
> new "swap" is really just like the old "pushdelta": grab a list of
> distinct primary keys. Use that to delete rows from the target,
> and then copy them from the source to the target. So the new
> master-master simply does that process
> twice, going both ways (as needed).
>
> I'll post some benchmarks eventually. Super rough and quick testing
> using pgbench shows it takes a cold Bucardo about 30 seconds to
> sort out a five-master configuration with around 1000 rows of
> changes to each one.
>


-- 
Alex Balashov - Principal
Evariste Systems LLC
260 Peachtree Street NW
Suite 2200
Atlanta, GA 30303
Tel: +1-678-954-0670
Fax: +1-404-961-1892
Web: http://www.evaristesys.com/


More information about the Bucardo-general mailing list