• MySQL知识库 :: upgrading to 5.1.x
  • What are the MySQL Server Binary distribution types and options?

  • MySQL Server Binary Distribution Types and Options

    The MySQL server is available in several different binary configuration options. These options provide users and customers with the flexibility to deploy MySQL in a configuration that best fits how data will be used and presented by the parent application. This article provides an overview of these configurations, where each is available. In the right margin are links to additional resources and further details.

    MySQL Enterprise Server Binary Configuration Options

    The MySQL Enterprise Server is included in a MySQL Enterprise subscription. It is provided to subscribers under a GPL license and is available in the following configurations to the indicated subscription levels:

    • MySQL Enterprise Pro Server (Available to all Enterprise subscribers)

      The Pro configuration includes the Innodb storage engine which is a fully integrated transaction-safe, ACID compliant storage engine will full commit, rollback, crash recovery and row level locking capabilities. This configuration is ideal for high-performance and scalable business-critical systems including e-Commerce, Online Transaction Processing (OLTP), and Data Warehousing applications. It provides the ease of use that has made MySQL famous along with industrial strength performance and reliability. It is important to note that the Pro Server is not configured for Partitioning.

    • MySQL Enterprise Advanced Server (Available to Enterprise Gold and Platinum subscribers)

      The Advanced configuration includes the Pro transactional feature set and advanced data Partitioning options. Like Pro, Advanced is ideal for high-performance and scalable business-critical systems including e-Commerce, Online Transaction Processing (OLTP), and Data Warehousing applications. Advanced adds horizontal table and index partitioning for improving the performance and management of VLDBs (Very Large Databases). It includes support for popular types of partitioning including Range, Hash, Key, List and Composite.

    MySQL Embedded Server Binary Configuration Options

    The MySQL Embedded Server is provided under a MySQL Commercial licensing agreement. The Embedded Server is licensed per server and supported under a separate OEM support contract. The Embedded Server is available in the following licensed configurations:

    • MySQL Embedded Server Classic

      The Classic configuration enables users to rapidly deliver high-performance, read-intensive applications with the smallest possible binary footprint. The default storage engine for Classic is MyISAM which provides a fully integrated, low overhead, reliable, storage option that is easy to use, and to configure with Full Text Search capabilities and Master/Slave Replication. It is important to note that MySQL Embedded Server Classic is not configured with Innodb (Classic does not support transactions) or Partitioning.

    • MySQL Embedded Server Pro

      The Pro configuration includes the Innodb storage engine which is a fully integrated transaction-safe, ACID compliant storage engine will full commit, rollback, crash recovery and row level locking capabilities. This configuration is ideal for ISV and OEM provided e-Commerce, Online Transaction Processing (OLTP), and Data Warehousing applications. It is important to note that the Embedded Pro Server is not configured for Partitioning.

    • MySQL Embedded Server Advanced

      The Advanced configuration includes the Pro transactional feature set and advanced data Partitioning options. Advanced adds horizontal table and index partitioning for improving the performance and management of VLDBs (Very Large Databases). It includes support for popular types of partitioning including Range, Hash, Key, List and Composite.