Thomas Vander Stichele made my day

Since a while, everyday at 8pm, my N900 was complaining because it wasn't able to sync one of my calendar (my corporate google calendar). I never really paid attention... but yesterday I decided to fix this. The calendar sync is done using erminig-ng. My first action was to save the backtrace and have a look at it... I could understand that a integer was provided where the code was expecting a string. So before fixing this, I decided to get the last source code... mmm... and then the github reposirory of thomasvs made my day ! Indeed this guy already fixed the problem and explains that on his blog. He also provides a package to update erminig-ng on the phone :-) Thank you Thomas to not letting me reinventing the wheel !

MySQL & Friends at FOSDEM 2012

2012 is near... and so is the next FOSDEM edition ! This year again, MySQL will be represented by its Community. If you want to discuss with friend's of MySQL it's the place to be in February ! Like every year, FOSDEM takes place the first week-end of February in Brussels. The MySQL and Friends devroom is Room H.1309 (150 seats). We will have the room on Sunday 5th February 2012, all day. We are organizing a MySQL & Friends dinner on Saturday night, more to come later on this. If you want to propose a talk (you are in fact invited to propose one !), the deadline is December 26th. Like we did on past editions, as soon as the talks are submitted, we will ask everyone to vote on the talks via Twitter or email. Propose your talk now() here. Thank you and see you soon in Brussels to talk MySQL and/or have a nice Belgian Beer ;-) related posts: * datacharmer's blog * sergey petrunia's blog

Speaking at Percona Live London 2011

If you want to meet me, I will be speaking at Percona Live in London this October I will be presenting during the two days, on Monday Oct 24th during the tutorials I will present the MySQL DBA Swiss army knife. This is a technical session about the daily tools you must control as MySQL DBA. You will have your hands in the oil as we say in French and we gonna discover together how useful and powerful are those tools. We will cover different topics like performance, maintenance, ... On Tuesday I will present two talks during the conference: 1. Deploy MySQL like a devops sysadmin 2. MySQL partitioning: the Spider solution I hope to see you there and if you plan to join PLUK 2011 and you still don't register, I can provide you reduction voucher code, just contact me by email or on twitter.

Fedora on mac book (air) : wireless and kernel 2.6.40-4.fc15

If like me you are using Fedora on your mac book, after the week-end and in case of reboot, your wifi should not work any more :( Good, news, it's easy to fix, just add the following line to /etc/modprobe.d/broadcom-wl-blacklist.conf blacklist bcma Restart and enjoy wifi back ;-) ps: of course you need to use: kmod-wl-2.6.40-4.fc15.x86_64-5.60.48.36-2.fc15.6.x86_64 kmod-wl-5.60.48.36-2.fc15.6.x86_64

new professional perspective

For nearly 4 years, I invested myself in the growth of Inuits. At the beginning we were 5 to believe in this project and now, 4 years afterwards, Inuits has become the Belgian reference in the world of open-source consultancy companies. We started in Flanders, then in Wallonia with Esquimaux and now in the Netherlands with Eskimo (and I think it won't stop there). Having the feeling of the achieved duty, I had opportunity of working for a company which, for me, represents most the open-source point of views, of technical excellence and the opportunity to spend more time with my family. I was honored when Percona showed interest in me and I thus decided for that new challenge! -- thanks to all my friends/former colleagues/collaborators who played the role of references ;-) -- I whish good luck to all my colleagues of Inuits/Esquimaux, I appreciate them very much. They can always count on me if they need help and I hope to see them all at Fosdem and other free software or devops conferences !! I'm also always available for a drink or for sushi's :-) I also really appreciated the 10 years collaboration in open-source I shared with Kris Buytaert (sdog) June 16th will be my first day in my new position ! Percona here I come ;-)

Google calendar support in Gnome 3 evolution ?

During my test and discovery phase of Fedora 15, I noticed that Evolution doesn't support anymore google calendar... is it on purpose ? why ? Or do I need to install some other package ? I found this feature in Fedora 14 something very useful ! I hope this is something that will be fixed in the final release. In Fedora 14 (evolution-2.32.2-1.fc14.x86_64) : In Fedora 15 :

Gnome 3 and my favorite window focus and raise behavior

Yesterday night I installed Fedora 15 Alpha to see and test the gnome-shell (gnome 3) improvements. I stopped to test for one reason: I was not able to setup my favorite behavior for window's focus. What I like (this is mandatory, that's also the one major reason why I don't use Mac OSX daily) is that the focus follows the mouse but doesn't raises the window ! After having "googled" a bit, I tried to install gnome-tweak-tool... but it didn't help for this task... :( The solution is to use gconf-editor and changing the default value (click) of /apps/metacity/general/focus_mode to sloppy. Now I'm very happy and I can continue my tests of Gnome 3.

MySQL facter

Yesterday I started to play with mcollective I added some agents like service and facter. I really liked the facter agent.... and then I decided to add facts for MySQL. Of course I needed to learn some ruby first :-) A fact is created for the version and all other MySQL facts come from the SHOW STATUS statement. All the new facts start by mysql_ I plan to add new facts related to the replication like Seconds_Behind_Master The current version is available on github here

Some usage examples:

with facter: 
[root@delvaux facter]# facter mysql_version 2>/dev/null
5.5.10
[root@delvaux facter]# facter mysql_max_used_connections 2>/dev/null
3
with mcollective: 
[root@delvaux facter]# mc-facts mysql_version
Report for fact: mysql_version

        5.0.51a-24+lenny5-log                   found 1 times
        5.5.10                                  found 1 times

Finished processing 2 / 2 hosts in 64.36 ms



[root@delvaux facter]# mc-facts mysql_open_files
Report for fact: mysql_open_files

        16                                      found 1 times
        18                                      found 1 times

Finished processing 2 / 2 hosts in 2418.13 ms

[root@delvaux facter]# mc-facts mysql_open_files -v
Determining the amount of hosts matching filter for 2 seconds .... 2
Report for fact: mysql_open_files

        16                                      found 1 times

            delvaux.maladree.be

        18                                      found 1 times

            debian1.maladree.be


---- rpc stats ----
           Nodes: 2 / 2
     Pass / Fail: 0 / 0
      Start Time: Sat Apr 02 00:11:46 +0200 2011
  Discovery Time: 2001.84ms
      Agent Time: 1344.24ms
      Total Time: 3346.08ms

[root@delvaux facter]# mc-facts mysql_threads_connected 
Report for fact: mysql_threads_connected

        2                                       found 2 times

Finished processing 2 / 2 hosts in 3270.86 ms

[root@delvaux facter]# mc-facts mysql_threads_connected -v
Determining the amount of hosts matching filter for 2 seconds .... 2
Report for fact: mysql_threads_connected

        2                                       found 2 times

            debian1.maladree.be
            delvaux.maladree.be


---- rpc stats ----
           Nodes: 2 / 2
     Pass / Fail: 0 / 0
      Start Time: Sat Apr 02 00:12:47 +0200 2011
  Discovery Time: 2001.73ms
      Agent Time: 50.43ms
      Total Time: 2052.15ms

April 1st

My contribution to this heavy day for our rss readers is: The April's Fool Centipede ! 
    .:/          .:/           .:/            
  ,,///;,   ,;/,,///;,   ,;/,,///;,   ,;/
 o:::::::;;///o:::::::;;///o:::::::;;/// 
>::::::::;;\\\::::::::;;\\\::::::::;;\\\   
  ''\\\\\'" ';\''\\\\\'" ';\''\\\\\'" ';\
beware, don't believe all news today :)

Puppet and 64bits packages

Since I use puppet to manage my machines (and the machines of customers), I noticed that I had more packages installed then before, I noticed also obviously the same behavior in packages to update and bandwidth consumption during updates. I realize that on 64bits machines, most of the time, the 32bits version of the packages managed by puppet were also installed. This is what I did in my recipes before: 
    package { "corosync":
        ensure => "installed",
        require => Yumrepo["clusterlabs"];
    }
This kind of package declaration installed then the two version of the package, in this case corosync and the dependencies too. To avoid this I added the fact hardwaremodel and used the alias to keep my recipes consistent: 
    package { "corosync.$hardwaremodel":
        ensure => "installed",
        alias => "corosync",
        require => Yumrepo["clusterlabs"];
    }
Hope this could help people having noticed the same behavior... or not :-)

As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

You can find articles I wrote on Oracle’s blog.

Continue