RE: oracle acquires Innobase

Sounds like innodb "on top of" My SQL.

Chris Marquez
Oracle DBA

http://www.innodb.com/howtouse.php

InnoDB short introduction

InnoDB is a table type in MySQL which offers several advantages to its users:

• 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 MyISAM tables in many simple benchmarks. See the benchmark page.
• InnoDB tables have row level locking: they allow higher concurrency than MyISAM tables which use table level locking, or BDB tables, which use page level locking. High concurrency is reflected in high multiuser performance.
• InnoDB tables provide an Oracle-style consistent read, also known as multiversioned concurrency control. SELECTs do not need to set any locks and need not interfere with inserts and updates to the same table. No other MySQL table type has this property.
• There is a true hot backup tool available for InnoDB, which allows you to make backups of a running database in background, without setting any locks or disturbing database operation.
• Multiversioning also allows you to dump tables from your database with SELECT INTO OUTFILE without setting locks on the tables: the database can keep working while a backup is made.
• InnoDB tables have automatic crash recovery. You do not need to repair your tables if the operating system or the database server crashes, when there is no disk image corruption.
• InnoDB tables can be any size, also on those operating systems where file size is restricted to < 2 GB.

How to download a binary version of MySQL/InnoDB?

For Unix, you should download one of the MySQL binaries at this page. For Windows from this page. Use mysqld-max.exe on Win 95, 98, ME, and mysqld-max-nt.exe on Win NT, 2000, and XP. How to compile MySQL-4.1 with InnoDB?

If you do not want to use a binary distribution, but want to compile MySQL/InnoDB yourself, download a source 'tarball' from this page. After downloading, unzipping, and untarring the tarball, go to the main directory of MySQL (usually named something like mysql-4.1.7), and type:

./configure --with-innodb
make

Then you have to compile and install MySQL. For information on this look at the MySQL documentation.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org on behalf of Keith Moore Sent: Fri 10/7/2005 2:32 PM
To: DGoulet_at_vicr.com
Cc: Oracle-L
Subject: RE: oracle acquires Innobase  

Here's the quote from the press release:

"InnoDB is not a standalone database product: it is distributed as a part of the MySQL database. InnoDB's contractual relationship with MySQL comes up for renewal next year. Oracle fully expects to negotiate an extension of that relationship."

We shall see whether that last sentence is true or not.

Keith

> I believe it is. Talk about a way to take the wind out of someone's
> sails!!
>
> _____
>
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Richard Ji
> Sent: Friday, October 07, 2005 2:07 PM
> To: Oracle-L
> Subject: oracle acquires Innobase
>
>
> Isn't this the InnoBase that provides InnoDB engine to MySQL?
> Thoughts?
>
>
>
> Market Pulse: Oracle acquires Innobase OY; terms undisclosed
> Friday October 7, 1:49 pm ET
> By Katherine Hunt
>
> SAN FRANCISCO (MarketWatch) -- Oracle Corp. said Friday that it has
> acquired Finland-based Innobase OY, an open source software company.
> Terms of the transaction weren't disclosed, Redwood City, Calif.-based
> Oracle said.
>
>

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l