]> git.8kb.co.uk Git - slony-i/slony_failover/blob - slony_failover.conf
Changes:
[slony-i/slony_failover] / slony_failover.conf
1 #------------------------------------------------------------------------------
2 # General behaviour
3 #------------------------------------------------------------------------------
4 lang = en                                   # Language for script strings
5                                             # currently only en/fr
6
7 prefix_directory = /usr/failovers           # Script working directory
8 separate_working_directory = true           # Creates and appends a separate working
9                                             # directory to the prefix_directory
10                                             # for each script run
11
12 pid_filename = /var/run/slony_failover.pid  # If the pid file name starts with a
13                                             # forward slash then taken as absoloute
14                                             # othewise appended to prefix_directory
15
16 slonik_path = /usr/local/pgsql/bin          # Slonik binary if not in current path
17
18 enable_try_blocks = false                   # Group operations inside try blocks when
19                                             # doing a move set; only works with 'single'
20                                             # lockset_method
21
22 lockset_method = multiple                   # Used for MOVE SET
23                                             # multiple = lock all sets and move together
24                                             # single = lock and move each set at a time
25
26 pull_aliases_from_comments = false          # Try to generate aliases in the
27                                             # slonik scripts based on comments within
28                                             # sl_set and comments in parentheses in sl_node
29
30 log_line_prefix = [%t PID=%p]               # Special values:
31                                             #   %p = process ID
32                                             #   %t = timestamp without milliseconds
33                                             #   %m = timestamp with milliseconds
34
35 failover_offline_subscriber_only = true     # If set to true any subscriber only nodes
36                                             # that are unavailable at the time of failover
37                                             # will also be failed over.  If false any such
38                                             # nodes will be excluded from the preamble and
39                                             # not failed over, however this may be problematic
40                                             # especially in the case where the most up to date
41                                             # node is the unavailable one.
42
43 drop_failed_nodes = true                    # Drop all failed nodes immediately
44
45 #------------------------------------------------------------------------------
46 # Database node to read initial Slony-I configuration from
47 #------------------------------------------------------------------------------
48 slony_database_host = localhost
49 slony_database_port = 5432
50 slony_database_name = TEST
51 slony_database_user = slony
52 slony_database_password =                   # Recommended to leave blank and use .pgpass
53 slony_cluster_name = test_replication
54
55
56 #------------------------------------------------------------------------------
57 # Logging and debugging
58 #------------------------------------------------------------------------------
59 enable_debugging = false
60 log_filename = failover-%Y-%m-%d.log        # If the log file name starts with a 
61                                             # forward slash then taken as absoloute
62                                             # othewise appended to prefix_directory
63                                             # Special values as per strftime spec
64             
65
66 log_to_postgresql = false                   # Save log n a PostgreSQL table (table def in failover_log_database.sql)
67 log_database_host = localhost
68 log_database_port = 5432
69 log_database_name = TEST_FAILOVERS
70 log_database_user = failover_log_user
71 log_database_password =                     # Recommended to leave blank and use .pgpass
72
73 #------------------------------------------------------------------------------
74 # Autofailover
75 #------------------------------------------------------------------------------
76 enable_autofailover = false                 # Rather than interactive mode sit and
77                                             # watch the cluster state for failed
78                                             # origin/forwarding nodes; upon detection
79                                             # trigger automated failover.
80
81 autofailover_forwarding_providers = true    # Also trigger failover on forwarding providers
82
83 autofailover_config_any_node = true         # After reading the initial cluster configuration,
84                                             # subsequent reads of the configuration will
85                                             # use conninfo to read from any node.
86
87 autofailover_poll_interval = 50             # Cluster state poll interval (milliseconds)
88 autofailover_node_retry = 2                 # Retries before initiating failover
89 autofailover_sleep_time = 5000              # Interval between retries (milliseconds)
90 autofailover_perspective_sleep_time = 20000 # Interval between lag reads for failed nodes
91                                             # from surviving nodes. If greater than zero
92                                             # any observation that nodes have failed is
93                                             # checked from surviving nodes perspective by
94                                             # checking if lag times are extending.
95                                             # This does not guarantee 100% the nodes are down
96                                             # but if set to a large enough interval (at least 
97                                             # sync_interval_timeout) can back up our observation.
98 autofailover_majority_only = true           # Only fail over if the quantity of surviving nodes
99                                             # is greater than the quantity of failed nodes.
100                                             # Intended to be used to prevent a split-brain scenario
101                                             # in conjunction with some other logic to monitor and 
102                                             # fence off the old origin if it is in the minority.
103 autofailover_is_quorum = true               # If this script is running on a separate host set to 
104                                             # true to treat it as a quorum server. Effectively 
105                                             # increments sum of surviving nodes when calculating
106                                             # the majority above.