Oracle buys Innobase
This morning Oracle announced the acquisition of open source software company Innobase. As we expand our commitment to open source software beyond Linux, this is a good/strategic move for Oracle. Innobase has long been an Original Equipment Manufacturer (OEM) for MySQL. InnoDB was distributed under a GPL license as part of MySQL Pro.
Essentially InnoDB is a table type in MySQL which offers several key advantages such as:
- InnoDB tables are transactional: they provide rollback and commit capabilities.
- InnoDB is the only table type in MySQL which supports foreign key constraints.
- InnoDB tables are fast, even faster than
- InnoDB tables have row level locking: they allow higher concurrency
- InnoDB tables provide an Oracle-style consistent read, also known as multiversioned concurrency control.
- There is a hot backup tool available for InnoDB, which allows users to make backups of a running database
- Multiversioning also allows you to dump tables from your database with
SELECT INTO OUTFILE
without setting locks on the tables - InnoDB tables have automatic crash recovery
Charles Rozwat, Oracle's Executive Vice President in charge of Database and Middleware Technology asserted that Oracle intends to continue developing the InnoDB technology and expand its commitment to open source software. It'll be interesting to see how this affects MySQL. Stay tuned!