If you are tied of reading the old “text-only” output of MySQL Explain, then you will enjoy the new MySQL Visual Explain feature of MySQL Workbench (works with MySQL 5.6+).

Before:

mysql> explain select max(DepDelayMinutes), carrier, dayofweek from ontime.ontime_2010 where dayofweek = 7 group by Carrier, dayofweek\G
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: ontime_2010
type: ref
possible_keys: DayOfWeek,dw_carr,covered
key: covered
key_len: 2
ref: const
rows: 1337314
Extra: Using where; Using index
1 row in set (0.00 sec)


After:

How to test:

1. Download and Install MySQL 5.6
2. …

While monitoring MySQL servers, managing their configuration becomes important. There could be a need of comparing configuration of one or more MySQL or a server’s running configuration with that of its own My.cnf. Let me explain this a little more.

If you are in a situation where a server ‘A’ is performing better than a server ‘B’ while both have the same resources and environment, then the first thing you might want to do is compare their configuration. Then, make the configuration changes in server ‘B’ looking into ‘A’. There by fine tuning ‘B’ to level up to ‘A’. Comparing MySQL configurations is the key here.

When you change a MySQL Global variable when the server is running, for reasons like – fine tuning your application or upgrading your MySQL or any other, the changes do not persist. In other words, these changes are lost forever when the server restarts and the old values are reverted …

When SkySQL opened its doors two years ago, we purposely set out with the goal to build trusted and value-for-money services for users of MySQL and MariaDB databases. We focused on offering a quality alternative for those deploying open source systems - and we feel that we have succeeded. Our plan was to build a service business and customer base that will create a strong platform on which to develop our own products in collaboration with key customers. Red Hat is the only other successful start-up that I am aware of having taken a similar approach of first building a successful services business before developing products.

read more

In this presentation, I talk about the reason I developed a new Nagios check for MySQL while at PalminoDB, what the plugin does, how it works, how to extend it, and what its limitations are. There are some supplemental links that folks might want to know, so I am posting them here:

• PDF slides
  
• There is an excellent README for the mysql_health_check plugin.
  
• PalominoDB …

In this presentation, I talk about the reason I developed a new Nagios check for MySQL while at PalminoDB, what the plugin does, how it works, how to extend it, and what its limitations are. There are some supplemental links that folks might want to know, so I am posting them here:

• PDF slides
  
• There is an excellent README for the mysql_health_check plugin.
  
• PalominoDB …

Ethan Galstad, “father of Nagios”, keynoted NagiosWorld’s first day.

For those who are curious, Ethan pronounces Nagios as “NAH-ghee-os” – emphasis on the first syllable, the “g” is a “hard g” like in the word “good”, and a long “o” as in “ghost”.

Nagios Core – been around since 1999. Extendable FLOSS monitoring and alerting engine. What people used to just call “nagios”. Usually you have to be a technical person to install and configure.

Nagios XI – Commercial Nagios solution, built on top of Nagios core – has dashboards, web configuration, auto-discovery, advanced reports. Unlike Nagios core, it’s much easier to use.

Nagios Fusion – Centralized dashboard, can login to one place and see all Nagios XI and Nagios Core servers in your infrastructure. …

Ethan Galstad, “father of Nagios”, keynoted NagiosWorld’s first day.
For those who are curious, Ethan pronounces Nagios as “NAH-ghee-os” – emphasis on the first syllable, the “g” is a “hard g” like in the word “good”, and a long “o” as in “ghost”.
Nagios Core – been around since 1999. Extendable FLOSS monitoring and alerting engine. What people used to just call “nagios”. Usually you have to be a technical person to install and configure.
Nagios XI – Commercial Nagios solution, built on top of Nagios core – has dashboards, web configuration, auto-discovery, advanced reports. Unlike Nagios core, it’s much easier to use.
Nagios Fusion – Centralized dashboard, can login to one place and see all Nagios XI and Nagios Core servers in your infrastructure. There’s …

I've been making some improvements to our use of Hudson recently that have been really helpful.
One of this was using the matrix feature. The matrix feature is really nice, that lets you configure jobs with multiple configurations, running on multiple hosts etc. You can also set up your own User-defined axis.
Here, I would like to show how to set up matrix/multi-configuration jobs in Hudson, that I used for my project.
I was trying to set up my project for MySQL connector python. The challenge was to setup a job involving multiple variants as below

• multiple python versions,
• multiple server (MySQL) versions

and so, I chose a matrix job, that finally looked like below -

 …

It never fails. Someone manages to break their Pacemaker cluster, and Henrik starts preaching his usual sermon of why Pacemaker is terrible and why you should never-ever use it. And when that someone is GitHub, which we all know, use and love, then that sermon gets a bit of excess attention. Let's take a quick look at the facts.

read more

It never fails. Someone manages to break their Pacemaker cluster, and Henrik starts preaching his usual sermon of why Pacemaker is terrible and why you should never-ever use it. And when that someone is GitHub, which we all know, use and love, then that sermon gets a bit of excess attention. Let's take a quick look at the facts.

read more