Tuesday, February 5th was an important day in the MySQL ecosystem due to the release by Oracle of the long-awaited MySQL 5.6 GA. Many MySQL users have been looking forward to this release in order to benefit from the improved performance and scalability. Features such as online operations/schema changes, NoSQL access from memcached to InnoDB, multi threaded-replication and Global Transaction ID significantly improve the competitiveness of MySQL.

read more

Fedora confirms MariaDB plans. IBM acquires Star Analytics. And more

For 451 clients: Metamarkets hones analytic focus on digital media, takes in-memory engine open source bit.ly/VElDqs By Krishna Roy

— Matt Aslett (@maslett) February 4, 2013

For 451 Research clients: WANdisco prepares to bring active-active replication to Hadoop bit.ly/VElEL9

— Matt Aslett (@maslett) February 4, 2013

For 451 Research clients: ScaleDB returns with database-virtualization play for MySQL bit.ly/XXt7zO

— Matt Aslett (@maslett) …

FOSDEM 13 is now over, I am on my way home and I would like to share some thoughts sparkled by the intense atmosphere that I have lived in these two days in Brussels.

I have to admit, I was tempted to skip FOSDEM this year: the last 3 weeks have been crazily busy and I travelled a lot, leaving my family alone for too long. But now I am glad I made the effort.
For once, I will leave the comments around the MySQL talks to others, I am sure there will be posts on the matter. In this post I want to cover some of the non-MySQL talks and discussions I have attended and heard. Of course the topics that have been discussed are still relevant for MySQL and for the future of the MySQL ecosystem.
First of all, the number of attendees was impressive. The organisers claim there were more than 5,000 open source enthusiasts, in my opinion the number was even higher. Every room was …

FOSDEM 13 is now over, I am on my way home and I would like to share some thoughts sparkled by the intense atmosphere that I have lived in these two days in Brussels. I have to admit, I was tempted to skip FOSDEM this year: the last 3 weeks have been crazily busy and I travelled a lot, leaving my family alone for too long. But now I am glad I made the effort.  

read more

Some show commands support a where clause. The column name that can be used in the expression for the where clause depends on the result of the show command. For example in show tables the column is Tables_in_foo where foo is the database name.

MariaDB [test]> show tables where Tables_in_test = ‘t';
+—————-+
| Tables_in_test |
+—————-+
| t |
+—————-+
1 row in set (0.00 sec)

This is a problem with the show databases command because databases aren’t really *in* anything. Database is a reserved word so this happens.

MariaDB [(none)]> show databases;
+——————–+
| Database |
+——————–+
| information_schema |
| mysql |
| test |
+——————–+
3 rows in set (0.00 sec)

MariaDB [(none)]> show databases where database=’test';
ERROR 1064 …

The news is already making the rounds (ex: rumors here, and confirmed here and here), but Fedora will apparently replace MySQL with MariaDB in an upcoming release.

read more

Actian acquires Pervasive. ObjectRocket has liftoff. And more.

For 451 Research clients: Actian’s persistence pays off as Pervasive agrees to $162m acquisition bit.ly/WPiGiS

— Matt Aslett (@maslett) January 30, 2013

For 451 Research clients: ObjectRocket has liftoff for MongoDB database as a service bit.ly/WuqF6R

— Matt Aslett (@maslett) January 29, 2013

Pervasive Software Inc. Enters Into Agreement to be Acquired by Actian Corporation bit.ly/TQ3J3t

— Matt Aslett (@maslett) January 29, …

The MySQL & Cloud Solutions Day will take place at the Hyatt Regency Santa Clara, immediately following Percona Live: MySQL User Conference and Expo 2013

read more

Informatica’s revenue is in. Hortonworks joins OpenStack. And more.

For 451 clients: Jitterbit gives integration stack makeover, continues to mine salesforce.com bit.ly/VJrwPE By Krishna Roy

— Matt Aslett (@maslett) January 28, 2013

For 451 clients: Enterprise cloud provider Skytap offers new service based on Cloudera Hadoop bit.ly/UpnXij By @rachelchalmers

— Matt Aslett (@maslett) January 25, 2013

For 451 clients: Alteryx plots course for 2013 as it seeks to bring business users into the analytic mix …

February is turning out to be a busy month. I’ll be giving a talk about MariaDB at the SkySQL Solutions Day in Hamburg, alongside Sergei Golubchik. This happens February 1 2013.

I’ll also be in Brussels for FOSDEM and presenting at the MySQL & Friends devroom. Here I will talk about MHA and how you can get automated MySQL failover. I’ll also be hanging out at the CentOS booth with Karanbir Singh giving away MariaDB stickers all weekend. If you’re at FOSDEM, don’t forget to sign up for the …