[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