Fig. 1 User privileges stored in MyISAM

The Developer Release for MySQL Cluster 7.2 includes a new feature that allows the system data required for checking user access to be shared amongst all of your MySQL Servers. By default all of the tables holding these credentials are stored in MyISAM and so are local to that MySQL Server.

This can become painful to manage – every time you want to create a new user or change their permissions you need to repeat it on every server, miss one out and the user won’t be able to access that server (or will still be able to access it after you withdraw their privileges).

This is illustrated in Fig.1 – The user “fred” is created on one MySQL Server but when Fred attempts to connect to one of the MySQL Servers they’re blocked. This maybe what you wanted to …

Regular readers of this Blog or attendees at the 2010 O’Reilly MySQL Conference may recall a feature that the MySQL Cluster team were working to speed up JOINs (see Jonas’s slides from that conference here). The good news is that work has continued since then and it is now part of the new MySQL Cluster 7.2 Milestone Development Release. This post will step through where to get hold of the binaries and see the benefits for yourself. The examples I try here result in a 25x speedup just by turning the feature on – I’ve also seen a 50x speedup on other queries!

We’re anxious to get feedback on what benefits you see with your application’s JOINs, please respond to this post.

What’s in a name?

If some of this seems familiar but you don’t remember …

Great news was announced today at the Collaborate 11 conference today;  the first development milestone release of MySQL 5.6.2 is now available to the MySQL Community!  This is significant because 5.6.2 builds on the momentum generated by the performance, scalability, InnoDB and Replication improvements that rolled out in version 5.5 just last Dec.  It also marks somewhat of a paradigm shift in how the MySQL Engineering team delivers new, defined sets of stable, development complete features (development "milestones") and cutting edge, currently under development, delivered early and often features via http://labs.mysql.com/.  Both options provide a means for Community users to begin using new versions and, more importantly, new features of MySQL very early on ensuring the final product has undergone the highest degree of testing, validation and hardening before we deem it production ready.

 
Some of …

A quick reminder that MySQL is well represented at the Oracle Collaborate conference which starts in Orlando on Sunday.

For those not familiar with Collaborate, it’s the big community conference for Oracle users – this year it’s in Orlando from April 10th through 14th (I’ve just re-checked the weather forecast, 31 Celsius vs. -18 at the last conference I presented at – OOW Beijing in December – what a difference 4 months and 8,000 miles make!).

I’ll be presenting on MySQL Cluster in a session called “Building Highly Available Scalable Real-Time Services with MySQL Cluster” where I’ll focus on:

• Basics of MySQL Cluster – what it does, who uses it and why
• Accessing …

Going on with our MySQL Cluster studies, now I am starting this new post to talk or write about the Storage or Data Nodes, that one is responsible to storage all cluster data. When we start a cluster (as you have read at MySQL Cluster First Topics), the first step is to start the Management [...]

Conference season is rapidly approaching and the MySQL Cluster product team will be out on the road, sharing the latest and greatest news on best practices, use-cases and developments.  These will be valuable sessions for users who to learn more about building write-scalable, real-time transactional services with 99.999% availability, using a variety of SQL and Non-SQL (dare I say "NoSQL") interfaces to their data.

Collaborate Community Conference
Starting with the Collaborate IOUG community conference, these are some of the sessions that will be of particular interest to Oracle users:

-    The State of MySQL, 09:15 - 10:15, Monday April 11th to be delivered by Tomas Ulin, VP of the MySQL Engineering Team who will discuss the strategy for MySQL product development, including directions for MySQL Cluster.

…

Conference season is rapidly approaching and the MySQL Cluster product team will be out on the road, sharing the latest and greatest news on best practices, use-cases and developments.  These will be valuable sessions for users who to learn more about building write-scalable, real-time transactional services with 99.999% availability, using a variety of SQL and Non-SQL (dare I say "NoSQL") interfaces to their data.

Collaborate Community Conference
Starting with the Collaborate IOUG community conference, these are some of the sessions that will be of particular interest to Oracle users:

-    The State of MySQL, 09:15 - 10:15, Monday April 11th to be delivered by Tomas Ulin, VP of the MySQL Engineering Team who will discuss the strategy for MySQL product development, including directions for MySQL Cluster.

…

STOP PRESS: the recording of this forum is now available for replay.

On March 16th, we’re holding an on-line forum to discuss MySQL on Windows – I’ll be handling the High Availability session (includes MySQL replication and MySQL Cluster). The event runs from 9 am Pacific Time until 12:00 pm; the HA session is schedules for 11:00 Pacific and runs for half an hour. I’ll also be answering questions on-line during the forum. As always the even is free but you need to …

I will be at the MySQL UC representing Severalnines AB. Together with my friends at SkySQL (Max and Joffrey) we will have have a joint tutorial on MySQL Cluster. You will learn MySQL Cluster and we will do hands-on examples and present best practices to make your deployment easier. This also provides an excellent opportunity to discuss your requirements and get input and feedback on your database design.

Also, if you are in the area and want to discuss MySQL Cluster, high availability, scalability issues, email me at johan@severalnines.com and we can organize a meeting.

There’s a Meetup on Tuesday evening for MySQL users in the London area. It’s hosted at the Canonical offices (27th floor of Millbank Tower) at 18:30. Likely to last for a couple of hours before we head to a local pub for more serious discussions.

These are pretty informal events – if you want to find out the latest news in the MySQL world or have something to say then please come along. I’m hoping to discuss the latest MySQL Cluster developments.

Find the details and register at the Facebook page: http://www.facebook.com/event.php?eid=134352579966946&ref=mf