We saved three XL-sized t-shirts from our recent all-company meeting in Istanbul. At first we thought it would be a good idea to give away the shirts through a random drawing. But after mulling it around in our minds for a day or two, we thought we should make it a bit more fun, so we decided to have a small quiz (don’t worry, it’s only one easy question).

Before we get to that, here’s a run-down of what we did in Istanbul. Our community and documentation guys (Daniel Bartholomew, Colin Charles, and Kurt von Finck) had the great idea to create an “Istanbul Haber” (aka Istanbul newspaper) for each day of the meeting. In each issue we shared what happened the previous day and the schedule for current day.

Day One: Friday, 8 Oct 2010

Istanbul Haber Day One PDF: MP Istanbul2010 Day One

Day Two: Saturday, 9 Oct 2010

On day two of our Monty Program Ab All Company Meeting Istanbul 2010 we joined together with SkySQL and enjoyed a talk by Mark C. and Domas M. from Facebook.

Istanbul Haber Day Two PDF: MP Istanbul2010 Day Two

Day Three: Sunday, 10 Oct 2010

Day three of our Monty Program Ab All Company Meeting Istanbul 2010 was on Sunday, 10 Oct 2010. Instead of taking Sunday off and seeing the sights, we decided to work and go on an excursion on Monday. Saturday and Sunday are the heaviest days for tourists in Istanbul so we figured it would be a good way for us to avoid the crowds.

Istanbul Haber Day Three PDF: MP Istanbul2o1o Day Three

Excursion day (aka our final day): Monday, 11 Oct 2010

The last day of our Monty Program Ab All Company Meeting Istanbul 2010 was on Monday, 11 Oct 2010. We spent our last day experiencing Istanbul. The theme of the excursion day was:

  • Downtown and then really down, over the sea, up and a surprise, then crossing the gap, and a warm and relaxing final, …

The description of our excursion day was riddle like and many people asked me about the details. So, for the curious, here is a more in depth description:

Basilica Cistern
  • Over the sea: a Bosporus tour on a private boat crossing the Bosporus from the European to the Asian side.
  • Up and a surprise: up to the Çamlıca Hill, having a quiz about Istanbul and eating “raw meat patty” without knowing it.
  • Crossing the gap: back to the European side of Istanbul by crossing one of the two suspension bridges.
Fatih Sultan Mehmet Bridge

Here’s the final Istanbul Haber:

Istanbul Haber final PDF: 2010-10-12-newsletter

Thanks

We would like to thank

T-Shirt Giveaway

Now that you know what we did in Istanbul, it’s time to give away some t-shirts. As mentioned at the beginning of this post, we have three XL-sized MP Istanbul 2010 t-shirts to give away. The first three participants who answer the following question correctly, will win one of those t-shirts (only one t-shirt per person).

Question: What is Maria in MariaDB and how is it connected to My and Max?

Email your answers to “istanbul2010-contest [at] askmonty (dot) o r g” before 31 Oct 2010. Good luck!

By the way, the design on the t-shirts looks like this:

MP Istanbul2010 T-Shirt Logo

There are more sites out there that have their backends running MariaDB. In fact, as we work to get it recommended alongside its upstream provider, it seemed time to have “Powered by MariaDB” logos. Check out the badges that Daniel created. Feel free to copy the images or hotlink them from the server.

Powered by MariaDB

As an aside, would any readers be interested in purchasing t-shirts or other MariaDB merchandise? What merchandise should we make, besides just stickers?

The intention from the start was to make upgrades to newer MySQL versions trivial. We have done a lot of work to keep data formats compatible (both in the .frm files and in the storage engines); when you install a new version of MySQL things should “just work”.

For a long time this was true, until MySQL 5.0 where we had to do some data incompatible changes, like in the way some characters were sorted and how end-of-line blanks were stored in indexes.

To make the upgrade process easy, we created the ‘mysql_upgrade’ program which should detect possible incompatible tables and automatically convert data as needed.

The full upgrade process (for your data) should always be as simple as:

  1. Install your new MariaDB / MySQL version.
  2. Start the mysqld server.
  3. Run mysql_upgrade.

Unfortunately, over time something has gone wrong. We found this out when a user recently tried to upgrade a big installation from MySQL 5.0 to MariaDB. The issues encountered included:

  • Tables with long names were not converted to the new 5.1 name format
  • Some InnoDB tables failed with the error: “Table upgrade required; Please do “REPAIR TABLE `xxx`” or dump/reload to fix it!”
  • The same failure for all ARCHIVE tables
  • Some strange error messages for some internal system tables

So the upgrade process for this user was actually:

  1. Install the new MariaDB / MySQL version.
  2. Start the mysqld server
  3. Run mysql_upgrade
  4. Make a list of all tables that failed to upgrade.
  5. Reinstall the previous MySQL version.
  6. Dump the problem tables with mysql_dump
  7. Remove the dumped tables.
  8. Install the new MariaDB / MySQL version again.
  9. Load the dumped tables.
  10. Test that nothing was missed with ‘mysql_upgrade –force’

We learned about the above problems on the #maria IRC channel and within 24 hours we had fixed all of the issues. We are happy to announce the full upgrade process is once again just the three step: Install new version, Start mysqld, Run ‘mysql_upgrade’.

We also added more options to mysql_upgrade and mysqlcheck (which is used by mysql_upgrade) to make it easier to find out what is happening if something does go wrong.

As part of the process (and to document the changes) we also added some new articles to our Knowledgebase about
upgrading from MySQL 5.0, mysql_upgrade and mysqlcheck.

We hope all the above will make the upgrade process much easier and more reliable for everyone!