X-Git-Url: https://git.8kb.co.uk/?p=slony-i%2Fslony_failover;a=blobdiff_plain;f=slony_failover.conf;h=8ad164a73d72f4b8262964bd2ad893dcea8aea18;hp=177f3656823c1e94350593148a176f4a49916936;hb=146c773e63a572450722aaa917dc96ced7319f7d;hpb=0e9f92c0400fec3285b0d7b40421e09ba001d4c1 diff --git a/slony_failover.conf b/slony_failover.conf index 177f365..8ad164a 100644 --- a/slony_failover.conf +++ b/slony_failover.conf @@ -25,7 +25,7 @@ lockset_method = multiple # Used for MOVE SET pull_aliases_from_comments = false # Try to generate aliases in the # slonik scripts based on comments within - # sl_node/set comments in parentheses + # sl_set and comments in parentheses in sl_node log_line_prefix = [%t PID=%p] # Special values: # %p = process ID @@ -46,7 +46,7 @@ drop_failed_nodes = true # Drop all failed nodes immediately # Database node to read initial Slony-I configuration from #------------------------------------------------------------------------------ slony_database_host = localhost -slony_database_port = 5434 +slony_database_port = 5432 slony_database_name = TEST slony_database_user = slony slony_database_password = # Recommended to leave blank and use .pgpass @@ -87,3 +87,20 @@ autofailover_config_any_node = true # After reading the initial cluster autofailover_poll_interval = 50 # Cluster state poll interval (milliseconds) autofailover_node_retry = 2 # Retries before initiating failover autofailover_sleep_time = 5000 # Interval between retries (milliseconds) +autofailover_perspective_sleep_time = 20000 # Interval between lag reads for failed nodes + # from surviving nodes. If greater than zero + # any observation that nodes have failed is + # checked from surviving nodes perspective by + # checking if lag times are extending. + # This does not guarantee 100% the nodes are down + # but if set to a large enough interval (at least + # sync_interval_timeout) can back up our observation. +autofailover_majority_only = true # Only fail over if the quantity of surviving nodes + # is greater than the quantity of failed nodes. + # Intended to be used to prevent a split-brain scenario + # in conjunction with some other logic to monitor and + # fence off the old origin if it is in the minority. +autofailover_is_quorum = true # If this script is running on a separate host set to + # true to treat it as a quorum server. Effectively + # increments sum of surviving nodes when calculating + # the majority above.