Fast, Reliable, Proven transactional storage for MySQL

InnoDB Plugin 1.0 for MySQL 5.1 Announced (2008-04-15)

At the 2008 MySQL User Conference, we announced the initial availability of the early adopter release of the InnoDB Plugin. Now, beginning with Version 5.1 of MySQL, it is possible for users to swap out one version of InnoDB and use another.

You can now download an early adopter release of an upgraded version of InnoDB with additional features beyond the standard built-in InnoDB provided by MySQL. The InnoDB Plugin supports several new features for improved performance, reliability, ease of use and flexibility. See here for a description of the new features in InnoDB Plugin 1.0 for MySQL 5.1. Documentation for the InnoDB Plugin is available here.

The early adopter release of InnoDB Plugin for MySQL is available for MySQL 5.1 and later, in source and binary (for most platforms) and is licensed under GPLv2. Users can dynamically INSTALL the InnoDB Plugin to replace the built-in InnoDB within MySQL 5.1 Linux and other Unix-like operating systems (and soon on Windows) without compiling from source or relinking MySQL. (For now, Windows users must re-build from source.)

Databases created with the built-in InnoDB in MySQL are compatible with the InnoDB Plugin. It is possible to use the InnoDB Plugin, and then “fall back” to the built-in InnoDB in MySQL 5.1 if desired. The InnoDB Plugin is supported via the new InnoDB Forums.

InnoDB Sessions at the 2008 MySQL User Conference (2008-04-13)

Heikki Tuuri, CEO and Founder of Innobase, and Oracle’s Ken Jacobs will be presenting at the MySQL User Conference in Santa Clara, California, Monday–Thursday, April 14-17, 2008. Several sessions are devoted to InnoDB and the new InnoDB Plugin. Please attend these sessions to get the latest information about InnoDB:

  • Tuesday 2:00–3:00 InnoDB: Status, Architecture, and New Features Heikki and Ken will present details about the latest version of InnoDB – the InnoDB Plugin 1.0 for MySQL 5.1. Be sure to attend this session describing the features, benefits and use of the new InnoDB Plugin, and learn how it can deliver better performance, reliability, flexibility and ease of use. Download the presentation here.
  • Tuesday, 04/15/2008 4:25-5:130 InnoDB: Fast, Reliable, Proven Transactional Storage for MySQL You’ll want to come to this session if you're just starting to learn about MySQL and its storage engines. If you’re new to MySQL, new to transactional applications, or wondering about how InnoDB compares to other emerging storage engines, this session is for you. Ken Jacobs will describe the features, architecture and benefits of InnoDB. Your business can depend on reliable, fast, and proven transactional capabilities. Make the right decision for your application! The presentation is available here.
  • TBD: Birds of a Feather Meet and greet fellow InnoDB users for a lively and wide-ranging discussion about technology and directions for InnoDB. At this BoF session, you and fellow InnoDB users will have an opportunity to network with one another, discuss best practices, and raise technical questions about how InnoDB works. Heikki and other InnoDB developers will be on hand to answer your most probing questions about how InnoDB works. This will be your best opportunity to learn more about the new InnoDB Plugin, and its new features and benefits.
Also be sure to attend the following sessions regarding InnoDB:
  • Tuesday 3:05-3:50 Investigating Innodb Scalability Limits Peter Zaitsev and Vadim Tkachenko of MySQLPerformanceBlog.com will discuss InnoDB and scalability. Find out what limitations have been solved in MySQL 5.0 and MySQL 5.1 versions. In this presentation, Peter and Vadim will look at several workloads and investigate how different versions behave on different operating systems and hardware. They will look at scaling in terms of CPUs as well as efficient use of multiple hard drives which can be a bottleneck for disk bound systems.
  • Thursday 10:50-11:50 Optimizing MySQL and InnoDB on Solaris 10 for World's Largest Photo Blogging Community Farhan Mashraqi from Fotolog will describe how Fotolog depends on InnoDB for its business. Fotolog is a top 19 Internet destination with more than 12 million members, 315 million photos and more than 3 billion page views a month. In just a few years Fotolog has become a social phenomenon in Europe and South America. Through modifications to its data architecture, Fotolog was able to serve four times the number of users using the same number of database servers. A non-conventional, hybrid presentation that conveys the importance of scalability, performance tuning and schema optimizations in a practical way.
  • Thursday 2:00-2:45 Scaling Heavy Concurrent Writes In Real Time Dathan Pattishall of Flickr will describe how MySQL and InnoDB scale to meet the demands this leading online photo management and sharing application. Flickr implemented a real-time collection of referrers to Photos, streams, sets and collections. Currently the data is gathered real time for every single user on Flickr. The data is then cooked and reported with a 24 hour lag for filtering out referrer SPAM. MySQL myISAM, InnoDB, curl, Java are the only components used in the setup and it scales linearly. This talk is about building a model for capacity planning, scaling for triple the request rate, and scaling linearly for an intensive application.
  • Thursday 11:55-12:40 Helping InnoDB Scale on Servers with Many CPU Cores and Disks Mark Callaghan of Google describes performance improvements in InnoDB to improve scalability on systems with many CPU cores and many disks. He will describe the performance problems in the official release and fixes for the problems that have been developed by InnoDB, Google, and the MySQL community.
  • Wednesday 5:15-6:00 Deadlocks, Wait Timeouts, and Other Transaction Issues Jess Balint of MySQL will discuss advanced issues in dealing with transaction processing. Most application developers have no problem handling the basics of transactions in their applications. However a number of issues can be encountered and these are usually missed during development. This session aims to deepen understanding of transaction processing and show how to properly deal with transactional issues. After examining the details of transaction conflicts, we will look at example error handling routines and review how the application can be affected. Finally some specific details of transaction processing in InnoDB and Falcon will be compared.

InnoDB sessions at the 2007 MySQL User Conference (2007-04-13)

Heikki Tuuri, CEO and Founder of Innobase, and Oracle's Ken Jacobs will be presenting at the MySQL User Conference in Santa Clara, Monday–Thursday, April 23–26, 2007. Several sessions will be devoted to InnoDB and InnoDB Hot Backup. Please attend these sessions to get the latest information about InnoDB:

  • Tuesday 4:40–5:25: Heikki Tuuri and Ken Jacobs will present InnoDB: Status, Architecture, and New Features
  • Tuesday 7:30–9:00: InnoDB Birds of a Feather session. Come meet with your peers to discuss InnoDB and InnoDB Hot Backup. This is a great opportunity to get your questions answered and have your voice be heard. Time and interest permitting, the session will include a brief presentation about InnoDB Hot Backup, its features and architecture. Heikki Tuuri and Ken Jacobs will be present.
  • Wednesday 9:05–9:50: Heikki Tuuri will appear in a keynote session along with Monty Widenius, Jim Starkey, and Mikael Ronström in a panel session titled Clash of the DB Egos to be moderated by MySQL's Kaj Arnö. They will discuss the state and future direction of database and hardware technology.
  • Wednesday 5:30–6:15: Especially if you're new to MySQL and its storage engines, you'll want to come to this session where Ken Jacobs will describe the features, architecture and benefits of InnoDB — InnoDB: Efficient, Reliable Transactional Storage for MySQL.
  • Thursday 1:40–3:15: Join Heikki Tuuri and Peter Zaitsev of Percona Ltd for an in-depth discussion of InnoDB Performance Optimization

Also be sure to attend the following sessions regarding InnoDB:

  • Tuesday 1:40–2:25: InnoDB Performance Potential in High-end Environments presented by Yasufumi Kinoshita, Database Technology Engineer, NTT COMWARE CORPORATION
  • Thursday 10:45 –:35: The innotop Workshop Baron Schwartz, Software Engineer, Rimm-Kaufmann Group

InnoDB Plugin 1.0.1 for MySQL 5.1 Released (2008-05-08)

The InnoDB Team is glad to announce the availability of the early adopter release of the InnoDB Plugin 1.0.1 which is licensed under GPLv2. Sources and binaries can be downloaded from here.

Compared to 1.0.0, 1.0.1 has the following changes:

Binaries have been compiled against MySQL 5.1.24 and can be plugged only in that version.
Source is compatible with MySQL 5.1.23 or 5.1.24.

Please report any problems or issues with the plugin in the InnoDB Forums.

Enjoy!

Innobackup 1.4.0 released (2007-11-29)

InnoDB Backup Utility (innobackup) 1.4.0 has been released. This version adds support for triggers and database options (.TRG, .TRN, and db.opt files). See the Hot Backup Manual for the complete changelog.

Download Innobackup 1.4.0.

InnoDB Hot Backup 3.0.0 has been released for Solaris 10 on AMD64 (2007-06-21)

This is the first release of InnoDB Hot Backup 3.0 for Solaris 10 on AMD64. MySQL/InnoDB 5.0 requires InnoDB Hot Backup 3.0. This version is also compatible with all older MySQL/InnoDB versions down to 3.23. See the Hot Backup Manual for the complete changelog and order an evaluation copy.

Innobase Oy is looking for guru-level software engineers (2007-03-23)

If you are interested in a career at Innobase Oy, please send a resume to heikki.tuuri at oracle.com.
We are offering a very competitive salary.

Our general requirements for applicants are:
-Must be able to write well-documented C code. Fluent in English.
-A MSc or a PhD degree or equivalent. Knowledge of MySQL or Oracle. Knowledge of database technology.

InnoDB is a transactional database engine that is embedded inside MySQL. Both MySQL and InnoDB are open source software. MySQL has an estimated 4 million users worldwide.
Innobase Oy is a subsidiary of Oracle Corporation.

MySQL/InnoDB-5.0.33 has been released (2007-01-10)

In the Win64 version, compiler optimizations were re-enabled in most of InnoDB code (Bug #19424).

MySQL/InnoDB-5.0.32 has been released (2006-12-20)

Improvements in memory use were implemented by simplifying the mutex structure (Bug #24386) and a fix was implemented for crashes that could occur during XA recovery of distributed transactions (Bug #21468). Also, a backwards compatibility mode for transaction rollback on lock wait timeout was introduced (Bug #24200). See the release notes for 5.0.32.

MySQL/InnoDB-5.0.30 has been released (2006-11-14)

The scalability of InnoDB with larger numbers of threads and on multi-core processors was improved in this release (Bug #15815 and Bug #22868). This release also includes a number of changes in locking (Bug #23769, Bug #18077, Bug #10746), and a fix for a race condition that could under rare conditions cause a crash (Bug #24089). See the release notes for 5.0.30.

InnoDB Hot Backup 3.0.0 has been released for Linux on PowerPC (2006-11-14)

This is the first release of InnoDB Hot Backup 3.0 for Linux on PowerPC. MySQL/InnoDB 5.0 requires InnoDB Hot Backup 3.0. This version is also compatible with all older MySQL/InnoDB versions down to 3.23. See the Hot Backup Manual for the complete changelog and order an evaluation copy.

InnoDB Hot Backup 3.0.0 has been released for Solaris 10 on x86 (2006-06-29)

This is the first release of InnoDB Hot Backup 3.0 for Solaris 10 on x86. MySQL/InnoDB 5.0 requires InnoDB Hot Backup 3.0. This version is also compatible with all older MySQL/InnoDB versions down to 3.23. See the Hot Backup Manual for the complete changelog and order an evaluation copy.

InnoDB Hot Backup 3.0.0 has been released for HP-UX 11 (2006-06-16)

This is the first release of InnoDB Hot Backup 3.0 for HP-UX 11 on PA-RISC1.1. MySQL/InnoDB 5.0 requires InnoDB Hot Backup 3.0. This version is also compatible with all older MySQL/InnoDB versions down to 3.23. See the Hot Backup Manual for the complete changelog and order an evaluation copy.

Oracle/Innobase win a Partner of the Year 2006 award from MySQL AB (2006-05-02)

Partner of the Year 2006

Oracle/Innobase were designated as a Partner of the Year by MySQL AB at the 2006 MySQL User Conference. The MySQL Partner of the Year is awarded to leading developers of MySQL-related products and services that provide high value to MySQL database users.

Of InnoDB, MySQL AB states: "Fantastic transactional performance, multi-year extension of relationship."


InnoDB Hot Backup 3.0.0 has been released for FreeBSD 5.x (2006-03-21)

This is the first release of InnoDB Hot Backup 3.0 for FreeBSD 5.x on i386. MySQL/InnoDB 5.0 requires InnoDB Hot Backup 3.0. This version is also compatible with all older MySQL/InnoDB versions down to 3.23. See the Hot Backup Manual for the complete changelog and order an evaluation copy.