From: jon
Date: November 13 2008 5:15pm
Subject: svn commit - mysqldoc@docsrva: r12460 - trunk/refman-6.0
List-Archive: http://lists.mysql.com/commits/58683
Message-Id: <200811131715.mADHFcQQ020880@docsrva.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Author: jstephens
Date: 2008-11-13 18:15:37 +0100 (Thu, 13 Nov 2008)
New Revision: 12460

Log:

You can't set max_connections=0 (Thanks, Flupps!)



Modified:
   trunk/refman-6.0/replication-solutions.xml


Modified: trunk/refman-6.0/replication-solutions.xml
===================================================================
--- trunk/refman-6.0/replication-solutions.xml	2008-11-13 17:11:20 UTC (rev 12459)
+++ trunk/refman-6.0/replication-solutions.xml	2008-11-13 17:15:37 UTC (rev 12460)
Changed blocks: 3, Lines Added: 12, Lines Deleted: 24; 2626 bytes

@@ -1557,20 +1557,6 @@
                     the one you are using to perform tasks on C relating
                     to the software upgrade.
                   </para>
-
-                  <para>
-                    You can prevent any application clients from
-                    reconnecting to C by executing the following
-                    statement:
-
-<programlisting>
-SET @@GLOBAL.MAX_CONNECTIONS = 0;
-</programlisting>
-
-                    Once this has been done, only a single client,
-                    having the <literal role="priv">SUPER</literal>
-                    privilege, may connect to C.
-                  </para>
                 </listitem>
 
                 <listitem>

@@ -1760,12 +1746,13 @@
 
             <para>
               Start server C&apos;, insuring that all its tables are in
-              read-only mode, and that no MySQL clients (with the
-              exception of a single connection from a superuser account)
-              can connect to it. You can do this by starting
-              <command>mysqld</command> with the options
-              <option>--read_only --max_connections=0</option>. (For
-              more information about these options, see
+              read-only mode. You can do this by starting
+              <command>mysqld</command> with the
+              <option>--read_only</option> option. Using this option
+              allows only slave threads or clients having the
+              <literal role="priv">SUPER</literal> privilege to perform
+              any updates on the server. (For more information about
+              this option, see
               <xref linkend="server-system-variables"/>.)
             </para>
 

@@ -1949,10 +1936,11 @@
 
             <para>
               This can be done by setting
-              <literal>@@GLOBAL.MAX_CONNECTIONS</literal> to an
-              appropriate value, thereby permitting regular clients not
-              having the <literal role="priv">SUPER</literal> privilege
-              once again to connect.
+              <literal>@@GLOBAL.READ_ONLY</literal> to
+              <literal>0</literal> or <literal>OFF</literal>, thereby
+              permitting regular clients other than those having the
+              <literal role="priv">SUPER</literal> privilege once again
+              to connect.
             </para>
 
           </formalpara>