Category CentOS

2 days ago was released a new version of glb (Galera Load Balancer) that fixes connection problem (see the release note). If you want to try it on CentOS 6, I built a rpm.

Recently (yesterday), I faced a problem with percona-playback when I tried to use a slow query log (captured on a customer's server) and it fails dramatically. The log files was 2.3G and the second query was already returning an error :-( I seemed that I hit a bug that Aurimas, my colleague at Percona, already reported (bug 1035217): queries written on multi lines don't work ! My C++ knowledge is very old and also very limited, so I tried to understand and fix this issue myself. Mushu (dbasquare) already faced this problem and started to fix it before giving up as he needed to run it on Slowaris... Gently he sent me his patch that I modified to support my slow query log:

• queries on multi-lines
• queries being only a ; (semi-colon)
• queries finishing by another character than ; (with comments for example)

Attached to this post, you can find the rpm for CentOS 6 including that patch.

Baron announced today the release of Innotop 1.9.0.. Fedora provides Innotop 1.6.0 ! I have then build rpm for CentOS 6 to test it as soon as possible ! [update]: I made a typo (see comment bellow) in the requirement of perl-TermReadKey, I've fixed this in innotop-1.9.0-2.

As I wanted to test in my vagrant environment Yoshinori's MySQL replication booster, I needed to create rpms to be able to install it quickly and easily on those virtual machine without compiling it on the vm's. So if you are interested in this nice replication solution and you are lazy to compile it, you can use my rpm's listed bellow. Some links about the project:

• http://yoshinorimatsunobu.blogspot.hu/2011/10/making-slave-pre-fetching-work-better.html
• https://github.com/yoshinorim/replication-booster-for-mysql
• https://code.launchpad.net/mysql-replication-listener

mysql replication listener's rpm was built using modified specs from https://bitbucket.org/winebarrel/ruby-binlog/downloads Update I added the src.rpm as requested by nvidhive on #percona freenode.