[Bucardo-general] Confused about multi-master configuration

Andrey Solovjov solovjov at mcn.ru
Fri May 11 13:43:56 UTC 2012


Hello
I am trying to test Bucardo 5 in multi-master mode (latest git version 
4.99.4).
I have main node (db called "master") and additional node (db called 
"ast1") on different server.
I have two tables sipdevices and sipregs.
sipdevices has only only one source on main node
sipregs can be updated from any node.
sipregs also has contraint "name_constr" FOREIGN KEY (name) REFERENCES 
sipdevices(name) MATCH FULL ON DELETE CASCADE
but this contraint shouldn't be a problem
So I setup sipregs replication as master-master by adding sync where 
"master" and "ast1" are both sources.
I have the following configuration:

-- dbgroups:
Database group: sipdevices_ast1_repl  Members: ast1:target master:source
Database group: sipregs_repl          Members: ast1:source master:source
-- databases:
Database: ast1    Status: active  Conn: psql -p 5432 -U bucardo -d 
voipdb_ast1 -h 10.42.0.82
Database: master  Status: active  Conn: psql -p 5432 -U bucardo -d voipdb
-- herds:
Herd: sipdevices_herd  DB: master  Members: public.sipdevices
   Used in syncs: sipdevices_ast1_repl
Herd: sipregs_herd     DB: master  Members: public.sipregs
   Used in syncs: sipregs_repl
-- syncs:
Sync: sipdevices_ast1_repl  Herd: sipdevices_herd [Active]
   DB group sipdevices_ast1_repl: ast1 (target) master (source)
Sync: sipregs_repl          Herd: sipregs_herd    [Active]
   DB group sipregs_repl: ast1 (source) master (source)
-- tables:
1. Table: public.sipdevices  DB: master  PK: id (int4)  Syncs: 
sipdevices_ast1_repl
3. Table: public.sipregs     DB: master  PK: id (int4)  Syncs: sipregs_repl
-- sequences:
Sequence: public.sipdevices_id_seq  DB: master
Sequence: public.sipregs_id_seq     DB: master
----------------------------------------------------------------

master -> ast1 replication works as expected
I try to UPDATE table sipregs on ast1 and this update is not replicated 
to master (there is also nothing in logs).
I see Bucardo has successfully added all triggers for tables sipregs on 
ast1 and if I kick sipregs_repl sync manually the update is replicated.
I am confused maybe bucardo should be installed on second server?
Or what else should I pay attention to?

Best regards, Andrew.




More information about the Bucardo-general mailing list