Overview

First off, the important news. Tungsten Replicator 2.1.0 was released today.
You can download it and give it a try right now.

Second, I would say that I am quite surprised at how much we have done in this release. The previous release (2.0.7) was in February, which is just a few months ago, and yet it looks like ages when I see the list of improvements, new features and bug fixes in the Release Notes. I did not realized it until I ran my last batch of checks to test the upgrade from the previous release, which I hadn’t run for quite a long time. It’s …

When the MySQL version from your distribution isn't good enough you need to download the latest Oracle MySQL. There are more possibilities like Percona Server and MariaDB, but that's not what this post is about.

The dowload site for MySQL is https://www.mysql.com/downloads/mysql/ and contains to a mirror.php script which ask you if you like to login with a Oracle Web Account and then chooses a mirror for you. You don't have to login. Then you will be redirected to the chosen mirror. In my case this is https://cdn.mysql.com

Firefox will give you a "This Connection is Untrusted" dialog. If you click on "Technical details" it will show the following error:

cdn.mysql.com uses an invalid security certificate.

The certificate is only valid for the following names:
  a248.e.akamai.net , *.akamaihd.net , …

Over the past few days extensive conversations around a new security vulnerability in MariaDB and MySQL have taken place.

It all started as a chain reaction when Monty Program publicly disclosed information about the flaw they had found and about how to make sure your MariaDB and MySQL installations can be fixed. The initial information got assigned the security vulnerabitlity identifier CVE-2012-2122 and the contents can be seen e.g. here http://seclists.org/oss-sec/2012/q2/493.

The bug was found two months ago on April 4th.

Before disclosing the information publicly, given the seriousness of this bug and considering the millions of MySQL and MariaDB installations deployed worldwide, Monty Program informed the biggest distributors of MySQL and MariaDB as a precaution.

On April 6th, Monty Program informed Oracle about it in bug report …

Probably …

During my years at MySQL AB I had the unfortunate task of manually maintaining the download page for enterprise customers. This involved a ton of boring, error prone work and almost always led to some sort of error every release. Some of our downloads were eventually replaced with an automated system written by the web team but the memory of all that time wasted still hurts me. So when I joined Monty Program and saw our downloads were manually maintained in mediawiki I knew something had to change.

Most of the websites for Monty Program and the MariaDB project are written with Django so this is where I started. I used our existing website code base and just created a new django application for downloads.  There are many models / tables involved in the system but the important ones are:

• Releases: A list of all the releases we have made, i.e. MariaDB 5.2.7, MariaDB …

If you run Debian or Ubuntu, and want a way to auto-generate a sources.list entry, then you should definitely look at: Setting up Repositories for Ubuntu/Debian. Its very simple: choose a distribution, then a release, then choose what version of MariaDB you would like to track and a mirror of your choice, and voila! it generates the sources.list for you.

What is the difference you might say, well in the title very little but in the content the difference is massive.

If you need to download lots of different versions of mysql for testing (like myself and many others) then you’ll need the former. If on the other hand you just care about the latest version and nothing more, then the latter is fine!

A few years ago, during the MySQL Conference opening keynote, two world maps of MySQL downloads were displayed. With the lights down, they made an impression.
Oddly enough, to the best of my knowledge, the downloads map has not been drawn again since then. I asked my friend and colleague Markus Popp, and he provided the data from the downloads logs, leaving the implementation to me.
A first attempt with Google Maps API produced a chart that is nice to see for a single country or town, but hardly pleasant for the entire world.

Then, I abandoned the easy path, and looked at CPAN for inspiration, and immediately found something that could solve my problem. Using …

I know a lot of people don’t like registering to download programs (even free ones), but in this case I would like people to register on the site with a valid email address so that I can notify users of new upgrades, security fixes, etc. I’ve had several support requests to fix items that have [...]

Its the Firefox Download Day. That not only means Firefox 3 is out, it also means that they’re trying to set a world record, by getting the most downloads of a software package in 24-hours. There’s a nice world map, similar to the kind you might have seen in presentations by Jonathan Schwartz (ok, I prefer seeing the dots per region, rather than the Firefox one :P).

The pending general availability of MySQL 5.1 was announced in April at the MySQL Conference. While I’ve seen 1,400+ attendees (a pleasant problem for the event organisers, as they scurried to get people into overflow rooms, and herd the crowd during food times) show up at the Tech Days in the Philippines, I’m wondering if we can achieve 3 …