Skip to content

Commit d4df2bc

Browse files
author
Liudmila Mantrova
committed
DOC: improved major node documentation
1 parent 53a6668 commit d4df2bc

File tree

1 file changed

+34
-17
lines changed

1 file changed

+34
-17
lines changed

doc/src/sgml/multimaster.sgml

Lines changed: 34 additions & 17 deletions
Original file line numberDiff line numberDiff line change
@@ -705,21 +705,11 @@ a new winner can be chosen in case of another network failure.
705705
in a two-node cluster configuration, or to quickly restore a
706706
single node in a broken cluster.
707707
</para>
708-
<important>
709-
<para>
710-
If your cluster has more than two nodes, promoting one of the
711-
nodes to the major status can lead to split-brain problems
712-
in case of network failures, and reduce the number of possible
713-
failover options. Consider
714-
<link linkend="setting-up-a-referee">setting up a standalone referee</link>
715-
instead.
716-
</para>
717-
</important>
718708
<para>
719709
To make one of the nodes major, enable the
720710
<literal>multimaster.major_node</literal> parameter on this node:
721711
<programlisting>
722-
ALTER SYSTEM SET multimaster.major_node TO on
712+
ALTER SYSTEM SET multimaster.major_node TO on;
723713
SELECT pg_reload_conf();
724714
</programlisting>
725715
</para>
@@ -730,6 +720,18 @@ SELECT pg_reload_conf();
730720
referee for your cluster, the <varname>major_node</varname>
731721
option is forbidden.
732722
</para>
723+
<important>
724+
<para>
725+
If your cluster has more than two nodes, do not use the major node
726+
setting, as it can lead to split-brain problems
727+
in case of network failures, and reduce the number of possible
728+
failover options. If the major node gets isolated by a network failure
729+
while the majority of nodes are connected to each other, both the major
730+
node and the subset that has a quorum will continue working. Consider
731+
<link linkend="setting-up-a-referee">setting up a standalone referee</link>
732+
instead.
733+
</para>
734+
</important>
733735
</sect4>
734736
</sect3>
735737
</sect2>
@@ -1085,14 +1087,29 @@ pg_ctl -D <replaceable>datadir</replaceable> -l <replaceable>pg.log</replaceable
10851087
</indexterm>
10861088
</term>
10871089
<listitem>
1088-
<para>The node with this flag continues working even if it cannot access the majority of other nodes.
1089-
This may be required to break the symmetry in two-node clusters.
1090+
<para>The node with this flag continues working even if there is no quorum.
1091+
This may be required to break the symmetry in two-node clusters,
1092+
or to quickly restore a single node in a broken cluster.
10901093
</para>
10911094
<important>
1092-
<para>This parameter should be used with caution. This parameter can cause the
1093-
split-brain problem if you use it on clusters with more than two nodes, or set
1094-
it to <literal>true</literal> on more than one node.
1095-
Only one node in the cluster can be the major node.
1095+
<para>This parameter should be used with caution to avoid split-brain
1096+
problems:
1097+
<itemizedlist>
1098+
<listitem>
1099+
<para>
1100+
Do not use the <parameter>major_node</> parameter on clusters with more
1101+
than two nodes. If the major node gets isolated by a network failure
1102+
while the majority of nodes are connected to each other, both the major
1103+
node and the subset that has a quorum will continue working.
1104+
Consider setting up a standalone referee instead.
1105+
</para>
1106+
</listitem>
1107+
<listitem>
1108+
<para>
1109+
Never set more than one major node in the cluster.
1110+
</para>
1111+
</listitem>
1112+
</itemizedlist>
10961113
</para>
10971114
</important>
10981115
</listitem>

0 commit comments

Comments
 (0)