Codership released a new version of the load balancer for Galera. I made new rpms but I forgot to share them ;)
Here they are !
This new version provides ] a "single" balancing policy where all connections are directed to a single destination chosen by highest weight, a --top option that forces balancing only between the destinations with the highest weight, and a SO_KEEPALIVE option on destination connections (default: on) for timely detection of the destination failure.
But this week-end while preparing selinux policies for Percona XtraDB Cluster, I noticed that it was really slow.... really really very very slooooow :'-(
And I found the reason ! I first tried to add some kernel parameters like :
noacpi noapic divider=10 notsc
But that didn't help.
Then I just enabled IO APIC on the VM's configuration and it worked much faster ! The boot of the machine was faster and in my case loading selinux policies too !
Have a look to the difference:
Without IO APIC:
[root@node2 ~]# time semodule -i percona-xtradb-cluster-full.pp real 6m3.646s user 1m34.430s sys 3m42.805s
With IO APIC:
[root@node2 ~]# time semodule -i percona-xtradb-cluster-full.pp real 0m14.611s user 0m13.829s sys 0m0.769s
To enable IO APIC from Vagrant, these are the parameters to use in your Vagrantfile:
config.vm.customize ["modifyvm", :id, "--memory", "256", "--ioapic", "on"]
On mysqlperformanceblog, I wrote on what was an easy solution to initialize a PXC cluster without modifying the configuration file (my.cnf) but only by providing a parameter to the init script. (link to that post) Unfortunately, this works only on RedHat systems (including CentOS, Fedora...
For Debian/Ubuntu, I wrote a minimal patch allowing that. The patch is attached to this post.
To track my time I used hamster-applet with the previous version of Fedora and I really liked it. It integrates perfectly with gtg.
The git repo is available here.
You can see some screenshots here.
If you enjoy or discover this cool project, I'm happy to make it available for Fedora 18.
[UPDATE] I added the packages for F19 ;-)
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.
Getting Things GNOME! has been released on November 6th but I was able to test it only tonight ;-)
So far, I'm very pleased by this release and to be honest this seems to be the first time synchronization with Remember the Milk is working (I used it on my n900 and I plan to use it know on my android.... but I need to wait 22h before next sync)
I've also installed the integration with gnome-shell very quickly and it seems awesome !
The development team as done a very nice job...
If you plan to test it, I've packaged this release for Fedora 17.
This morning Stewart announced the release of Percona Playback 0.4 (with packages).
Unfortunately, the bug I was referring in my previous post was not fixed in that release. Therefore I created again a package based on 0.4 including the patch that allows to parse slow query log with statements written on multiple lines.
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:
mysql replication listener's rpm was built using modified specs from https://bitbucket.org/winebarrel/ruby-binlog/downloads
I added the src.rpm as requested by nvidhive on #percona freenode.