[Bucardo-general] Why bucardo takes to much time to write records in another master server ?

[Juned Khan]

Hi All.

I am trying to setup master master replication using bucardo. i have just
set this up successfully but while testing i came to know that bucardo
takes too long time to write data, and due to this slow process i am
getting  "duplicate key value violates unique constraint" error.

how to fix this error, i mean how to make this process smoother. i have one
script which writes 10 records.

below are the steps.

bucardo_ctl add db node1 host=192.168.1.61
bucardo_ctl add db node2 host=192.168.1.62

bucardo_ctl add all tables db=node1 herd=node1_herd
bucardo_ctl add sync node1_to_node2 type=pushdelta source=node1_herd
targetdb=node2

bucardo_ctl add all tables db=node2 herd=node2_herd
bucardo_ctl add sync node2_to_node1 type=pushdelta source=node2_herd
targetdb=node1

After just executing this script on one system when i am trying to run same
script on another system its giving below errors.

root at juned:~# php psql.php
PHP Warning:  pg_query(): Query failed: ERROR:  duplicate key value
violates unique constraint "ip_map_id_pkey"
DETAIL:  Key (id)=(76) already exists. in /root/psql.php on line 18
PHP Warning:  pg_query(): Query failed: ERROR:  duplicate key value
violates unique constraint "ip_map_id_pkey"
DETAIL:  Key (id)=(77) already exists. in /root/psql.php on line 18
PHP Warning:  pg_query(): Query failed: ERROR:  duplicate key value
violates unique constraint "ip_map_id_pkey"
DETAIL:  Key (id)=(78) already exists. in /root/psql.php on line 18
PHP Warning:  pg_query(): Query failed: ERROR:  duplicate key value
violates unique constraint "ip_map_id_pkey"

But after 2-3 trials it works, it inserts records. that means its taking
much time to write data.

How make this process faster ?


-- 
Thanks,
Juned Khan

<http://www.inextrix.com/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20140507/d3072b12/attachment.html>