@@ -705,21 +705,11 @@ a new winner can be chosen in case of another network failure.
705
705
in a two-node cluster configuration, or to quickly restore a
706
706
single node in a broken cluster.
707
707
</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>
718
708
<para>
719
709
To make one of the nodes major, enable the
720
710
<literal>multimaster.major_node</literal> parameter on this node:
721
711
<programlisting>
722
- ALTER SYSTEM SET multimaster.major_node TO on
712
+ ALTER SYSTEM SET multimaster.major_node TO on;
723
713
SELECT pg_reload_conf();
724
714
</programlisting>
725
715
</para>
@@ -730,6 +720,18 @@ SELECT pg_reload_conf();
730
720
referee for your cluster, the <varname>major_node</varname>
731
721
option is forbidden.
732
722
</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>
733
735
</sect4>
734
736
</sect3>
735
737
</sect2>
@@ -1085,14 +1087,29 @@ pg_ctl -D <replaceable>datadir</replaceable> -l <replaceable>pg.log</replaceable
1085
1087
</indexterm>
1086
1088
</term>
1087
1089
<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.
1090
1093
</para>
1091
1094
<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>
1096
1113
</para>
1097
1114
</important>
1098
1115
</listitem>
0 commit comments