2.3. Installing MySQL Enterprise

2.3.1. Overview of MySQL Enterprise Installation

This section does not apply to MySQL Community Server users.

To obtain MySQL Enterprise, visit http://www.mysql.com/products/enterprise/. The platforms that are officially supported for MySQL Enterprise are listed at http://www.mysql.com/support/supportedplatforms.html.

To install MySQL Enterprise, 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 Enterprise Installer. For platforms that do not yet have an Enterprise Installer, use the Community Server instructions (see Section 2.4, “Installing MySQL Community Server”).

2.3.2. Enterprise Server Distribution Types

This section does not apply to MySQL Community Server users.

Enterprise Server releases will be created for the following packages from the MySQL 5.0 tree:

• mysql-enterprise: Released under a commercial license and includes the following storage engines: MyISAM, MEMORY, MERGE, InnoDB, ARCHIVE, BLACKHOLE, EXAMPLE, FEDERATED.

• mysql-enterprise-gpl: Same as mysql-enterprise, but released under the GPL.

• mysql-cluster: mysql-enterprise plus MySQL Cluster (NDB).

• mysql-classic: Released under a commercial license, does not include InnoDB.

• mysql-community: Same as mysql-enterprise-gpl, but available for the community, and released every 6 months.

Some packages include additional servers that are built with debugging support but are otherwise configured identically to the non-debug servers. Eventually, all packages will include them.

To satisfy different user requirements, we provide several servers. mysqld is an optimized server that is a smaller, faster binary. mysqld-debug is compiled with debugging support.

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.

2.3.3. MySQL Enterprise Contents

This section does not apply to MySQL Community Server users.

MySQL Enterprise consists of the MySQL Enterprise Server and MySQL Network, which contains the Monitoring and Advisory Service, access to the Knowledge Base, and more. The MySQL Enterprise Installer provides a single installation package that can install MySQL Enterprise, and a number of additional components including the MySQL Connectors and MySQL Documentation in a number of different formats.

The full list of components provided by the MySQL Enterprise Installer is as follows:

• MySQL Enterprise Server, incorporating:

  • MySQL Database Server (mysqld)

  • MySQL command-line tools and utilities

  • Developer components (including the MySQL Client Library for use with third party tools and connectors; and the API for C/C++ developers)

• MySQL Network Service Agent

• MySQL GUI Tools, incorporating:

  • MySQL Administrator

  • MySQL Query Browser

  • MySQL Workbench

  • MySQL Migration Toolkit (Windows only)

• MySQL Connectors, including:

  • MySQL Connector/J — a JDBC compliant Java interface

  • MySQL Connector/ODBC — an ODBC driver

  • MySQL Connector/NET — an ADO.NET compatible driver for the .NET environment and languages

• MySQL Documentation, incorporating the documentation for the server, command line tools and connectors.

Enterprise Installers are currently available for the following platforms:

• Windows x86 (including Windows 2000, Windows XP and Windows Server 2003)

• SuSE Linux x86 and X64

• RedHat Enterprise Linux 4 x86 and X64

2.3.4.1. Using the Enterprise Installer for Windows

The Enterprise Installer for Windows provides both background information on MySQL and links to the MySQL Web site and documentation. The installer can be used to add any of the MySQL Enterprise components to your Microsoft Windows 2000, Windows XP or Windows Server 2003 computers.

To start the installation process:

Double click on the mysql-enterprise-VERSION-win32.exe installer application, where VERSION is the version number of the release you are installing. For example, mysql-enterprise-5.0.26-win32.exe. There may be a slight pause before the installer shows the first stage of the installation process as the installer extracts some components.

2.3.4.2. Choosing What to Install

This section does not apply to MySQL Community Server users.

Whether you are running the Enterprise Installer under Windows or Linux, the basic interface and options available to you are the same. Initially, you will be offered three choices:

• Preparation — this section of the installer enables you to examine the hardware and software requirements of MySQL Enterprise before you start the installation process. Please read this information carefully.

  

  Release notes provide information on the changes, bug fixes, and issues within the corresponding release. Please note that release notes in this section of the installer are currently provided only for the MySQL server component. You should read this information carefully, as the notes provided will list the bug fixes and major functionality changes that affect this release. You should ensure that these will not affect your existing installation before continuing the installation process. For information on all releases, different release types, and schedules, please see Appendix C, MySQL Enterprise Release Notes.

  For information on the changes in MySQL Network Monitoring and Advisory Service, the MySQL GUI Tools and Connectors, please see the relevant section of Appendix E, MySQL Change History.

  

• Installation — this is the main installation process and interface. A number of options are provided so that you can run choose which components to be installed. For more information, see Section 2.3.4.2.1, “MySQL Enterprise Installation Process”.

• Other Information — this sections provides links for the MySQL web site and the MySQL Enterprise License Agreement.

If you exit the installer at this stage, using the Exit link, no software will have been installed.

2.3.4.2.1. MySQL Enterprise Installation Process

To install MySQL components, choose option 2 (Installation). The main installation screen enables you to select the type of installation.

Four different installation options are available:

1. Server Default — this installs all of the components required for running a MySQL database server, including the core server application, command line utilities, the MySQL client library, and documentation. The MySQL GUI tools and connectors are not installed with this option.

2. Client Default — this installs all of the components required for a client to communicate with a MySQL database server. This includes the MySQL client library, GUI tools, connectors, and documentation.

3. Full — this installs all the available components, including MySQL database server, client library, GUI tools, connectors, and documentation.

4. Custom — this option enables you to select the individual components to be installed. You can choose not only the major groups (for example MySQL database server) but also individual subcomponents (command-line utilities). You will need to select the individual components that you want to install.

   

These options are summarized in the table below.

Component	Server Default	Client Default	Full	Custom
MySQL Server	Yes	No	Yes	Optional
Client Library	Yes	Yes	Yes	Optional
GUI Tools	No	Yes	Yes	Optional
Connectors	No	Yes	Yes	Optional
Documentation	Yes	Yes	Yes	Optional

MySQL Network Service Agent

The MySQL Network Service Agent can be installed by selecting the appropriate option when the installation process for the main components has been completed.

You must have a MySQL Network Monitoring and Advisory Service Network Manager already installed and running on your network to use the Service Agent. You will need the MySQL Agent URL to complete the configuration process.

Once you have selected the type of installation, or selected the individual components to be installed if you have selected the Custom installation type, the installation process will start to copy the files, applications and other components to your machine.

The installation process will take some time, with the exact period depending on the features and options that you have selected to install.

Once the process has completed, you will need to click Next to complete the post-installation process. You can choose to automatically execute the MySQL Server Configuration Wizard (which provides an interface for configuring the parameters of your MySQL Server installation) and the MySQL Network Monitoring and Advisory Service Installer.

To complete the installation sequence and execute the optional post-installation processes, click Finish.