I wrote last year about the way Google’s Android mobile operating system was serving as a more open alternative to Apple’s iOS, but not so open that it didn’t leave opportunity for an even more open alternative.

Given that we continue to see software patent-based attacks on Android, as well as swirling FUD around coverage of the attacks and never ending suits and settlements and courtroom developments, it is clear it will be a long time before any of this legal business is ever close to settled, unless ended by settlements first, which is likely.

However, I’m more interested in the technology in the meantime. I also think it’s interesting to see, if not a ‘more open’ …

CloudBees raises $10.5m. Microsoft commits $100m to SUSE. And more.

# CloudBees secured $10.5m in Series B venture funding.

# Microsoft renewed its vows with Attachmate’s SUSE business unit, committing to invest $100m in new SUSE Linux Enterprise certificates over the next four years.

# Oracle announced that it has acquired Ksplice, twhioch offers zero downtime update technology for Linux.

# Ingres announced that Steve Shine has been named Chief Executive Officer and President.

# Dell …

With OSCON in Portland under way (where LINBIT has a presence, of course), we are making three new documents available in the popular Tech Guides section of our web site.

• MySQL High Availability on the Pacemaker Cluster Stack is the definitive guide to setting up MySQL with DRBD on Pacemaker. A simple, step-by-step how-to which will have your highly available MySQL database up in no time.
• The DRBD Quick Reference has the most important DRBD …

After my recent Mac OS X 10.7 Lion upgrade I was greeted with a dialog box after reboot telling me that
com.apple.dock.extra.xpc needs to take control of another process for debugging to continue. Type the name and password of a user in the "Developer Tools" group to allow this.
No problem, I thought, and entered my credentials. Alas, to no avail. My name and password were rejected, which had me a little panicked at first, because I thought the OS upgrade might somehow have botched my account, potentially locking me out of my Mac later.

Hitting cancel would only get rid of the message for a few seconds, then it would reappear, again and again.
Turns out the solution was quite easy: Go the Mac App Store and download Xcode 4.1. Once the installer has finished downloading, …

Generally speaking, every result set that is created by a join is a certain combination of rows which are stored in MySQL tables. Even if you join more than two tables, MySQL always combines two result sets at a time. These result sets can be visualized with the help of so called Venn Diagramms, a mathematical representation of sets. Taking a look at them sometimes makes it easier to understand what’s actually happening. In addition, the human brain can store information like the different MySQL join operations or the related MySQL join syntax if it can connect them with some kind of picture. That’s the reason why we provide a graphical representation (a Venn Diagramm) for every MySQL join tutorial. You can access them by browsing all available “join tutorials“. …

Introduction

Note: this article was originally published on http://blogs.innodb.com on July 25, 2011 by Sunny Bains.

InnoDB has had the thread concurrency management code for some years now. Most will be familiar with the three configuration variables associated with this feature:

1. innodb_thread_concurrency
2. innodb_concurrency_tickets
3. innodb_thread_sleep_delay

…

Note: this article was originally published on http://blogs.innodb.com on July 25, 2011 by Sunny Bains.

Introduction

The InnoDB  UNDO entries reside in a special system table called the UNDO log. This log is made up of several segments. These segments are called rollback segments. A segment in InnoDB is similar to what a file would be in a file system,e.g., user tables and indexes are also stored as separate segments within the same tablespace,  only their format is different. In that sense there is nothing special about InnoDB UNDO logs. This feature allows storing of the UNDO log across several tablespaces.

Purpose

UNDO logs  contain the before image of modified records. There are two types of UNDO records, one for insert and another for updates. The insert UNDO records can be …

Note: this article was originally published on http://blogs.innodb.com on July 25, 2011 by Vasil Dimov.

Are you running an InnoDB installation with a many-gigabytes buffer pool(s)? Does it take too long before it goes back to speed after a restart? If yes, then the following will be interesting to you.

In the latest MySQL 5.6 Labs release we have implemented an InnoDB buffer pool(s) dump and load to solve this problem.

The contents of the InnoDB buffer pool(s) can be saved on disk before MySQL is shut down and then read in after a restart so that the warm up time is drastically shortened – the buffer pool(s) go to the state they were before the server restart! The time needed for that is roughly the time needed to read data from disk that is about the size of the buffer pool(s).

Lets dive straight into the commands to perform …

Congratulations and thanks to Monty Program on the release of MariaDB 5.3! This looks like a great release. (I haven’t had a chance to try it yet.) I really welcome the query optimizer improvements; the list of changes is huge. There are a lot of fixes for problems I’ve seen for years. And there’s group commit, and high-resolution date/time types, and lots more. And congratulations and thanks to Oracle on the next series of previews of what MySQL 5.

Note: this article was originally published on http://blogs.innodb.com on July 25, 2011 by Jimmy Yang.

This Summer’s lab release includes an important feature of InnoDB – InnoDB Fulltext Search. This feature would greatly enhance InnoDB’s capability in Text search and retrieving. Since the feature is designed for our transactional storage engine, its underlying architecture design and implementation are completely different with those of MyISAM. So it is worth to give a brief technology review of this feature, familiarize users with some important concepts in the InnoDB FTS so that they can better utilize this feature.

There are a few other posts on the subject. John Russell will give a brief tutorial on the InnoDB fulltext search command and syntax. I will also discuss some comparison with MyISAM fulltext search in another post. And Vinay in …