[Bucardo-general] How To Debug Multi-Master Replication?

Jerry Richards jerry.richards at teotech.com
Mon Mar 26 22:09:42 UTC 2012


I got bucardo up and running on two servers for multi-master replication.  I have one sync that includes  a herd of 4 tables, but I am seeing no replication between the two servers.

How do I go about debugging this?  I'm new to bucardo, so I'm not sure where to look?  Perhaps there is a good debug example?

Here's the output from "bucardo_ctl status":
[root@ MultiSrv-C57 bin]# bucardo_ctl status
Days back: 3  User: bucardo  Database: bucardo  PID of Bucardo MCP: 16163
Name                Type  State                          PID   Last_good Time  I/U/D Last_bad Time
===================+=====+==============================+=====+=========+=====+=====+========+====
freeswitch_c57_sync| S   |RUN:54m54s>freeswitch_c57_teo |16254|unknown  |     |     |54m37s  |8s

Here's the output from "bucardo_ctl show all":
[root@ MultiSrv-C57 bin]# bucardo_ctl show all
audit_pid                 = 0
autosync_ddl              = newcol
bucardo_current_version   = 4.4.8
bucardo_version           = 4.4.8
ctl_checkabortedkids_time = 30
ctl_checkonkids_time      = 10
ctl_createkid_time        = 0.5
ctl_nothingfound_sleep    = 0.2
ctl_pingtime              = 600
default_email_from        = nobody at example.com
default_email_host        = localhost
default_email_to          = nobody at example.com
email_debug_file          =
endsync_sleep             = 1.0
host_safety_check         =
kid_abort_limit           = 3
kid_abort_sleep           = 1
kid_nodeltarows_sleep     = 0.8
kid_nothingfound_sleep    = 0.3
kid_pingtime              = 60
kid_serial_sleep          = 10
log_conflict_details      = 0
log_conflict_file         = bucardo_conflict.log
log_showline              = 0
log_showpid               = 0
log_showtime              = 3
max_delete_clause         = 200
max_select_clause         = 500
mcp_dbproblem_sleep       = 15
mcp_loop_sleep            = 0.1
mcp_pingtime              = 60
piddir                    = /var/run/bucardo
reason_file               = bucardo.restart.reason.log
stats_script_url          = http://www.bucardo.org/
stopfile                  = fullstopbucardo
syslog_facility           = LOG_LOCAL1
tcp_keepalives_count      = 0
tcp_keepalives_idle       = 0
tcp_keepalives_interval   = 0
warning_file              = bucardo.warning.log

Thanks,
Jerry
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20120326/b6d33bfa/attachment.html 


More information about the Bucardo-general mailing list