[Bucardo-general] Bucardo with multiple databases?

Periko Support pheriko.support at gmail.com
Mon Aug 5 02:16:43 UTC 2019


Hi.

I 'm running bucardo latest under ubuntu14.x, I have some doubts.

I have 2 DB's, this are my steps.

bucardo add database MASTER  dbname=dvdrental
bucardo add database SLAVE  dbname=dvdrental_reportes host=192.168.8.121
bucardo add all tables dbname=MASTER herd=HERD1 --verbose
bucardo add sync SYNC1 dbs=MASTER,SLAVE relgroup=HERD1 pushdelta
bucardo update sync SYNC1 set strict_checking=0

Here everything works no issue, love it.

(7324) [Sun Aug  4 18:58:16 2019] MCP Active syncs: 1
(7324) [Sun Aug  4 18:58:16 2019] MCP Entering main loop
(7328) [Sun Aug  4 18:58:16 2019] VAC New VAC daemon. PID=7328
(7328) [Sun Aug  4 18:58:16 2019] VAC Connected to database "MASTER"
with backend PID of 7330
(7324) [Sun Aug  4 18:58:16 2019] MCP Created VAC 7328
(7331) [Sun Aug  4 18:58:16 2019] CTL New controller for sync "SYNC1".
Relgroup is "HERD1", dbs is "SYNC1". PID=7331
(7331) [Sun Aug  4 18:58:16 2019] CTL   stayalive: 1 checksecs: 0 kicked: 1
(7331) [Sun Aug  4 18:58:16 2019] CTL   kidsalive: 1 onetimecopy: 0
lifetimesecs: 0 (NULL) maxkicks: 0
(7324) [Sun Aug  4 18:58:16 2019] MCP Created controller 7331 for sync
"SYNC1". Kick is 1
(7331) [Sun Aug  4 18:58:16 2019] CTL Database "MASTER" backend PID: 7333
(7331) [Sun Aug  4 18:58:16 2019] CTL Database "SLAVE" backend PID: 3902
(7334) [Sun Aug  4 18:58:16 2019] KID (SYNC1) New kid, sync "SYNC1"
alive=1 Parent=7331 PID=7334 kicked=1

root at server1:/var/lib/postgresql# bucardo status
PID of Bucardo MCP: 7324
 Name    State    Last good    Time    Last I/D    Last bad    Time
=======+========+============+=======+===========+===========+=======
 SYNC1 | Good   | 18:58:16   | 24s   | 0/0       | none      |

Now, let see what happen went I try to add the 2nd database:

bucardo add database MASTER1  dbname=ejemplo
bucardo add database SLAVE1  dbname=ejemplo_reportes host=192.168.8.121
===here is my issue
bucardo add all tables dbname=MASTER1 herd=HERD2 --verbose
root at server1:/var/log/bucardo# bucardo add all tables dbname=MASTER1
herd=HERD2 --verbose
Creating relgroup: HERD2
Added table public.inventory to relgroup HERD2
Added table public.actor to relgroup HERD2
Added table public.address to relgroup HERD2
Added table public.category to relgroup HERD2
Added table public.city to relgroup HERD2
Added table public.country to relgroup HERD2
Added table public.customer to relgroup HERD2
Added table public.film to relgroup HERD2
Added table public.film_actor to relgroup HERD2
Added table public.film_category to relgroup HERD2
Added table public.language to relgroup HERD2
Added table public.payment to relgroup HERD2
Added table public.rental to relgroup HERD2
Added table public.staff to relgroup HERD2
Added table public.store to relgroup HERD2
New tables added: 0
Already added: 15

Bucardo again is adding the tables from first database.

How I can sync multiple databases?

The next cause errors, I cannot run the next steps.

bucardo add sync SYNC2 dbs=MASTER1,SLAVE1 relgroup=HERD2 pushdelta
bucardo update sync SYNC2 set strict_checking=0

I was thinking that each DB must have is own herd and sync?

I want to understand bucardo.

Question 1: I need to stop bucardo to add another database to sync?

Any help I will appreciated, thanks!!!


More information about the Bucardo-general mailing list