As did last week's Craig Mullins of dbazine.com I wrote a short post about the LogBuffer recently when I found it in my Blog's referrer list and was promptly asked if I would like to compile one myself.

So here am I am, welcoming all of you to the the 9th issue of the Log Buffer, a Carnival of the Vanities for the DBA community. Once again you will find a plethora of links to all sorts of information on the one thing that keeps many of us both fed and sometimes close to blank despair.

Myself being some sort of a mixture between a software developer and database admin I have had a fair amount of time over the last years to get experience …

So I have been really busy lately dealing with a bunch of stuff including having to reset replication (twice) on some of the slaves that started lagging behind seriously. While I am determined to find and fix this replication lag issue, the majority of it comes from the huge spec differences between the master and the slaves.

Anyway, yesterday I got my plane ticket to go to MySQL Camp which is really exciting. I will be arriving there on Thursday night and leaving Sunday night on an overnight flight.

Last time when I blogged I was writing about MySQL benchmarking, so I will try to pick up where I left off.

I was having some compile issues when trying to compile sysbench on Solaris. When I was running ./configure I was getting the following warnings:

###############################
./configure output …

I've just improved the MySQL duplicate index checker I whipped together a few days ago. As I guessed, my hasty coding left some things to be desired. I've fixed some bugs, added support for finding duplicate foreign keys, and switched to a command-line parsing library that comes standard with Perl, so it's more convenient to run without needing to fetch modules from CPAN.

MySQL is the most popular open source database in the world.

Softpeople Formazione of Milan, Italy, the education company of Softpeople Group, is please to announce that they have been selected by MySQL to be the first Authorized MySQL Education Center (AMEC) partner for Italy, offering certified MySQL training either by the two training Center in Milan, C.so Buenos Aires, 77 and Rome, Via Benedetto Croce, 19 as well as by customers' locations across the country.

Webyog is the company behind the popular SQLyog GUI tool for managing and developing MySQL databases. They have a great history of partnership with MySQL and, recently, decided to open source part of their product line. I had a chance to interview Rohit Nadhani, co-founder of Webyog, about their decision to move to open source, the changes they've made to the code as a result of that move, and various other things.

Sometimes we may need to know geocode of some specific postal location. For example, you have some shops catalogue and want to show shop locations on the map. Then, you will need to ask some service about map marker coordinates. If geocode service is not available or it can’t parse provided address, you will not be able to show map to your users. To solve such problem I’ve created small PHP-module, that helps me to get reliable results from set of miscellaneous geocoding services.

As for now, module can use Google Maps API, Yahoo Maps Services, Geocoder.us and …

activerecord now supports mysql 4.1 (and later) out of the box whether you are using new or old-style passwords, because they applied my patch for handling the related protocol changes correctly.

(it?s not quite out-of-the-box yet ? the fix will appear in the next major release of rails, i guess. it?s fixed in their repository.)

now if only the upstream developer would show signs of life, and get that fixed. i?d complain about that more, but there?s a lot of windows around here.

Our good friends at MySQL and Pentaho are hosting a webinar about ETL for MySQL using Pentaho Kettle. 

ETL is a multipurpose technology, from straight data integration to data migration to reporting systems.  Kettle is primarily used in building Data Warehouse/Data Marts but can also be used for doing other useful MySQL admin tasks. 

Matt Casters and Lance Walter will give you the low down on Kettle:
http://www.mysql.com/news-and-events/web-seminars/etl-using-pentaho-kettle.php

I recommend it, even if you’re not interested in MySQL.  You’ll be surprised that an Open Source ETL tool is so visual and easy to use you may consider it for all kind of tasks.

There's a good article from LinuxDevices that quotes IDC on sizing the open source market. IDC did a study of 5,000 developers in 116 countries showing that open source is being used by over 70% of developers. (Ok, so clearly there is still some work to be done!)

While this statistic may not be startling to those who have been using open source for years, it indicates that open source continues to become more mainstream.  Over 50% of the organizations had open source software in production, and that number seems poised for more growth given all the development usage.  It seems obvious to me that the next generation of killer applications will be based on open source.  Lets face it, once the majority of developers embrace it, it's all over but the shouting.

• LinuxDevices: …

What this project aims at is to stimulate the implementation/adoption of free software, open source software and open standards in the Bulgarian Government Administration (BGA) and other sectors of management, in the economics and at home.

There will be a reading of the EU requirements and a review on which of the open standards are suitable for the current status of the BGA. The project has the objective to prepare the migration from present-day to open source EU recommended technologies. We will create a special guide that will focus on how to migrate, how to make this process easier and how to create the prerequisites for doing so.
We will review all of the available OS and software possibility, covered by this project that can be used in the BGA and other sectors.

We need supporters and fresh ideas. Please let me know if you are able to help us with your experience, knowledge or by other way.