First I find out the first commit that is in 5.7 that isn’t in 5.6 (using bzr missing) and then look at the authors of all of those commits. Measuring the number of commits is a really poor metric as it does not measure the complexity of the code committed, and if your workflow is to revise a patchset before committing, you get much fewer commits than if you commit 10 times a day.

There are a good number of people who are committing a lot of code to the latest MySQL development tree. (Sorry for the annoying layout of “count. number-of-commits name”)

1. 1022 Magnus Blaudd
2. 723 Jonas Oreland
3. 329 Marko Mäkelä
4. 286 Krunal Bauskar
5. 230 Tor Didriksen
6. 218 John David Duncan
7. 205 Vasil Dimov
8. 197 Sunny Bains
9. 166 Ole John Aske
10. 141 Marc Alff
11. 141 Frazer Clement
12. 140 Jimmy Yang …

MySQL Connect is rapidly approaching but there is still time for you to register. Calvin Sun from Twitter is going to be speaking and is the second of prominent MySQL Community members in this blog series to show you why you should join us.

What are your speaking about at your session?
MySQL at Twitter.

Who would benefit most from attending your session?
Scaling MySQL.

What other sessions would you recommend or are planning to attend?
MySQL 5.6 at Facebook [CON7798]
MySQL Performance: Benchmarks, Tuning, and “Best” Practices [CON2971]
MySQL @ Facebook: Lots and Lots of Small Data [CON7446]
InnoDB: Table and Index Data Structures Architecture [CON6897]
The InnoDB Buffer Pool and I/O: How It All Works [CON3497]
Unlocking MySQL: Dealing with Locking in MySQL …

Following our events earlier this year in Raleigh, Montevideo, Buenos Aires, Toronto and Portland, we bring Percona University to …

MySQL Connect is very quickly approaching and I will have some insights from prominent members of the MySQL Community about why you should join us September 21st-23rd in San Francisco. Mark Callaghan of Facebook is the first subject and his answers are short, sweet, and concise.

What are your speaking about at your session?
The reasons and process of upgrading to 5.6.

Who would benefit most from attending your session?
People considering 5.6

What other sessions would you recommend or are planning to attend?
All of the sessions on InnoDB internals

Why should ‘Joe Average’ DBA or Developer attend MySQL Connect?
Learn more, network with others in the community, let Oracle know what you need in MySQL 5.7

A big thanks to Mark for being the first …

Our bigger customers where we help to deploy Galera Cluster for MySQL set-ups have some commercial hardware (e.g. F5 or Cisco) for load balancing instead of software load balancers.

For those hardware load balancer it is not possible to see if a Galera node is available or not because the MySQL daemon is still running and responding on port 3306 but the service is not available nonetheless.
So the load balancer still serves the Galera node while he feeds for example a joiner node with a SST. This would lead to application errors which is unlovely.

One can try somehow to teach the load balancer to find out if a Galera Cluster node is really available or not. But this requires a more sophisticated load balancer, know-how how to teach the load …

With the General Availability of the standalone MySQL Utilities it now makes sense to use these to simplify (and optionally automate) your MySQL Replication and High Availability solutions. In light of that, 4 of our MySQL white papers have been updated to reflect the new opportunities:

MySQL Guide to High Availability Solutions. Data is the currency of today’s web, mobile, social, enterprise and cloud applications. Ensuring data is always available is a top priority for any organization – minutes of downtime will result in significant loss of …

Time zones are a tricky feature. You live in a given time zone, and most of the time you won’t think about that at all. You may live in a place where you are conscious of time zones, such as the United States, if your business spans across the country, where you know that New York is three hours ahead of San Francisco or Chicago and Dallas share the same time zone. Time Zone support in MySQL is a complicate business in itself. Once you have updated your time zone tables, you can set your time zone in an human readable format:

set global time_zone="America/Los_Angeles";

This is nice and well. It tells you which time zone your server is working with. However, things get a bit hairy when you need to do practical …

Percona Server is bundled with the PAM plugin which opens a plethora of ways to authenticate to MySQL such as restricting time when users can connect to MySQL, authenticate via a USB key, authenticate to an external authentication system such as LDAP and many, many more PAM compatible mechanisms.

If you want to use PAM authentication on the community version of MySQL, you may follow the instructions here to get it working on your system. If you want to test PAM authentication, the simplest way is to authenticate via /etc/shadow. The steps do so can be found in here or you can follow the steps below.

Here’s a primer for setting up …

The MySQL Connect conference is a great opportunity to engage with the MySQL community, as well as the engineers who work on the MySQL technologies at Oracle. The conference takes place on September 21-23 in San Francisco. There are 84 sessions in total, the full list being available here.

I will be presenting this year too. Sveta and I will be talking about how you can best …

It is hard to believe it is already closing in on a year since the last MySQL Connect, but it is true, it is time to start preparing again.

This year MySQL Connect will take place in the weekend of 21-23 September with the Monday being dedicated to tutorials. As last year MySQL Connect is part of Oracle OpenWorld and is hosted at Hilton, San Francisco Union Square.

I am fortunate enough this year to be taking part in three sessions:

• Meet the MySQL Community and Support Teams [BOF2480]
  Join MySQL community and support team members in this BOF to ask all your questions as well as provide feedback, …