Author: plavin
Date: 2007-05-09 17:41:09 +0200 (Wed, 09 May 2007)
New Revision: 6399
Log:
Revert to correct version of installing-es
Modified:
trunk/refman-5.0/installing-es.xml
Modified: trunk/refman-5.0/installing-es.xml
===================================================================
--- trunk/refman-5.0/installing-es.xml 2007-05-09 14:49:06 UTC (rev 6398)
+++ trunk/refman-5.0/installing-es.xml 2007-05-09 15:41:09 UTC (rev 6399)
Changed blocks: 1, Lines Added: 517, Lines Deleted: 61; 19164 bytes
@@ -5,78 +5,534 @@
<!ENTITY % all.entities SYSTEM "all-entities.ent">
%all.entities;
]>
-<section id="how-to-drbd-heartbeat">
+<section id="installing-es">
- <title>MySQL How To: DRBD and Heartbeat</title>
+ <title>Installing MySQL Enterprise</title>
+&es-only;
+ <indexterm>
+ <primary>installing</primary>
+ <secondary>MySQL Enterprise</secondary>
+ </indexterm>
- <section>
- <title>Overview</title>
+ <para>
+ This section contains information about the components, installation
+ and initial configuration requirements for installing MySQL
+ Enterprise.
+ </para>
+
+ <section id="installing-es-overview">
+
+ <title>Overview of MySQL Enterprise Installation</title>
+&es-only;
+
+ <para>
+ To obtain MySQL Enterprise, visit
+ <ulink url=" http://www.mysql.com/products/enterprise/"/>. The
+ platforms that are officially supported for MySQL Enterprise are
+ listed at
+ <ulink url="http://www.mysql.com/support/supportedplatforms.html"/>.
+ </para>
+
+ <para>
+ To install MySQL Enterprise, you should install the main
+ distribution plus the latest available service pack or hot-fix.
+ You only need to install the latest service pack or hot-fix
+ – this will include all updates since the previous main
+ distribution release. For platforms that do not have a MySQL
+ Enterprise Server installer, use the Community Server instructions
+ (see <xref linkend="installing-cs"/>).
+ </para>
+
+ </section>
+
+ <section id="installing-es-disttypes">
+
+ <title>Enterprise Server Distribution Types</title>
+
+ &es-only;
+ <para>
+ Enterprise Server releases will be created for the following
+ packages from the MySQL 5.0 tree:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ <literal>mysql-enterprise</literal>: Released under a
+ commercial license and includes the following storage engines:
+ <literal>MyISAM</literal>, <literal>MEMORY</literal>,
+ <literal>MERGE</literal>, <literal>InnoDB</literal>,
+ <literal>ARCHIVE</literal>,
<literal>BLACKHOLE</literal>,
+ <literal>EXAMPLE</literal>,
<literal>FEDERATED</literal>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>mysql-enterprise-gpl</literal>: Same as
+ <literal>mysql-enterprise</literal>, but released under the
+ GPL.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>mysql-cluster</literal>:
+ <literal>mysql-enterprise</literal> plus MySQL Cluster
+ (<literal>NDB</literal>).
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>mysql-classic</literal>: Released under a commercial
+ license, does not include <literal>InnoDB</literal>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>mysql-community</literal>: Same as
+ <literal>mysql-enterprise-gpl</literal>, but available for the
+ community, and released every 6 months.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <para>
+ To satisfy different user requirements, we provide several
+ servers. <command>mysqld</command> is an optimized server that is
+ a smaller, faster binary. <command>mysqld-debug</command> is
+ compiled with debugging support but is otherwise configured
+ identically to the non-debug server.
+ </para>
+
+ <para>
+ Each of these servers is compiled from the same source
+ distribution, though with different configuration options. All
+ native MySQL clients can connect to servers from either MySQL
+ version.
+ </para>
+
+ </section>
+
+ <section id="installing-es-installer">
+
+ <title>Installing the Enterprise MySQL Server</title>
+ &es-only;
+ <para>
+ Installers for MySQL Enterprise are available for the Windows and
+ Mac OS X. For other platforms, you will need to use the TAR, Zip
+ or native package format (RPM, Solaris PKG) pafiles to perform the
+ installation.
+ </para>
+
+ <section id="installing-es-installer-windows">
+
+ <title>Using the Enterprise MySQL Installer for Windows</title>
+&es-only;
+
+ <remark role="todo">
+ [MC] Add notes on Service Pack/Hot fix installation here,
+ forward link to SP/HF
+ </remark>
+
<para>
- This how-to will cover the setup of DRBD and Heartbeat
- together with MySQL to provide a Highly Available database environement.
+ The Enterprise MySQL Server installer installs the MySQL server
+ and the MySQL Server Configuration Wizard, and enables you to
+ run the configuration wizard to set up and configure your server
+ before use.
</para>
+
<para>
- A few quick notes:
+ To start the installation process:
</para>
+
+ <orderedlist>
+
+ <listitem>
+ <para>
+ Download the
+
<filename>mysql-enterprise<replaceable>VERSION</replaceable>-win32.zip</filename>
+ file and extract the <filename>Setup.exe</filename> file.
+ You should double-click on this file to start the
+ installation process.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ The opening screen provides an overview of what the
+ installer will achieve. Click <guibutton>Next</guibutton> to
+ continue.
+ </para>
+
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="images/mysql-es-win32-fig1.png"
+ format="PNG"/>
+ </imageobject>
+ <textobject>
+ <phrase lang="en">MySQL Enterprise Installer Main Screen
+ (Windows)</phrase>
+ </textobject>
+ </mediaobject>
+ </listitem>
+
+ <listitem>
+ <para>
+ Choose your installation type. The
+ <emphasis
+ role="bold">Typical</emphasis> installation
+ installs the main server and associated components, but does
+ not include the developer libraries. The
+ <emphasis role="bold">Complete</emphasis> installation
+ installs everything. The
+ <emphasis role="bold">Custom</emphasis> installation enables
+ you to select which components are installed. Choose your
+ installation and click <guibutton>Next</guibutton> to
+ continue.
+ </para>
+
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="images/mysql-es-win32-fig2.png"
+ format="PNG"/>
+ </imageobject>
+ <textobject>
+ <phrase lang="en">MySQL Enterprise Installer Setup type
+ (Windows)</phrase>
+ </textobject>
+ </mediaobject>
+ </listitem>
+
+ <listitem>
+ <para>
+ If you have selected the custom installation, you need to
+ choose which components are installed. Click
+ <guibutton>Next</guibutton> to continute.
+ </para>
+
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="images/mysql-es-win32-fig3.png"
+ format="PNG"/>
+ </imageobject>
+ <textobject>
+ <phrase lang="en">MySQL Enterprise Installer Custom
+ Installation (Windows)</phrase>
+ </textobject>
+ </mediaobject>
+ </listitem>
+
+ <listitem>
+ <para>
+ The installation choices you have made will be summarized
+ for you. If you have made a mistake, you can click
+ <guibutton>Back</guibutton> to choose an alternate
+ installation type. If you are ready to continue, choose
+ <guibutton>Install</guibutton>.
+ </para>
+
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="images/mysql-es-win32-fig4.png"
+ format="PNG"/>
+ </imageobject>
+ <textobject>
+ <phrase lang="en">MySQL Enterprise Installer Installation
+ Summary (Windows)</phrase>
+ </textobject>
+ </mediaobject>
+ </listitem>
+
+ <listitem>
+ <para>
+ You can optionally set up your a connection to your
+ MySQL.com account by entering your login details, or you can
+ create a new account, or you can skip the MySQL.com signup.
+ </para>
+
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="images/mysql-es-win32-fig5.png"
+ format="PNG"/>
+ </imageobject>
+ <textobject>
+ <phrase lang="en">MySQL Enterprise Installer MySQL.com
+ Registration (Windows)</phrase>
+ </textobject>
+ </mediaobject>
+ </listitem>
+
+ <listitem>
+ <para>
+ The installation should proceed, installing the components
+ you have selected. Once the installation has completed, you
+ will get the opportunity to start the MySQL Instance
+ Configuration Wizard. Untick the box if you do not want to
+ run the wizard at this time. Click
+ <guibutton>Finish</guibutton> to complete the installation.
+ If you have opted to run the wizard, then it will be started
+ once the installer has completed.
+ </para>
+
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="images/mysql-es-win32-fig6.png"
+ format="PNG"/>
+ </imageobject>
+ <textobject>
+ <phrase lang="en">MySQL Enterprise Installer Completed
+ (Windows)</phrase>
+ </textobject>
+ </mediaobject>
+ </listitem>
+
+ </orderedlist>
+
<para>
- MyISAM is not recommended to be used with DRBD.
- Data managed by a DRBD volume should be stored in InnoDB.
+ If you selected to run the MySQL Configuration Wizard, see
+ <xref
+ linkend="mysql-config-wizard"/>.
</para>
+
+ </section>
+
+ <xi:include href="config-wizard.xml"
xmlns:xi="http://www.w3.org/2001/XInclude"/>
+
+ </section>
+
+ <section id="installing-es-upgrade">
+
+ <title>Upgrading MySQL Enterprise Server</title>
+&es-only;
<para>
- Examples are given for Debian and RedHat. The Debian
- examples also cover Ubuntu. The RedHat examples are
- also valid for CentOS, although references to up2date
- should be replaced by YUM. Users of Gentoo, Slackware or
- SuSE should hopefully be able to make required changes
- for their systems.
+ When upgrading to MySQL Enterprise from Community Server you need
+ only follow the installation process to install and upgrade the
+ packages to the latest version provided by MySQL Enterprise. You
+ will also need to install the latest MySQL Enterprise Service Pack
+ and any outstanding MySQL Hot-fix packs.
+ </para>
+
+ <para>
+ Be aware, however, that you must take into account any of the
+ changes when moving between major releases. You should also check
+ the release notes (see <xref linkend="releasenotes-es"/>) for
+ details on major changes between revisions of MySQL Enterprise
+ Server. For details of changes in other packages in MySQL
+ Enterprise, see <xref linkend="news"/>.
+ </para>
+
+ <para>
+ You should also review the notes and advice contained within
+ <xref
+ linkend="upgrade"/>.
+ </para>
+
+ </section>
+
+<!--
+
+ <remark role="todo">
+ [MC] Commented out because, at the moment, I have nothing to test to
+ identify how it's going to work.
+ Remember to add sample of the filename for each for reference.
+ </remark>
+
+ <section id="installing-es-sphotfix">
+
+ <title>Installing Hot-fixes and Service Packs</title>
+
+ <para>
+ Installing a service pack or hotfix.
</para>
+
+ </section>
+ -->
+
+ <section id="installing-es-uninstall">
+
+ <title>Uninstalling MySQL Enterprise</title>
+&es-only;
<para>
- This is a general How-To. There are many things not covered,
- and this only serves as an introduction to the things
- that are covered. More documentation may be found online,
- and MySQL Professional Services will be perfectly
- happy to help you integrate these technologies in your
- environment, should you desire.
- </para>
-
- <section>
- <title>Conventions</title>
-
- <para>
- <remark>[PL]I don't think we want to follow these conventions.
- </remark>
-
- In the examples in this summary, the following typographical conventions are
used.
-
- # root commands
-
- Code to be executed by the root user will be yellow and be preceded by a #.
-
- $ code to be executed by a normal user
-
- Code to be executed by a normal user will be gray and be preceded by a $.
-
- > code to be executed within MySQL or CPAN
-
- Code to be executed within MySQL or CPAN will be light green and be preceded by
a >.
-
- file contents
-
- Contents of files will be gray.
-
- program output
-
- Output from programs will be distinguished by a dark background and white text.
- </para>
-
-
-
- </section>
-
-
-
+ You can uninstall MySQL Enterprise using the standard tools
+ according to your operating system.
+ </para>
+
+ <note>
+ <para>
+ When uninstalling, any data files created are not removed. You
+ will need to separately remove these files to completely remove
+ MySQL from your system.
+ </para>
+ </note>
+
+ <section id="installing-es-windows-uninstall">
+
+ <title>Uninstalling on Windows</title>
+
+ <para>
+ To uninstall MySQL Enterprise on Windows you should use the
+
+ <application>Add or Remove Programs</application>
+
+ utility located within the Control Panel.
+ </para>
+
+ <mediaobject>
+ <imageobject>
+ <imagedata
+ fileref="images/mysql-esi-win32-uninst.png"
+ format="PNG"/>
+ </imageobject>
+ <textobject>
+ <phrase lang="en">Uninstalling MySQL Enterprise</phrase>
+ </textobject>
+ </mediaobject>
+
+ <para>
+ Packages within MySQL Enterprise must be removed individually.
+ You may also use this option to remove packages that you no
+ longer want or use.
+ </para>
+
+ <para>
+ Any data you created while MySQL Enterprise was installed will
+ not be removed. You will need to separately delete this
+ information.
+ </para>
+
</section>
-
-
+
+ <section id="installing-es-uninstall-linux-rpm">
+
+ <title>Uninstalling on Linux (RPMs)</title>
+
+ <para>
+ To uninstall MySQL Enterprise on a Linux operating system that
+ uses the RPM package format, you must remove each of the
+ packages that were installed by the MySQL Enterprise Installer
+ individually.
+ </para>
+
+ <para>
+ To do this, first obtain a list of the installed packages:
+ </para>
+
+<programlisting>shell> rpm -q -a|grep -i mysql
+mysql-docs-en-5.0.26-1
+MySQL-server-standard-5.0.26-0.rhel4
+mysql-connector-j-5.0.3-1
+MySQL-devel-standard-5.0.26-0.rhel4
+mysql-query-browser-5.0r4-1rhel4
+mysql-connector-odbc-3.51.12-1
+MySQL-client-standard-5.0.26-0.rhel4
+mysql-administrator-5.0r4-1rhel4
+mysql-gui-tools-5.0r4-1rhel4
+mysql-setup-wizard-1.0-1
+mysql-connector-net-1.0.7-1
+</programlisting>
+
+ <para>
+ You can remove these packages individually, or all together
+ automatically, like this:
+ </para>
+
+<programlisting>shell> rpm -q -a|grep -i mysql|xargs rpm
--erase</programlisting>
+
+ </section>
+
+ </section>
+
+ <section id="installing-es-default-config">
+
+ <title>Enterprise Server Default Configuration</title>
+&es-only;
+ <para>
+ The default configuration parameters for Enterprise Server are
+ shown in the following table. For more information on setting
+ parameters for MySQL, see
+ <xref linkend="database-administration"/>.
+ </para>
+
+ <informaltable>
+ <tgroup cols="2">
+ <colspec colwidth="50*"/>
+ <colspec colwidth="50*"/>
+ <tbody>
+ <row>
+ <entry><emphasis
role="bold">Parameter</emphasis></entry>
+ <entry><emphasis role="bold">Default
value</emphasis></entry>
+ </row>
+ <row>
+
<entry><literal>innodb_additional_mem_pool_size</literal></entry>
+ <entry>8MB</entry>
+ </row>
+ <row>
+
<entry><literal>Innodb_buffer_pool_size</literal></entry>
+ <entry>40MB</entry>
+ </row>
+ <row>
+ <entry><literal>innodb_log_buffer_size
</literal></entry>
+ <entry>8MB</entry>
+ </row>
+ <row>
+
<entry><literal>innodb_log_file_size</literal></entry>
+ <entry>50MB</entry>
+ </row>
+ <row>
+ <entry><literal>key_buffer_size</literal></entry>
+ <entry>40MB</entry>
+ </row>
+ <row>
+ <entry><literal>log_slow_queries</literal></entry>
+ <entry>1</entry>
+ </row>
+ <row>
+ <entry><literal>long_query_time </literal></entry>
+ <entry>1</entry>
+ </row>
+ <row>
+ <entry><literal>max_connections </literal></entry>
+ <entry>200</entry>
+ </row>
+ <row>
+
<entry><literal>myisam_sort_buffer_size</literal></entry>
+ <entry>40MB</entry>
+ </row>
+ <row>
+ <entry><literal>query_cache_size</literal></entry>
+ <entry>20MB</entry>
+ </row>
+ <row>
+ <entry><literal>sort_buffer_size</literal></entry>
+ <entry>1MB</entry>
+ </row>
+ <row>
+ <entry><literal>sql_mode</literal></entry>
+ <entry><literal>strict_trans_tables</literal>,
+ <literal>no_zero_in_date</literal>,
+
<literal>no_zero_date</literal>,<literal>error_for_division_by_zero</literal>,
+ <literal>no_auto_create_user</literal>,
+ <literal>real_as_float</literal>,
+ <literal>ignore_space</literal></entry>
+ </row>
+ <row>
+
<entry><literal>table_cache</literal>/<literal>table_open_cache</literal></entry>
+ <entry>512</entry>
+ </row>
+ <row>
+ <entry><literal>thread_cache</literal></entry>
+ <entry>100</entry>
+ </row>
+ </tbody>
+ </tgroup>
+ </informaltable>
+
+ </section>
+
</section>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r6399 - trunk/refman-5.0 | plavin | 9 May |