Category Archives: Uncategorized

Fix Unknown table engine ‘INNODB’ error on Munin

In newer MySQL versions, if you have InnoDB disabled, Munin will fail to run giving you the following error:

root@myserver [~]# munin-run mysql_connections
DBD::mysql::st execute failed: Unknown table engine 'INNODB' at /etc/munin/plugins/mysql_connections line 958.

This is caused because the error message is changing between versions and the mysql_ plugin for munin hasn’t been updated in order to recognize it.
The fix is pretty simple, just open /usr/share/munin/plugins/mysql_ with vim on line 958 (hint: vim +958 filename) and replace as bellow.

Original code

    if ($@) {
 	        if ($@ =~ /Cannot call SHOW INNODB STATUS because skip-innodb is defined/) {
 	            $data->{_innodb_disabled} = 1;
 	            return;
 	        }
 	        die $@;

Fixed code

    if ($@) {
 	        if ($@ =~ /Unknown table engine 'INNODB'|Unknown storage engine 'innodb'|Cannot call SHOW INNODB STATUS because skip-innodb is defined/i) {
 	            $data->{_innodb_disabled} = 1;
 	            return;
 	        }
 	        die $@;

Save the file and you’re good to go 🙂

iOS 5.0.1 beta fixes battery issue

[blackbirdpie url=”https://twitter.com/#!/iMZDL/status/132175470253973504″]

In a previous post I mentioned that after installing the GM (i.e. final) version of iOS 5, I’ve seen my battery life percentage drop below 20% in a matter of a few hours. Now after upgrading to beta 1 on Thursday and beta 2 yesterday, and I can confirm that the battery issue is now fixed 🙂
My iPhone 4 now easily goes over 24+ hours after a full charge with everything enabled! (3G, WiFi, Location services etc.)

VPS.NET Japan cloud test failure – Success!

[blackbirdpie url=”https://twitter.com/vpsnet/status/116838472219770880″]

Today at around 06:30 EDT, VPS.NET engineers did a test failure at their recently launched Japan cloud and it went really well!
No downtime, no data loss, nothing. Exactly as it should work. Kudos to the VPS.NET team! I really hope that they have found the perfect solution for their SANs and that they will begin rolling-out the new technology to their other SANs soon.

Below is the output of sar, about an hour and a half after the test. The lines that indicate that something was going on (i.e. the test failure) are highlighted.

root@dev:~# sar
Linux 2.6.32-5-xen-amd64 (dev) 	09/22/2011 	_x86_64_	(3 CPU)

[...]
04:35:01 AM     CPU     %user     %nice   %system   %iowait    %steal     %idle
04:45:01 AM     all      0.00      0.00      0.00      0.00      0.00    100.00
04:55:01 AM     all      0.00      0.00      0.00      0.00      0.00    100.00
05:05:01 AM     all      0.00      0.00      0.00      0.00      0.00    100.00
05:15:01 AM     all      0.00      0.00      0.00      0.00      0.00    100.00
05:25:01 AM     all      0.00      0.00      0.00      0.00      0.00    100.00
05:35:01 AM     all      0.00      0.00      0.00      0.00      0.00    100.00
05:45:01 AM     all      0.00      0.00      0.00      0.00      0.00    100.00
05:55:01 AM     all      0.00      0.00      0.00      0.00      0.00    100.00
06:05:01 AM     all      0.00      0.00      0.00      0.00      0.00    100.00
06:15:01 AM     all      0.00      0.00      0.00      0.00      0.00    100.00
06:25:01 AM     all      0.00      0.00      0.00      0.00      0.00    100.00
06:35:01 AM     all      0.02      0.00      0.02      0.01      0.00     99.95
06:45:01 AM     all      0.07      0.00      0.04      0.24      0.00     99.66
06:55:01 AM     all      0.07      0.00      0.03      6.35      0.00     93.55
07:05:01 AM     all      0.00      0.00      0.00      0.00      0.00    100.00
07:15:01 AM     all      0.00      0.00      0.00      0.00      0.00    100.00
07:25:01 AM     all      0.00      0.00      0.00      0.00      0.00    100.00
07:35:01 AM     all      0.00      0.00      0.00      0.00      0.00    100.00
07:45:01 AM     all      0.00      0.00      0.00      0.00      0.00    100.00
07:55:01 AM     all      0.00      0.00      0.00      0.00      0.00    100.00
08:05:01 AM     all      0.00      0.00      0.00      0.00      0.00    100.00
08:15:01 AM     all      0.00      0.00      0.00      0.00      0.00    100.00
Average:        all      0.00      0.00      0.00      0.13      0.00     99.86
root@dev:~# uptime
 08:16:20 up 8 days,  4:35,  1 user,  load average: 0.00, 0.00, 0.00

VPS.NET Tokyo cloud launched

[blackbirdpie url=”https://twitter.com/vpsnet/status/113858818764570624″]

We are pleased to announce the new beta of our Japan cloud (Tokyo). We are offering old and new customers up to 9 beta nodes for free to test out the location.

Highlights include:
– The fastest, most technically advanced enterprise class SAN within all of our clouds
– Full support for Windows and Linux
– Full OnApp 2.2 support will be enabled during the beta
– Its Free!

VPS.NET just launched their Tokyo cloud today in beta. According to them, this new cloud features an all-new SAN deployment which will resolve issues like their recent (and not only) 50h downtime + customer data loss. SAN failures have been a major issue at VPS.NET during the last year and many customers who didn’t had their own backup strategy lost all their data because of file corruption after a SAN crash (hint: don’t rely on VPS.NET backups -unless R1Soft- and always have your own backup strategy!)

Continue reading