X-Git-Url: https://git.8kb.co.uk/?p=slony-i%2Fslony_failover;a=blobdiff_plain;f=slony_failover.conf;h=8ad164a73d72f4b8262964bd2ad893dcea8aea18;hp=f1be52a144a4dd25261d2a98705b8cd289810498;hb=146c773e63a572450722aaa917dc96ced7319f7d;hpb=9f3302219520eae18c8fdf84ea746ff8f6865925 diff --git a/slony_failover.conf b/slony_failover.conf index f1be52a..8ad164a 100644 --- a/slony_failover.conf +++ b/slony_failover.conf @@ -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.