Tuesday Apr 28, 2009

The pursuit of openness

When I joined MySQL in 2006, after several profitable years as a consultant, I had a dream. I wanted to improve the product that had contributed to my professional success.

The first thing that I learned when I started the uphill task is that it was far more difficult than expected. MySQL called itself open source, but the development practices were for all practical purposes closed source. At the same time, I found that MySQL, below the surface, is an organization with complex and well oiled engineering practices.

Indeed, opening up the cathedral, as Lenz put it, was a hard nut to crack. We had a closed source revision control system, and our developers loved it so much, that any proposal to change it was met with strong opposition. We discussed technical matters behind the firewall. Our code review process, although technically demanding and very thorough, was kept in our internal mailing lists.

Sakila closed 2

Contributions were scarce, with no good signs for the future. The binary split between community and enterprise servers made bug fixes contributions very unlikely. The impossible roadmap, with contributions going theoretically to version 6.1, in the distant features, practically discouraged any new proposal of code contribution, except for a few brave souls. On top of it, the Contributor License Agreement (CLA) had only recently been set up, yet formed a formidable obstacle for many people.

Sakila closed 1

Faced with such challenges, several people left. Either to new jobs inside the company or to new shores. The challenge is that you can't fix such a problem in one sweep. Changing practices in a company, especially from a position in which you can't take decisions, is really hard.

But not everyone left. The ones who stayed, in spite of the adverse circumstances, share a strong belief in the values of open source, and were determined to succeed, no matter what it takes.

With a little help of my team mates, Colin, Lenz, and Dups, I continued to support Kaj's internal action to spearhead the changes. While my younger colleagues were busy managing the community, Kaj and I were gently wrestling the rest of the company, to steer its direction towards a more open course.

The results arrived. Slowly, but surely.

  • In 2007, many developers opened the IRC gates, and started using freenode.net;
  • June 2008 - The open source Bazaar replaced the previous lock-in proprietary software Bitkeeper, which didn't allowed handling of the source from the outside;
  • In October 2008, we got rid of the CLA, in favor of the more open Sun Contributor Agreement.
Sakila open 1

The major obstacles were still the binary split and the long release cycle. There were much discussion internally, pleading and cajoling, to convince people that we were on the wrong path, and that our business model required a more open approach. Our team was under pressure. We were between the hammer of the community, shouting at us for not being open, and the anvil of the sales and marketing teams, unwilling to accept the assumption that a happy community generates future customers.

We kept going, and we kept pushing, until we got the announcement at the MySQL Conference 2009, stating the end of the binary split. Now the community server binaries will be published as often as the enterprise ones. The rationale of this request is that the strength of MySQl is in its wide community. We claim that the MySQL server is tested by millions of users, and yet we were giving the GA (mature) binaries only to a handful of customers.

This looked like a privilege, but it was in fact, from an engineering standpoint, a disadvantage. As a customer, I would gladly adopt a software that has been installed by a few million people, rather than being the privileged first one to try it in production.

With this announcement, we are back to the position that has made MySQL so popular and trusted. A database with a large user community.

The last barrier to fall will be the roadmap. So far, we have been tied to an impossible roadmap, with a wish list of features that had little chance of being released. The experience of MySQL 5.1, which took 37 months to release, has taught us a hard lesson. The next version, 6.0, has been in alpha for 25 months, with no near end in sight. Now we took the hard decision to replace the previous roadmap, where we piled features over features in an impossible attempt of pleasing future customers, with a milestone model, where we release features as they are mature, without waiting for all the features in the list to be ready. It means that we renounce the goal to release Falcon and Maria and the Online Backup as one single big bundle released at the same time in 6.0, and we put them aside. The MySQL engineers will schedule features for release as soon as they reach beta status, without waiting for the trailing ones.

Furthermore, we have now a process in place to accept contributions and to review them, with active participation from core developers. Yet, we have still work to do, to smooth the rough edges both internally and externally.

Sakila open 2

To our developers, who have not succumbed to the pressure, and have delivered top class software, while accepting our team's (not always) gentle suggestions to more openness, a hearty thank you!

To the many who have believed in MySQL and in our single and team efforts, thank you! To the many, who have suggested improvements, and contributed actively to our changes, thank you! To the ones who have not joined the flame war when unjustified rumors spread across the net, thank you!

To the ones who spread FUD, and twist every tiny piece of news in the shape of a conspiracy, I say wake up. Have you considered the possibility that we actually strive for the best for our community?

To the naysayers, who shout at us and abuse our goodwill from their self appointed righteousness, which often hides a secret business agenda, I say that we have always be working with the community in mind, and we will continue to improve. The path is still uphill, but the community team, the guardians of MySQL ubiquity, is happy with the progress so far, and will continue on this course!

Monday Apr 27, 2009

Presentation slides online at slideshare

I decided to give a try to slideshare. So I uploaded the slides from my most recent talks, and will eventually catch up with the old ones. My slides repository is http://www.slideshare.net/datacharmer.

If you are looking for the slides from MySQL Conference 2009, here are the shortcuts:

Wednesday Apr 01, 2009

Simulating Workload with MySQL Proxy web seminar - April 2, 2009 10:00PT

On April 2nd, at 10:00 PT (13:00 ET, 18:00 UTC, 19:00 CET), there is a free web seminar on Simulating Workload with MySQL Proxy.

I will introduce MySQL Proxy, and Diego Medina, MySQL QA Engineer, will talk about the juicy part.

Participation is free. To enlist, you need to register online and then you can attend the event from the comfort of your home or office.

Tuesday Mar 24, 2009

Follow us on Twitter

If you are a twitter user, you may like to know that there are many people from MySQL who are regular twitters.

For a start, you may want to follow these ones:


  1. kajarno Kaj Arnö
  2. datacharmer Giuseppe Maxia
  3. bytebot Colin Charles
  4. LenzGr Lenz Grimmer
  5. dups Dups Wijayawardhana


  1. mysqlconf MySQL Users Conference, which is going to be used during the conference to collect feedback for the panel keynotes.
  2. planetmysql Planet MySQL feeds
  3. mysqluk MySQL UK news

To find more people in the ecosystem, you may check the ones followed by the people above, and you will find most of the important players. Happy twittering!

Monday Mar 23, 2009

A taste of MySQL certification on Facebook

Do you plan to take the MySQL Certification?

Or, are you just curious to know how good you are at MySQL ?

If you use Facebook, and chances are that you do, then you should give a try to the MySQL Quiz Application.

Well, it is not like the real certification, but it's fun, and some of the questions are hard enough to give you pause.

The MySQL Quiz Application was created by Dave Stokes, the MySQL certification manager. Thanks, Dave!

Sakila quiz

Wednesday Mar 18, 2009

MySQL tour of California prior to the Users Conference

Mark your calendars!

Just before the Users Conference, 4 MySQL enthusiasts will tour California Universities and user groups.

This is the conclusion of the Dups on rails journey. When the heroic Dups arrives to California, he will have company. Colin Charles will tour Northern California with Dups. Yours truly and Sheeri K. Cabral will take care of the South.

Everyone is invited!

Are you in California and want to attend? You are welcome! I will publish more details as we finalize them.

Do you want to contribute with a guest appearance? Contact us! (datacharmer [at] sun [dot] com, dups [at] sun [dot] com).


North California
13-Apr-2009 Univ. of San Francisco
15-Apr-2009 Univ. of California, Berkley
16-Apr-2009 San Jose State University
16-Apr-2009 Stanford University, Palo Alto
17-Apr-2009 Univ. of California, Davis
South California
14-Apr-2009 Cal Poly, San Luis Obispo
15-Apr-2009 UCLA, Los Angeles
15-Apr-2009 Univ. of California, Irvine
16-Apr-2009 USC, Los Angeles
17-Apr-2009 MySQL Meetup Los Angeles

I would like to thank Dups, for starting this epic journey, and all the colleagues and Sun Campus Ambassadors who have contributed to the organization.

How MySQL tests server binaries before a release

What happens when the binary files of a fresh MySQL version is published on the web?

You may have noticed that the date on the release notes is not the same as the date the downloads are available. Sometimes there is a two weeks gap, sometimes more. Many people in the community have asked what is going on in the meantime.

The answer is a lot of hard work. The code is built for all the operating systems supported by MySQL, and tested in each platform (1). During this process, portability problems, test case glitches, and other things not caught in the normal daily build and test are fixed.

This task involves QA engineers, Build engineers, the Maintenance team, with help and cooperation from the Services, Development, and Community teams.

I asked our Build and QA Teams to tell what happens between the date a release is "branched off" from the Bazaar tree and the date it is available in the downloads page. This is the list of what goes on. It's very impressive that the regression test suite, which looks huge and intimidating to the casual user, is just a tiny bit compared to the rest of the torture tests that the server goes through.

BTW, this is just the tip of the iceberg. QA is a continuous process, not just a set of tests at the end. Sun/MySQL uses a continuous build and test process triggered on code check in, on different products and branches, in total 574 build and test runs a day (more about that in a separate article). The release process adds to that some more testing.

Thanks, MySQL engineers!

The following text was provided by Kent Boortz, Senior Production Engineer in the Build Team.

Tests run during the build process

During the build all packages was tested using the regression test suites. These tests are mainly testing SQL features, from basic queries to replication and partitioning, but also the “mysql” command line client, the “mysqldump” tool and other client tools.

The server can be run in different “modes”, SQL standards and protocols. Because of this, the same test suite is run several times with different combinations of these modes and protocols. As there are time limits not all combinations are run, but what is believed to be a fair sample of combinations to catch regressions. The test runs for each package are

  1. The main suite, except replication tests, was run against the bundled debug enabled server
  2. The main suite was run against the server in default protocol mode
  3. The main suite was run against the server using prepared statements protocol mode
  4. The main suite was run against the embedded server library
  5. The 'funcs_1' suite was run against the server using prepared statements protocol mode
  6. The 'stress' suite was run against the server in default protocol mode

There are some suites not run against all packages, or was disabled

  1. The 'jp' suite was run against the server in normal mode, but not against the Windows server (this is a bug the suite was not run, there is no good reason to skip this)
  2. The 'funcs_2' test suite was not run, disabled because of Bug#20447
  3. The 'nist' test was run using both normal and prepared statements protocol, in all builds but the RPM builds

Tests run after the release binaries are built

Some package tests are run after the packages are built, not in direct connection to the build process.

  1. The package names were verified
  2. RPM packages were checked for unwanted dependencies, like the IA-64 RPMs build using the Intel icc compiler, verified that no icc runtime libraries are needed to install
  3. A simple link test was done against the client and embedded libraries, to try catch missing symbols, missing headers or defects in the output of the “mysql_config” script, that defines the usage

Install Test

The binaries are installed and basic smoke test was done on all supported platforms to catch any install related issues. Testing on some of the platforms was done using automated scripts while on the others it was done manually.

System Test Suite

This is a concurrency/longevity test and can be configured to run with with different storage engines, concurrent users and time.

This test suite contains a number of of Insert/Update/Delete and Selects tests using stored procedures and triggers. The test also has an aspect of Integration testing, since it uses Events, Partitions, etc together and covers scenarios for various storage engines like testing MyISAM and Innodb together, e.g. a trigger on the Innodb table writes into a MyISAM table.

We tested the scenarios that contain inserts, updates, deletes and selects using stored procedures and triggers for innodb and myisam tables, separately. Each of these tests were run for a period of 24 hours with 50 concurrent users


This is also a concurrency/longevity test and executes Insert/Update/Delete scenarios using stored procedures and triggers but with replication. We tested 3 different scenarios one each for replication types RBR, SBR and MBR, Each of these tests were run with 100 concurrent users for 6 each hours with Innodb tables

High Concurrency

This is Concurrency/Longevity/Stress testing and executes an OLTP scenario on one table. The concurrency and the time period can be configured. We ran this test on Linux platform , with 2000 concurrent users over a period of 8 hours using InnoDB table


This is a single user performance benchmark and tests various scenarios, providing one specific angle to performance benchmark. With this test we catch \*performance results / regressions per operation\* (Sometimes "operation" = one SQL query, but often this is block of statements/queries). We ran this test using Prepared statements with MyISAM and InnoDB tables separately, Each test was run 3 times and the average time computed for each operation. The resulting performance numbers were compared with previous versions of MySQL server for identifying regressions..

DBT-2 Benchmark (TPC-C)

This toolkit implements the TPC-C benchmark standard, measuring the performance for OLTP scenario by using the New order transactions per minute (NOTPM). The tests are completely configurable. We ran the tests for CPU bound analysis with 16, 40 and 80 concurrent users with InnoDB tables and then compared the performance with both 5.1.30 and 5.0 version to detect performance regressions on SUSE platform.

Upgrade/Downgrade testing

Executes upgrade/downgrade scenario of the MySQL server, checking that objects can be created/altered/dropped and data can be inserted/updated/deleted/selected between the previous and current versions of MySQL. Objects include Permissions, Tables,Views,Triggers, Stored Procedures, events and partition and a large number of datatypes. Both live and dump/dump scenarios are tested.

We tested minor version upgrades from pervious versions of 5.1 to 5.1.31 and also major version upgrades 5.0.x to 5.1.31


We use the Sysbench tests to measure database server performance (OLTP benchmark) and compare this against the performance of previous mysql server versions.

We ran the OLTP_RO, OLTP_RW and also the atomic queries using InnoDB and MyISAM tables for 4, 16, 64, 128, 256 threads

Large dataset testing

This test suite runs insert/update/delete/select scenarios using indexes against a very large database containing up to 1 billion rows in the tables. We try to uncover areas where Query Analyser or Optimizer perhaps is not using the right approach. Large datasets provide clearer results on if internal query analysis & optimization has been done correctly.

Tests Using Random Query Generator

Additionally, replication tests were run in the 5.1 replication team tree using Random Query Generator tool. These tests were run on myisam tables, with all replication modes, with a "simple" workloads (DML only) and a "complex" workload (DML, DDL, implicit commit, other statements interesting for replication). Few bugs were found and fixed during this process.

How we deal with bugs during the release phase

As we use the "release often" process for enterprise releases, a bug found during the release process might not cause the process to stop to fix that bug, and rebuild it all.

If considered serious enough it will, but in some cases a bug is filed and the correction is targeted for the next or a later "maintenance" release (or what they are named).

Over time we will get better and better at test automation, preventing these kind of bugs to sneak in. But at this time it might, and means a maintenance release could be a regression to an unlucky user hit by that specific bug.

Having said that, it is rare that we find a new bug during the release process that is ignored, but it could happen, as said a side effect of the "release often" release process.

(1) Not all tests are run in all platforms. Some performance tests are only run on the most popular ones, to compare performance across versions.

Tuesday Mar 03, 2009

BoFs welcome at the MySQL Users Conference and Expo 2009

As usual, the MySQL Users Conference and Expo includes Birds of a Feather (BoF) sessions.

For the uninitiated, a BoF is an informal discussion group about a common topic. There is no registration and no fee for a BoF. You can organize one even if you don't plan to attend the main event. If your BoF is accepted and scheduled, you can organize it as you like. You won't get a free pass for a BoF, though.

We provide the rooms. You bring in the ideas. Submit a BoF proposal!

Almost everything is suitable for a BoF. We only ask that it is related to MySQL.

  • Do you have a project that you are developing and it is still in vaporware stage? No chances for the main conference, but perfectly OK for a BoF.
  • A topic that you feel is missing from the main schedule? Make a BoF.
  • Your favorite connector is neglected? A BoF may revamp the community attention.
  • Have you created a killer scheme that solves MySQL replication one-master-many-slaves limitation? Show it in a BoF.
  • Your fork of the Archive engine is the best thing since sliced bread? Boast it in a BoF!

Imagination is the only limit. Get a good idea. Make it known!

Tuesday Feb 17, 2009

Los Angeles MySQL meetup with Facebook DBA, Chris Schneider

South Californians, mark your calendars! On February 24th at 7,30pm the Los Angeles Meetup Group will host Chris Schneider, Facebook DBA, who will talk about "Scaling MySQL".

Now, if I talk about scaling MySQL, I will refer to personal experience in my consulting career, when 10 million people connected all at once to my customer's web site. You may be interested in the story or simply yawn. But when a Facebook DBA talks to you about scaling, 10 million connection is low traffic, and scaling takes a completely different meaning.

In this meetup, Chris will talk about different methodologies used at Facebook to deal with their scaling issues. If you are near Los Angeles on February 24th, you don't want to miss this meetup.

Monday Feb 16, 2009

MySQL Partitions at PHPCon Italia

I will speak at PHPCon Italia 2009, in Rome, on March 19th.

The subject is a very trendy. I will cover efficiency with partitions, a topic that every DBA and MySQL developers should enjoy.

Sunday Feb 08, 2009

FOSDEM 2009 - Boosting performance with MySQL 5.1 partitions

The MySQL Developers Room at FOSDEM was a success. There was a full room (about 80 seats, and many sitting on the floor) throughout the day. We started at 9am with a talk on PBXT, and ended at 17:00. My talk had a large audience and was very well received.

FOSDEM, the Free and Open Source Software Developers' European Meeting

The enthusiasm was quite high also because of a stunt I did during the presentation. It was a creative way of explaining the difference between physical and logical partitioning. I will repeat this stunt at the MySQL Users Conference, during my Tutorial on Partitioning.
Those who were attending today know about it. For the attendees at the Users Conference it will be a surprise.

The high point of the conference was at 1:15pm, with Kaj Q&A session, where we collected quite a lot of feedback.

For the many enthusiasts who followed my presentation, here are the slides.

Thanks to all participants for their stamina. Thanks to Lenz Grimmer for making this possible, and for the FOSDEM organizers for their kind hospitality.

Wednesday Jan 28, 2009

What’s New in MySQL Proxy?

After long wait, MySQL Proxy is back. Its new home on Launchpad is actively updated, and the busy bees Kay and Jan are working to bring us a binary release soon.

But, what exactly is new in MySQL Proxy?

It's easy to find out. On Thursday, January 29, 2009, 10:00 am PST, 1:00 pm EST, 18:00 GMT, there is a free webinar that explains the news in great detail.

If you have questions on what has been implemented and what is still in the making, this is your chance to find out. Participation is free. You only need to register on the webinar page.

Speaking at FOSDEM

I am getting ready to FOSDEM, the biggest European gathering of free and open source software enthusiasts. The event is held in Brussels, Belgium, on February 7-8, 2009.

FOSDEM, the Free and Open Source Software Developers' European Meeting

MySQL has a developers room on Sunday, with a schedule rich of well known names and juicy topics.

I will present a talk about partitions in MySQL 5.1.

Lenz will have a talk in the main conference, on MySQL high availability.

There is a wiki page on MySQL Forge where we will provide last minute information.

See you all in Brussels!

Friday Jan 23, 2009

MySQL Users Conference with embedded MySQLCamp

Well, I announced it a few months ago, and now Sheeri made it happen. The MySQL Users Conference and Expo 2009 will have a MySQL Camp embedded.

What is it? Asked most of the people I know, including many colleagues, some of them worried that I was giving away the company jewels.

For starters, it is not a competitor of the Users Conference. It won't duplicate its contents, nor is a way of sneaking into the main conference without a pass. It is a camp, and if you have attended either one of the previous MySQL Camps or the OpenSQLCamp, you know what I mean.

MySQL Camp is a gathering of MySQL geeks, developers, enthusiasts, code twisters, gurus, who want to exchange views on deeply technical matters. It is not run by Sun. While we have given Sheeri the task of organizing the event inside the event, we have purposely avoided being involved in the task itself. We want the camp to be a community event, and by community we mean you not us.

Let me just remind the rules of the game, as stated in my original post. Sun provides the room for the event and the rest is up to Sheeri, with two main guidelines.

  • Only MySQL related contents. This is the MySQL conference, and thus, if you want to hack a videogame or the latest music player, this is not the place to bring it.
  • No advertising. The Camp is a place for hacking code and exchanging technology. If you want to advertise your company, the main conference provides sponsoring and partner agreements that will allow anyone to promote their products.

Other than that, have fun!

Thanks, Sheeri, for organizing this event with your usual dedication and efficiency!

Monday Jan 19, 2009

Celebrating a year of MySQL and Sun

About one year ago, 400 MySQL employees were in Orlando, FL, for their company meeting. Their main worry was how to improve the business in view of the inevitable IPO that was coming soon. Nobody knew when, but there was expectation for Mårten Mickos keynote, on January 16, 2008, at 8:00. Possibly, everybody thought, he will announce a date for going public.

And public we went, but not the way we thought.

The evening before, I was among a group of about 25 people who were summoned to Mårten's suite, without a specific reason. At about 10pm, Mårten announced the $1B news, and for many of us there are only fuzzy memories after that. We weren't allowed to leave the suite before signing a NDA, to keep the news quiet until the following day at 8am.

Thus, having slept very little, with conflicting thoughts, I met my co-workers, and I couldn't tell anyone what was about to happen. We lined up for the keynote hall to open, and we were all seated and expecting the news of our launch into the Wall Street arena, which didn't come.

When Mårten announced that Sun Microsystems had bought MySQL for a billion dollars, many in the audience thought it was one of his jokes. Then, Jonathan Schwartz appeared on the giant screen, apologizing for wearing a tie because he was getting ready for a press conference and, he said, when you spend a billion dollars, you must dress like someone who knows what he's doing.

In very important moments, it's funny what you remember. I don't remember anything more of Jonathan's speech. The whole Orlando meeting is a series of flashbacks with little coherence.

I started waking up from the dizziness in the following days. Freshly appointed Community Team leader and on my way to a scheduled world trip, I had time to clear my mind while traveling.

I didn't come to terms with Sun until early April, when I started meeting new colleagues and understanding the organization. For MySQL, it is a change in scope that we understand, but we have barely started exploiting. We haven't generated $1B in revenues for Sun (yet). But the business decision sounds right. Inserting MySQL into Sun's portfolio is a good strategic move that will eventually pay off.

Now, enough with the old stories. Let's look at the future. Lenz and Dups have brought to you a gallery of 5 examples of good cooperation between MySQL and the rest of Sun. Starting with MySQL and Dtrace. Stay tuned for more!


Giuseppe Maxia


« July 2016