<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h2 class="title">
      <a name="mysql-oci-marketplace-deploy">
      </a>
      34.2 Deploying MySQL EE on Oracle Cloud Infrastructure
     </h2>
    </div>
   </div>
  </div>
  <p>
   To deploy MySQL EE on Oracle Cloud Infrastructure, do the
      following:
  </p>
  <div class="orderedlist">
   <ol class="orderedlist" type="1">
    <li class="listitem">
     <p>
      Open the OCI Marketplace and search for
      <span class="guilabel">
       MySQL
      </span>
      .
     </p>
     <p>
      The
      <span class="guilabel">
       MySQL
      </span>
      listings are displayed.
     </p>
    </li>
    <li class="listitem">
     <p>
      Select
      <span class="guilabel">
       MySQL Enterprise Edition
      </span>
      .
     </p>
     <p>
      The
      <span class="guilabel">
       MySQL Enterprise Edition
      </span>
      overview is displaed.
     </p>
    </li>
    <li class="listitem">
     <p>
      Click
      <span class="guilabel">
       Launch Instance
      </span>
      to begin the
          application launch process.
     </p>
     <p>
      The
      <span class="guilabel">
       Create Compute Instance
      </span>
      dialog is
          displayed.
     </p>
     <p>
      See
      <a class="ulink" href="https://docs.cloud.oracle.com/iaas/Content/Compute/Tasks/launchinginstance.htm" target="_blank">
       To
          create a Linux instance
      </a>
      for information on how to
          complete the fields.
     </p>
    </li>
   </ol>
  </div>
  <p>
   By default, the MySQL server listens on port 3306 and is
      configured with a single user, root.
  </p>
  <div class="important" style="margin-left: 0.5in; margin-right: 0.5in;">
   <div class="admon-title">
    Important
   </div>
   <p>
    When the deployment is complete, and the MySQL server is
        started, you must connect to the compute instance and retrieve
        the default root password which was written to the MySQL log
        file.
   </p>
   <p>
    See
    <a class="xref" href="mysql-oci-marketplace-connecting.html#mysql-oci-marketplace-connecting-ssh" title="Connecting with SSH">
     Connecting with SSH
    </a>
    for
        more information.
   </p>
  </div>
  <p>
   The following MySQL software is installed:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      MySQL Server EE
     </p>
    </li>
    <li class="listitem">
     <p>
      MySQL Enterprise Backup
     </p>
    </li>
    <li class="listitem">
     <p>
      MySQL Shell
     </p>
    </li>
    <li class="listitem">
     <p>
      MySQL Router
     </p>
    </li>
   </ul>
  </div>
  <div class="simplesect">
   <div class="titlepage">
    <div>
     <div class="simple">
      <h3 class="title">
       <a name="idm46045060103392">
       </a>
       MySQL Configuration
      </h3>
     </div>
    </div>
   </div>
   <p>
    For security, the following are enabled:
   </p>
   <div class="itemizedlist">
    <ul class="itemizedlist" style="list-style-type: disc; ">
     <li class="listitem">
      <p>
       SELinux: for more information, see
       <a class="ulink" href="https://docs.oracle.com/en/operating-systems/oracle-linux/7/admin/ol7-s1-syssec.html" target="_blank">
        Configuring
            and Using SELinux
       </a>
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="filename">
        firewalld
       </code>
       : for more information, see
       <a class="ulink" href="https://docs.oracle.com/en/operating-systems/oracle-linux/7/security/ol7-implement-sec.html#ol7-firewalld-cfg" target="_blank">
        Controlling
            the firewalld Firewall Service
       </a>
      </p>
     </li>
    </ul>
   </div>
   <p>
    The following MySQL plugins are enabled:
   </p>
   <div class="itemizedlist">
    <ul class="itemizedlist" style="list-style-type: disc; ">
     <li class="listitem">
      <p>
       <code class="filename">
        thread_pool
       </code>
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="filename">
        validate_password
       </code>
      </p>
     </li>
    </ul>
   </div>
   <p>
    On startup, the following occurs:
   </p>
   <div class="itemizedlist">
    <ul class="itemizedlist" style="list-style-type: disc; ">
     <li class="listitem">
      <p>
       MySQL Server reads
       <code class="filename">
        /etc/my.cnf
       </code>
       and all
            files named
       <code class="filename">
        <em class="replaceable">
         <code>
          *
         </code>
        </em>
        .cnf
       </code>
       in
       <code class="filename">
        /etc/my.cnf.d/
       </code>
       .
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="filename">
        /etc/my.cnf.d/perf-tuning.cnf
       </code>
       is
            created by
       <code class="filename">
        /usr/bin/mkcnf
       </code>
       based on the
            selected OCI shape.
      </p>
      <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
       <div class="admon-title">
        Note
       </div>
       <p>
        To disable this mechanism, remove
        <code class="filename">
         /etc/systemd/system/mysqld.service.d/perf-tuning.conf
        </code>
        .
       </p>
      </div>
      <p>
       Performance tuning is configured for the following shapes:
      </p>
      <div class="itemizedlist">
       <ul class="itemizedlist" style="list-style-type: circle; ">
        <li class="listitem">
         <p>
          VM.Standard2.1
         </p>
        </li>
        <li class="listitem">
         <p>
          VM.Standard2.2
         </p>
        </li>
        <li class="listitem">
         <p>
          VM.Standard2.4
         </p>
        </li>
        <li class="listitem">
         <p>
          VM.Standard2.8
         </p>
        </li>
        <li class="listitem">
         <p>
          VM.Standard2.16
         </p>
        </li>
        <li class="listitem">
         <p>
          VM.Standard2.24
         </p>
        </li>
        <li class="listitem">
         <p>
          VM.Standard.E2.1
         </p>
        </li>
        <li class="listitem">
         <p>
          VM.Standard.E2.2
         </p>
        </li>
        <li class="listitem">
         <p>
          VM.Standard.E2.4
         </p>
        </li>
        <li class="listitem">
         <p>
          VM.Standard.E2.8
         </p>
        </li>
        <li class="listitem">
         <p>
          VM.Standard.E3.Flex
         </p>
        </li>
        <li class="listitem">
         <p>
          VM.Standard.E4.Flex
         </p>
        </li>
        <li class="listitem">
         <p>
          BM.Standard2.52
         </p>
        </li>
       </ul>
      </div>
      <div class="important" style="margin-left: 0.5in; margin-right: 0.5in;">
       <div class="admon-title">
        Important
       </div>
       <p>
        For all other shapes, the tuning for VM.Standard2.1 is
              used.
       </p>
      </div>
     </li>
    </ul>
   </div>
  </div>
 </div>
 <br/>
</div>
