This is the first of a handful of posts to augment the presentations I gave at Java One and Silicon Valley Code Camp earlier this month.  It seems I significantly overestimated how much content I could effectively deliver in the time allotted, and left a few of my major points untouched.  These blog posts will try to rectify that.

The first major area I failed to cover in depth was really “Extension Points”, starting from slide #56.  There are four major extension points in Connector/J:

• Lifecycle Interceptors
• Statement Interceptors
• Exception Interceptors
• Loadbalancing Strategies

We’ll look at the first in this post.

Connection lifecycle events can be useful for instrumenting or debugging …

To build MySQL Workbench one would need to install dependencies, fetch source code, configure it and actually do a build.

Note: On a Core2 Quad 2.4 GHz and a 4G of RAM it takes about 30-40 minutes to build Workbench. Also it uses about 4.2G of hdd space to build.

Here are steps to build Workbench on Ubuntu/Debian:

1) install deps. It is better to use terminal. The command to install deps is below:

sudo apt-get install build-essential autoconf automake libtool libzip-dev libxml2-dev libsigc++-2.0-dev libglade2-dev libgtkmm-2.4-dev libglu1-mesa-dev libmysqlclient15-dev uuid-dev liblua5.1-dev libpcre3-dev g++ libglade2-dev libgnome2-dev python-pexpect libboost-dev libsqlite3-dev python-dev libgnome-keyring-dev libctemplate-dev

2) Get source code from http://www.mysql.com/downloads/workbench/

3) unpack downloaded archive …

Installing Apache2 With PHP5 And MySQL Support On Ubuntu 11.10 (LAMP)

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an Ubuntu 11.10 server with PHP5 support (mod_php) and MySQL support.

In 5.5, a crashing, regression bug exists if you use SELECT COUNT(DISTINCT) *and* one of the WHERE operands is in the Primary Key (or just a unique index).

This simple crash (if only one row is in the table) will crash mysqld.

Of course I’ve filed a bug report, but that has been nearly 3 months and no updates yet.

Here is the bug I filed (which you won’t be able to view):

http://bugs.mysql.com/bug.php?id=61842

Really, the only thing that happened to my bug report was that it was designated a duplicate of another bug (which we also cannot view):

http://bugs.mysql.com/bug.php?id=61101

Based on the id, and the submitted dates of bugs 61100 and 61102, this initial bug (61101) was filed on May 9, 2011. So, in fact, this bug has been present for over …

Data Node Restarted alert

About 11 months ago I described the MySQL Cluster functionality that was added to MySQL Enterprise Monitor 2.3; this new post is intended to just bring this up to date – briefly describing the new graph and advisors which have been added since then (up to and including MEM 2.3.7).

Cluster Data Node Has Been Restarted

This new alert flags when a data node has been restarted (by default it alerts on any data node that has started in the last 10 minutes but you can change that interval if you wish). If you manually perform a restart (e.g. as part of a rolling upgrade) then you can safely ignore this alert (or you may even want to temporarily unschedule …

I’m speaking at Percona Live, LinuxCon Europe, and linux.conf.au. And I just co-founded a new company.

I have a few busy weeks behind me, and even busier weeks ahead. If you’ve been wondering why recently I haven’t been updating this space too frequently, here’s why:

Yours truly and fellow ex-Linbiters Martin Loschwitz and Andreas Kurz have recently founded hastexo, an independent professional services organization focused on open-source high availability and disaster recovery. We are already offering both on-site and …

We have seen many reports about broken build and freezes which are experienced on Ubuntu 11.10. While the build fix was pretty simple, the freezes took us a bit more time to hunt them down.

The point is that MySQL Workbench relies on glib’s idle signals which are emitted when Gtk’s main event loop has nothing to do. In Ubuntu 11.10, for some reason, for certain types of windows we use, these idle signals are not emitted cause window drawing code constantly reschedules idle redraws.

The bug report which is related to the freezes and compilation problems is at http://bugs.mysql.com/62347

Here is a link to the patch: is http://bugs.mysql.com/file.php?id=17639

SkySQL executives and a number of its partners have been invited to share their insight and expertise on MySQL® technologies and trends during the Percona Live UK conference speaking program, including:

• "Linux & H/W Optimizations for MySQL", Yoshinori Matsunobu (DeNA), Oct. 24, 9:00AM

• "The SkySQL Reference Architecture in Action", Ivan Zoratti (SkySQL), Oct. 25, 2:30PM

• "Why MariaDB?", Colin Charles (MontyProgram AB), October 25, 3:30PM

Use discount code "PLUK11sky" and save 40 GBP when you register.

SkySQL executives and a number of its partners have been invited to share their insight and expertise on MySQL® technologies and trends during the Percona Live UK conference speaking program, including:

• "Linux & H/W Optimizations for MySQL", Yoshinori Matsunobu (DeNA), Oct. 24, 9:00AM

• "The SkySQL Reference Architecture in Action", Ivan Zoratti (SkySQL), Oct. 25, 2:30PM

• "Why MariaDB?", Colin Charles (MontyProgram AB), October 25, 3:30PM

Use discount code "PLUK11sky" and save 40 GBP when you register.

Please note: This Blog was updated with a few clarifications on October 21st 2011.

As we announced in the release Blog for SQLyog version 9.3 we here publish instructions and tools for localizing SQLyog.

To understand how localization works you should first open the SQLyog 9.3 installation folder on your system. Inside it there is a (SQLite) database file named “L10n.db”. It contains all strings in all localizations distributed by us (currently English and Japanese) displayed by SQLyog GUI. If you have selected to run SQLyog in a non-English language SQLyog will load the localized strings from this file and use them for display and not the English strings.  To enable more languages just copy an updated “L10n.db” file with support …