InnoDB
Developer(s) | Oracle corporation |
---|---|
Written in | C |
Operating system | Cross-platform |
Type | Database engine |
License | GNU GPL v2 or proprietary |
Website |
www |
InnoDB is a storage engine for the database management system MySQL. MySQL 5.5, December 2010, and later use it by default replacing MyISAM.[1] It provides the standard ACID-compliant transaction features, along with foreign key support (Declarative Referential Integrity). It is included as standard in most binaries distributed by MySQL AB, the exception being some OEM versions.
Description
InnoDB became a product of Oracle Corporation after its acquisition of Finland-based Innobase Oy in October 2005.[2] The software is dual licensed; it is distributed under the GNU General Public License, but can also be licensed to parties wishing to combine InnoDB in proprietary software.[3]
Percona Server, as well as versions of MariaDB below 10.2, use a fork of InnoDB called XtraDB by default. XtraDB is maintained by Percona. Oracle InnoDB's changes are regularly imported into XtraDB, and some bug fixes and extra features are added.
InnoDB supports:
- Both SQL and XA transactions
- Tablespaces
- Foreign keys
- Full text search indexes, since MySQL 5.6 (February 2013)[4] and MariaDB 10.0[5]
- Spatial operations, following the OpenGIS standard
- Virtual columns, only in MariaDB
See also
References
- ↑ "Introduction to InnoDB". MySQL 5.6 Reference Manual. Retrieved 21 May 2015.
- ↑ "Oracle Announces the Acquisition of Open Source Software Company, Innobase". Oracle Corporation. 7 October 2005. Retrieved 28 March 2017.
- ↑ "Licensing MySQL and InnoDB". InnoDB.com. Retrieved 2008-07-31.
- ↑ http://www.oracle.com/us/corporate/press/1904335
- ↑ https://mariadb.com/kb/en/library/mariadb-1000-release-notes/
External links
- Mysqltutorial.org, InnoDB and other table types in MySQL
- The InnoDB Storage Engine, in the MySQL manual.