<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="group-replication-functions-for-maximum-consensus">
      </a>
      14.18.1.3 Functions to Inspect and Configure the Maximum Consensus Instances of a
Group
     </h4>
    </div>
   </div>
  </div>
  <p>
   The following functions enable you to inspect and configure
          the maximum number of consensus instances that a group can
          execute in parallel.
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a name="function_group-replication-get-write-concurrency">
      </a>
      <a class="link" href="group-replication-functions-for-maximum-consensus.html#function_group-replication-get-write-concurrency">
       <code class="literal">
        group_replication_get_write_concurrency()
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045193840688">
     </a>
     <a class="indexterm" name="idm46045193839584">
     </a>
     <p>
      Check the maximum number of consensus instances that a
              group can execute in parallel.
     </p>
     <p>
      Syntax:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-clike"><div class="docs-select-all right" id="sa47727355"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-clike">INT <span class="token function">group_replication_get_write_concurrency</span><span class="token punctuation">(</span><span class="token punctuation">)</span></code></pre>
     </div>
     <p>
      This function has no parameters.
     </p>
     <p>
      Return value:
     </p>
     <p>
      The maximum number of consensus instances currently set
              for the group.
     </p>
     <p>
      Example:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-sql"><div class="docs-select-all right" id="sa77872663"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token keyword">SELECT</span> group_replication_get_write_concurrency<span class="token punctuation">(</span><span class="token punctuation">)</span></code></pre>
     </div>
     <p>
      For more information, see
      <a class="xref" href="group-replication-group-write-consensus.html" title="20.5.1.3 Using Group Replication Group Write Consensus">
       Section 20.5.1.3, “Using Group Replication Group Write Consensus”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="function_group-replication-set-write-concurrency">
      </a>
      <a class="link" href="group-replication-functions-for-maximum-consensus.html#function_group-replication-set-write-concurrency">
       <code class="literal">
        group_replication_set_write_concurrency()
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045193829392">
     </a>
     <a class="indexterm" name="idm46045193828288">
     </a>
     <p>
      Configures the maximum number of consensus instances that
              a group can execute in parallel. The
      <a class="link" href="privileges-provided.html#priv_group-replication-admin">
       <code class="literal">
        GROUP_REPLICATION_ADMIN
       </code>
      </a>
      privilege is required to use this function.
     </p>
     <p>
      Syntax:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-clike"><div class="docs-select-all right" id="sa26475990"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-clike">STRING <span class="token function">group_replication_set_write_concurrency</span><span class="token punctuation">(</span><em class="replaceable">instances</em><span class="token punctuation">)</span></code></pre>
     </div>
     <p>
      Arguments:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         <em class="replaceable">
          <code>
           members
          </code>
         </em>
         : Sets the maximum
                  number of consensus instances that a group can execute
                  in parallel. Default value is 10, valid values are
                  integers in the range of 10 to 200.
        </p>
       </li>
      </ul>
     </div>
     <p>
      Return value:
     </p>
     <p>
      Any resulting error as a string.
     </p>
     <p>
      Example:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-sql"><div class="docs-select-all right" id="sa38612973"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token keyword">SELECT</span> group_replication_set_write_concurrency<span class="token punctuation">(</span><em class="replaceable">instances</em><span class="token punctuation">)</span><span class="token punctuation">;</span></code></pre>
     </div>
     <p>
      For more information, see
      <a class="xref" href="group-replication-group-write-consensus.html" title="20.5.1.3 Using Group Replication Group Write Consensus">
       Section 20.5.1.3, “Using Group Replication Group Write Consensus”
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
