Hi Robin!
Innobase and Gemini are not linked, except that both will run under
MySQL. MySQL already offers transaction support in the form of
Berkeley DB tables.
Berkeley DB has only page level locking, while Gemini and Innobase
provide row level locks. In addition, Innobase has a consistent non-locking
read like Oracle. Consistent read is useful because you can make queries
to tables without blocking or interfering with concurrent inserts and updates
to the same table.
Thus, a MySQL user will be able to choose from 3 different engines
when he/she wants to use transactions in the database. Monty has chosen
a safe way of 3 parallel projects to get transactions to MySQL.
When you create a table to MySQL, you can specify the engine you want
to use, like:
CREATE TABLE T (A INT, B INT) TYPE = INNOBASE;
Tables stored in the transactional engines will appear like any tables
in MySQL, but you will have rollback and recovery capability for them.
Regards,
Heikki Tuuri
Innobase Oy
Helsinki, Finland
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
