MySQL Pluggable Storage Engine Architecture
MySQL's unique Pluggable Storage Engine Architecture gives users the flexibility to choose from a potfolio of purpose-built storage engines that are optimized for specific application domains - OLTP, Read-Intensive Web Scale-out, High-Availability Clustering, Data Archiving, Data Warehousing, and more.
Plus, The Pluggable Storage Engine Architecture provides a standard set of server, drivers, tools, management, and support services that are leveraged across all the underlying storage engines.
Getting Started Guide: MySQL Falcon Transactional Engine »
White Paper: MySQL 5.0's Pluggable Storage Engine Architecture »
Article: MySQL 5.0's Pluggable Storage Engine Architecture, Part 1: An Overview »
Article: MySQL 5.0's Pluggable Storage Engine Architecture, Part 2: A Quick Test Drive »
MySQL Storage Engine Partner Program
This multi-tiered program will enable database engine developers to certify that their software has been tested and is compatible with the MySQL Server. The Partner Program is designed to ensure that these engines have the highest levels of integration, usability, and performance.
MySQL Native Storage Engines
MySQL currently offers a number of its own native Storage Engines, including:
MySQL has recently made available a development version of a new advanced transactional storage engine --code named Falcon -- as part of the MySQL 5.2 Alpha release. Falcon was designed specifically for modern enterprise and web applications and is available through the open source GPL license. More information is available in the Falcon White Paper and Falcon Getting Started Guide.
Partner-Developed Storage Engines
MySQL Partners are actively developing Storage Engines that are optimized for specific application domains.
InnoDB is one of the most popular storage engines for MySQL. InnoDB provides full support of standard SQL isolation levels for ACID-compliant transaction processing, and maximizes throughput with row level locking and multi-version concurrency control (MVCC). InnoDB provides high performance by using many techniques to minimize expensive disk I/O through the efficient use of memory and processor resources. InnoDB ensures data integrity and reliability, with such capabilities as referential integrity support and automatic data recovery following hardware and software failures. InnoDB is included in MySQL Enterprise and MySQL Community. As part of MySQL Enterprise subscription, users can obtain support for InnoDB through MySQL AB. InnoDB is developed by Innobase Oy, a subsidiary of Oracle, and a premier partner of MySQL AB. In April 2006, MySQL and Innobase Oy agreed to a multi-year extension of their licensing agreement. InnoDB will continue to be among the best-supported storage engines for MySQL.
For more information, please visit www.innodb.com.
NitroEDB for MySQL is a high speed relational storage engine from NitroSecurity, originally developed to address the growing demand for real-time analysis within the network security event management market. NitroEDB’s focus is on high volume databases. Utilizing unique indexing techniques, data management methods and query processing algorithms, the technology enables “multiple order of magnitude” increases in relational data management and query performance with multi-billion record volumes – running on commodity hardware. The technology is currently deployed in NitroView Enterprise Security Manager, the industry’s highest performance network security monitoring and analysis solution. The General Availability for NitroEDB for MySQL is scheduled for Q2 2007.
BrightHouse for MySQL is a new storage engine for MySQL, available now from Infobright. BrightHouse is a highly-compressed engine designed for archiving data from multi-terabyte data warehouses. The engine compresses data at an average ratio of 10:1 (peak compression ratios exceed 30:1). For example, BrightHouse compresses 30 TB into 3 TB while maintaining immediate and comprehensive query capability. Additionally, BrightHouse operates on commodity-based Intel hardware thereby allowing installation on existing, low-cost platforms. The solution is available from Infobright today for Microsoft Windows servers, with Linux support scheduled for early 2007.
Community-Developed Storage Engines
MySQL's community of open source developers are also developing Storage Engines that are optimized for specific application domains.
Custom Storage Engines
MySQL's Customers are also developing customized in-house Storage Engines to address their specific needs.
Resources for Developing Custom Storage Engines
For more information about the MySQL Storage Engine Partner Program, please contact MySQL.