I prefer to install mySQL using the pre-compiled binaries. Depending on the environment, these usually go in either /opt or /usr/local. When you choose this type of install, chances are you are going to need to ensure that you somehow configure your system so that the mysql binaries end up in your PATH. If you are [...]

There are quite a few business angles you might see only if you’re here at the conference, and you won’t get from blogs. For example, let’s take a look at the contents of the shoulder bags they hand out with your registration. (This is only a partial list.)

• SnapLogic’s flyer gets it right: their system is compatible with “GNU Linux.” Hooray, a commercial company acknowledging the GNU operating system for what it is!
• MySQL Enterprise’s flyer has three big bullet points: MySQL Load Balancer, MySQL Connection Manager, and MySQL Enterprise Monitor Query Analyzer. The first two look like they’re probably built on MySQL Proxy. The last has a visual explain plan feature, which according to an elevator conversation is not yet built. I’ll stop by their booth and see. As you may know, Maatkit has provided a tool (which is designed for integration into other tools) …

Earlier this week I attended the Linux Foundation Collaboration Summit, serendipitously held here Austin.  It was a fantastic opportunity to meet a lot of the people in the community whom I hadn't met before as well as to catch up with old friends.

 
Maddog (R) helping Executive Director Jim "Led" Zemlin to Flourish 

Great Speakers
(and I'm not talking Bose, which really aren't great speakers anyway)

There was an impressive line up of panels and speakers the first day of the summit …

I've decided to start replacing L with GL in acronyms where L supposedly stands for Linux.

I'm not a big user of acronyms, because I think they are exclusionist and they obscure, rather than revealing. (This wouldn't matter if I wrote for people who already knew what I meant and agreed with me, but that's a waste of time). However, LAMP is one that I've probably used a few times, without thinking that it is supposed to stand for Linux, Apache, MySQL, and PHP/Perl/Python. In fact, it doesn't refer to Linux, it refers to GNU/Linux. Therefore, it should be GLAMP.

Why does this matter? I try not to say Linux, unless I'm referring to a kernel, because a kernel is not an operating system. I try to be pretty careful about saying GNU/Linux when I'm talking about an operating system. An exception is a recruiting event yesterday at the University of …

Last week I wrote about my efforts to measure MySQL's replication speed precisely. The most important ingredient in that recipe was the user-defined function to get the system time with microsecond precision. This post is about that function, which turned out to be surprisingly easy to write.

Last week I read two books on Nagios. I found one easy to use and the other difficult.

I wrote a post recently that focused only on things I see as shortcomings or problems with Gentoo GNU/Linux. That was the intent of the article, to explain why I switched to Ubuntu for my personal systems. On the flip side, nothing's perfect, but nothing's perfectly flawed, either. There are still many things I like about Gentoo.

I wrote a while ago about a program I wrote to export GnuCash data into a MySQL database, including a couple of queries against the resulting schema. I've made some improvements since then to allow a simple overlay of my wife's expense categories onto the GnuCash hierarchy. This article explains the improved schema, and includes some more useful tools and queries.

Some people who know I've used Gentoo asked me my thoughts on using it for MySQL servers. Here are my opinions and experiences using Gentoo, both for desktop systems and for servers.

Glom is an interesting graphical database front-end I've been meaning to try out for some time. Someone asked about graphical database front-ends on the #mysql IRC channel recently, and that prompted me to install Glom and learn how to use it. My overall impressions? It lands squarely in the middle of its target audience's needs, but still has a quirk here and there. With a bit of polish it will be a fine product, and it's already a winner over Microsoft Access and Filemaker, two similar programs with which you might be familiar. In this article I'll walk through installing and configuring Glom, a simple database design, a quick peek under the hood, an archaeologist's experiences using it, and give my opinions about Glom in detail.