From my testing MySQL Cluster on the Raspberry Pi's I thought I'd share this little extract, just in case someone tries the same, some day.. somewhere.. why? I don't know.

Ok, so when we pull the plug on one of the pi's, we have of each component falling down, but because one of them is the arbitrator (node-id=2) then cluster falls over.

Before the 'accident':   ndb_mgm -e show

Connected to

Eight MySQL Connect Hands-on Labs will offer you the chance to get hands-on experience about various topics. They will all take place in room Franciscan A/B at the Hilton Union Square and here is the schedule:

MySQL’s EXPLAIN Command New Features - Evgeny Potemkin, Oracle
Saturday, 11.30am - 12.30pm

MySQL Replication Best Practices - Luis Soares, Oracle
Saturday, 1.00pm - 3.30pm

MySQL Cluster Monitoring: Availability and …

Continuing with my wishlist, I’ll add windowing functions. They’re enormously powerful. They allow you to extend relational logic beyond the strict boundaries of tuples. In MySQL at present, one must use ugly hacks to preserve state from one row to the next, such as user variables — which are not guaranteed to work if the optimizer changes the query plan.

And yeah, PostgreSQL and SQL Server have windowing functions too, and once you’ve used them it’s a little hard to go back. This is in fact one of the main things I hear from people who love PostgreSQL for what I consider to be legitimate reasons.

Windowing functions extend the uses of SQL (sometimes awkwardly, sometimes elegantly), into areas you can’t really go without them. Time-series data, for example, or more powerful graph processing. These things must be done externally to SQL otherwise, in ugly procedural logic.

Windowing functions together with CTEs …

Hello :)

I am Narayanan Venkateswaran (mostly referred to as VN :) ) and work at Oracle in the MySQL team.

This is a great place to be and I love every moment of my work on this great product. I have brilliant colleagues and a fantastic work environment.

In this blog I intend to write about development in MySQL and general database topics that are of interest to me.

InnoDB does not support export/import of individual partitions and hence MEB selective backup does not support it

The description of the Milestone Release model has been available at http://dev.mysql.com/doc/mysql-development-cycle/en for almost two years. So, this is not new but it has now been in operation for 3.5 years and it can be worth looking back and summarize.

Our first MySQL Server Milestone 5.4.3 was released on October 9th, 2009 and was then followed up by 5.5.2 on Feb. 26, 2010. Initially there was a time of trying out and fine tuning the model before it found its current form around 5.5 GA. The stabilized model has been followed consistently throughout the 5.6 development cycle.   Our latest milestone release (5.7.1) was released on April 22 and was covered in Tomas’ keynote on Percona Live, see http://www.youtube.com/watch?v=OpHTV59I1gs. In total we have now done 11 …

The other day I was running pt-duplicate-key-checker on behalf of a customer and noticed some peculiar recommendations on an InnoDB table with an odd structure (no PRIMARY key, but multiple UNIQUE constraints). This got me thinking about how InnoDB promotes UNIQUE constraints to the role of PRIMARY KEYs. The documentation is pretty clear:

[DOCS]
When you define a PRIMARY KEY on your table, InnoDB uses it as the clustered index. Define a primary key for each table that you create. If there is no logical unique and non-null column or set of columns, add a new auto-increment column, whose values are filled in automatically.

If you do not define a PRIMARY KEY for your table, MySQL locates the first UNIQUE index where all the key …

The folks at Ubuntu are running a contest to see who can write the best juju charm!

Juju is Ubuntu’s cloud deployment/service orchestration tool. Charms are
the scripts used by juju to do software deployment and management.

Currently MySQL has ~8800 downloads from the Charm Store, making it the most popular service deployed with Juju.

The contest runs until October 22, and has over $60K in prizes to be won. For more information see: https://github.com/juju/charm-championship.

I am about to give a talk at MySQL Connect about what you need to know before upgrading to MySQL 5.6.

The PDF slides are online at http://bit.ly/upgrade56. I will be posting a video in the next few weeks!

I am about to give a talk at MySQL Connect about what you need to know before upgrading to MySQL 5.6.

The PDF slides are online at http://bit.ly/upgrade56. I will be posting a video in the next few weeks!

The 3rd season of MySQL Marinate begins October 1st, information pills or if you prefer, price MariaDB or Percona.

If you do …

The pace of MySQL engineering has been pretty brisk for the last few years. I think that most of the credit is due to Oracle, but one should not ignore Percona, Monty Program, Facebook, Google, Twitter, and others. Not only are these organizations (and the individuals I haven’t mentioned) innovating a lot, they’re providing pressure on Oracle to keep up the improvements, too.

But if you look back over the last few years, MySQL is still functionally a lot like it used to be. OK, we’ve got row-based binary logging — but we had binary logging and replication before, this is just a variation on a theme. Partitioning — that’s a variation on a theme (partitioned tables are a variation on non-partitioned tables). Performance — same thing, only faster. And so on.

I’m painting things with too broad a brush. There’s actually a lot of stuff that’s NOT just a variation.

But if you look around at what’s out there …