/usr/share/doc/slony1-2-doc/adminguide/stmtfailover.html is in slony1-2-doc 2.2.5-2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 | <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN""http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>SLONIK FAILOVER</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REV="MADE"
HREF="mailto:slony1-general@lists.slony.info"><LINK
REL="HOME"
TITLE="Slony-I 2.2.5 Documentation"
HREF="index.html"><LINK
REL="UP"
TITLE="Configuration and Action commands"
HREF="cmds.html"><LINK
REL="PREVIOUS"
TITLE="SLONIK MOVE SET"
HREF="stmtmoveset.html"><LINK
REL="NEXT"
TITLE="SLONIK EXECUTE SCRIPT"
HREF="stmtddlscript.html"><LINK
REL="STYLESHEET"
TYPE="text/css"
HREF="stylesheet.css"><META
HTTP-EQUIV="Content-Type"
CONTENT="text/html; charset=ISO-8859-1"></HEAD
><BODY
CLASS="REFENTRY"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="5"
ALIGN="center"
VALIGN="bottom"
><SPAN
CLASS="PRODUCTNAME"
>Slony-I</SPAN
> 2.2.5 Documentation</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
HREF="stmtmoveset.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
HREF="stmtmoveset.html"
>Fast Backward</A
></TD
><TD
WIDTH="60%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="top"
><A
HREF="stmtddlscript.html"
>Fast Forward</A
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="top"
><A
HREF="stmtddlscript.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><A
NAME="STMTFAILOVER"
></A
>SLONIK FAILOVER</H1
><DIV
CLASS="REFNAMEDIV"
><A
NAME="AEN7770"
></A
><H2
>Name</H2
>FAILOVER -- Fail a broken replication set over to a backup node
</DIV
><DIV
CLASS="REFSYNOPSISDIV"
><A
NAME="AEN7773"
></A
><H2
>Synopsis</H2
><P
><TT
CLASS="COMMAND"
>FAILOVER (options);</TT
></P
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN7776"
></A
><H2
>Description</H2
><P
> The <TT
CLASS="COMMAND"
>FAILOVER</TT
> command causes the backup node to take over all sets
that currently originate on the failed
node. <SPAN
CLASS="APPLICATION"
>slonik</SPAN
> will contact all other
direct subscribers of the failed node to determine which node has
the highest sync status for each set. If another node has a
higher sync status than the backup node, the replication will
first be redirected so that the backup node replicates against
that other node, before assuming the origin role and allowing
update activity.
</P
><P
> After successful failover, all former direct subscribers of the
failed node become direct subscribers of the backup node. The
failed node is abandoned, and can and should be removed from the
configuration with <A
HREF="stmtdropnode.html"
>SLONIK DROP NODE</A
>.
</P
><P
> If multiple set origin nodes have failed, then you should tell FAILOVER
about all of them in one request. This is done by passing a list like
<TT
CLASS="LITERAL"
>NODE=(ID=val,BACKUP NODE=val), NODE=(ID=val2, BACKUP NODE=val2)</TT
> to FAILOVER.
</P
><P
> Nodes that are forwarding providers can also be passed to the failover command as a failed
node. The failover process will redirect the subscriptions from these nodes to the backup node.
</P
><P
></P
><DIV
CLASS="VARIABLELIST"
><DL
><DT
><TT
CLASS="LITERAL"
> ID = ival </TT
></DT
><DD
><P
> ID of the failed node</P
></DD
><DT
><TT
CLASS="LITERAL"
> BACKUP NODE = ival </TT
></DT
><DD
><P
> Node ID of the node that will take over all
sets originating on the failed node</P
></DD
></DL
></DIV
><P
> This uses <A
HREF="function.failednode-p-failed-nodes-integer-p-backup-node-integer-p-failed-node-integerarray.html"
>schemadocfailednode(p_failed_nodes integer, p_backup_node integer, p_failed_node integer[])</A
>. </P
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN7799"
></A
><H2
>Example</H2
><PRE
CLASS="PROGRAMLISTING"
>FAILOVER (
ID = 1,
BACKUP NODE = 2
);
#example of multiple nodes
FAILOVER(
NODE=(ID=1, BACKUP NODE=2),
NODE=(ID=3, BACKUP NODE=4)
);
</PRE
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN7802"
></A
><H2
> Locking Behaviour </H2
><P
> Exclusive locks on each replicated table will be taken out
on both the new origin node as replication triggers are changed.
If the new origin was not completely up to date, and replication
data must be drawn from some other node that is more up to date,
the new origin will not become usable until those updates are
complete. </P
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN7805"
></A
><H2
> Dangerous/Unintuitive Behaviour </H2
><P
> This command will abandon the status of the failed
node. There is no possibility to let the failed node join the
cluster again without rebuilding it from scratch as a slave. If
at all possible, you would likely prefer to use <A
HREF="stmtmoveset.html"
>SLONIK MOVE SET</A
> instead, as that does
<SPAN
CLASS="emphasis"
><I
CLASS="EMPHASIS"
>not</I
></SPAN
> abandon the failed node.
</P
><P
>If a second failure occours in the middle of a FAILOVER
operation then recovery might be complicated. </P
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN7811"
></A
><H2
> Slonik Event Confirmation Behaviour </H2
><P
>Slonik will submit the FAILOVER_EVENT without waiting
but wait until the most ahead node has received confirmations
of the FAILOVER_EVENT from all nodes before completing.</P
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN7814"
></A
><H2
> Version Information </H2
><P
> This command was introduced in <SPAN
CLASS="PRODUCTNAME"
>Slony-I</SPAN
> 1.0 </P
><P
> In version 2.0, the default <TT
CLASS="ENVAR"
>BACKUP NODE</TT
> value of 1 was removed, so it is mandatory to provide a value for this parameter</P
><P
> In version 2.2 support was added for passing multiple nodes to
a single failover command</P
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="stmtmoveset.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="stmtddlscript.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>SLONIK MOVE SET</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="cmds.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>SLONIK EXECUTE SCRIPT</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>
|