[Bucardo-general] bucardo cascade replication.

[Alexander Bakuntsev]

Hi Greg,

 

Is this possible to make cascaded replication with bucardo 5.3?

 

Here is my current set:

bucardo list db

Database: MM     Status: active  Conn: psql -p 5432 -U bucardo -d flt_v4 -h
192.168.5.60

Database: PM2    Status: active  Conn: psql -p 5432 -U bucardo -d flt_v4 -h
192.168.5.69

Database: PM3    Status: active  Conn: psql -p 5432 -U bucardo -d flt_v4 -h
192.168.5.214

Database: SL1_1  Status: active  Conn: psql -p 5432 -U bucardo -d flt_v4 -h
192.168.5.217

Database: SL2_1  Status: active  Conn: psql -p 5432 -U bucardo -d flt_v4 -h
192.168.5.218

 

bucardo list herd

Relgroup: H1  DB: MM  Members: public.clients

  Used in syncs: BR1, BR2, core

 

Bucardo list dbgroups

dbgroup: branch1  Members: PM2:source SL1_1:target

dbgroup: branch2  Members: PM3:source SL2_1:target

dbgroup: masters  Members: MM:source PM2:source PM3:source

 

bucardo list sync

Sync "BR1"   Relgroup "H1"  DB group "branch1" PM2:source SL1_1:target
[Active]

Sync "BR2"   Relgroup "H1"  DB group "branch2" PM3:source SL2_1:target
[Active]

Sync "core"  Relgroup "H1"  DB group "masters" MM:source PM2:source
PM3:source  [Active]

 

My goal is to decrease load on the master server (MM), because of huge
number of potential slave servers (SL1_1 and SL2_1 in this example).
Database group "masters" is under master<->master replication and I don't
have a problems with replication in this configuration. But:

SL1_1 receive an updates IF only data change on PM2 server happened

SL2_1 receive an updates IF only data change on PM3 server happened

Neither SL1_1 or SL2_1 do not receive updates if changes happened on MM.

The same time MM<->PM2<->PM3 servers are getting updates well no matter
where change happened.

 

Is that possible to work around my situation and find a way how make slaves
replicated correctly.

 

 

Best regards,

Alexander

 

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