QA Help Wanted
MySQL Sun Oracle needs QA help. How do I know this? Because I’ve used their products.
We use MySQL 5.1.x “Enterprise” on several servers at work. We have several production servers that are replicated to slave servers as hot spares, reporting servers, and to a disaster recovery server. As part of our setup one of our backup servers needs to replicate from two different servers and databases to two different local databases. So, I need to run two instances of MySQL. There are three basic ways to accomplish this: run two instances of MySQL directing each to a different configuration file with appropriate port, directory, pid file settings; use mysqladmin to manage multiple instances; use mysqld_multi to start multiple instances. Mysqladmin has been deprecated and will be removed in 5.4, so I’m not investing energy in that solution. Option one will work, it just means more files to manage. Mysqld_multi allows using a single configuration file with definitions for each server instance. It’s straightforward and pretty easy to set up.
Mysqld_multi is a Perl script that parses a single config file containing multiple server instance definitions. There is just one problem. It doesn’t work. It throws the following error:
Unmatched right curly bracket at /usr/bin/mysqld_multi line 171, at end of line syntax error at /usr/bin/mysqld_multi line 171, near "}" Execution of /usr/bin/mysqld_multi aborted due to compilation errors.
As a programmer, and sysadmin, I expect that an error like that must be the result of some combination of version incompatabilities or poor configuration. Since I had just upgraded MySQL to the latest version this made sense. I updated all the packages on the server, rebooted, tried again.
Unmatched right curly bracket at /usr/bin/mysqld_multi line 171, at end of line syntax error at /usr/bin/mysqld_multi line 171, near "}" Execution of /usr/bin/mysqld_multi aborted due to compilation errors.
After way too much effort I pulled the script into a language aware editor and found that the script did, in fact, have an unmatched right curly bracket. I removed it. I ran it again, thinking that this couldn’t possibly be the problem. A large technology company like Sun Oracle wouldn’t let a product out the door with this kind of fundimental bug. They must have run this script at some time and found this error. No, they didn’t. Once the errant bracket was removed, the script ran. Perfectly.
Coincidentally, I just received our quote from Sun Oracle for “enterprise” support for MySQL. Seems kinda high.
I Believe!
Have you seen this article? True believers: The biggest cults in tech. IT and technology folks are very partial to thier toys. We latch onto computers, programming languages, operating systems, and are adamant about thier superiority. Reading this article brought back many memories of my various IT objects of worship.
I owned both a Commodore VIC-20 and C-64, worked in a computer store selling C-64s, C-128s, and Amigas. I lusted after the PET and the Amiga. And I made my first consulting fee writing software for the C-64. Even then I was starting my path in the cult of Pascal. First there was VAX-11 Pascal, then Kyan Pascal, MS QuickPascal, Turbo Pascal, and finally I entered the temple of Delphi. I’ve owned 5 different Palm handhelds. And, I just bought a new Ruby IDE (Ruby Mine) to go with that addiction. I also belong to the Linux, Mac, and Android cults.
Outside of IT, I’ve owned pretty much nothing but Canon cameras since my FTb-QL in 1977.
I think it is similar to the car guy who will own nothing but a Chevy or Ford. We all want to be right, and we hang out with those who agree.
So, what cults do you belong to?
Linux Loses My Desktop
Okay, I give up.
As i’ve written before, I’ve run Linux (SUSE) on my personal desktop and home servers for several years prior to moving to the Mac. I still run Linux for my home server. The only Windows computer I have running at home is my kid’s computer. They have games that won’t run elsewhere.
I installed Ubuntu 8.10 on my office desktop in a dual boot configuration. It handled my dual monitors, quad core CPU, 4Gb of RAM without a hitch. But what it couldn’t handle was working in my office. Now, I had no problem administering our dozen or so Linux servers, reading/writing Word, Excel, Powerpoint documents. I had no problems dealing with our various Java applications, or accessing data on our office network. But, two things have made a permanent conversion difficult, at best. Number one is Exchange/Outlook. I wrote about this earlier. Interacting with Exchange via Linux is painful if you use Exchange calendaring, contacts, or anything other than mail. There is no good way to interact with Exchange calendaring in Linux. Number two is somewhat surprising. As part of a server upgrade project we have adopted Citrix XenServer to handle server virtualization. This is based on the Linux-based Xen project. You would expect it to be very cross platform. You would be wrong. The management tools are Windows only. So, it uses a Windows only management console to manage Linux based hypervisors with Linux guest virtual machines.
Interestingly, both of these observations have been commented on in the last few days:
Where are the Enterprise Management Tools for Linux on the Desktop? by David Lane
What would you exchange Exchange for? by Doc Searls
So, I’m not alone.
I think as desktop virtualization matures, it will be easier to run the desktop of your choice. I use VMWare Fusion on my Mac to run Linux, Windows, and even Haiku. The downside for Linux is there will be less of an incentive to develop the replacements for Outlook and the enterprise management tools. There will also be fewer requests for those applications from corporate users. Why wait for the open source equivalent when I can run the Windows version in a virtual machine.
In the meantime, it’s back to XP. I’ve got work to do.
Exchange is the Key to the Enterprise
As an IT manager, I have to make various decisions that affect the operation of my employer. One decision I was able to make was what OS I would run on my desktop. We run a number of Linux servers, most of our desktops (except for the graphic artist’s Mac) are running Windows XP. Personally, I have a MacBook Pro, and I run various Linux distributions via VMWare Fusion. The workstation I inherited is quite nice, 4GB RAM, 250GB RAID 1 15K SAS, Quad core 2.4Ghz processor, dual LCD monitors. Way too much PC for a manager. We, like many (most?) enterprises rely on Microsoft Exchange and Outlook for our email and calendaring.
I am not a fan of Windows. For the last several years, the only time I used Windows was at work. Until now, I didn’t have the authority to choose otherwise. I decided about a month ago to switch my OS to Linux. Of course that means choosing a distribution. I used SUSE for several years, and was happy with it. So, I decided to load openSUSE 11.0 on my desktop. It was a painless install. openSUSE was considerate enough to make room for itself and leave room for Windows and set up dual boot. Very nice.
Time to boot up. Ok, I have two identical desktops running mirrored on both monitors. I find the desktop/monitor settings and set it accordingly. And it doesn’t work. No matter what I tried, I couldn’t get openSUSE to correctly span my desktop across both monitors. It insisted on mirroring on both. That sucks. I got tired of screwing with openSUSE, and fired up the Ubuntu 8.10 install. I did have to intervene so it used the existing partition setup, but that was not a big deal. The install proceeded normally. I booted up and was met with a desktop that correctly spanned both monitors without intervention from me. Perfect. Ubuntu wins.
I have used OpenOffice (and NeoOffice) for several years. I have never had a situation where it couldn’t do what I needed, and interoperate with MS Office. But, I need to interoperate with Exchange. So, I installed Evolution and set it up to work with our Exchange hosting provider.
Evolution seemed like a good solution. It has many of Outlooks features, it sets up quickly. But, it stinks. It’s slow syncing mail. It would frequently freeze when trying switch to the calendar while mail was syncing. And the calendaring synchronization is terrible. It’s slow, it’s unreliable, and it only works with Outlook Web Access.
So, I loaded Thunderbird for email (using IMAP) and I update my calendar by hand.
Every year for the past 6 or 7 has been declared the year of the Linux desktop. The year it takes over the office. It’s not going to happen. Not until the Linux community recognizes and addresses the real obstacles to widespread adoption, MS Office and Exchange. OpenOffice addresses the main components of MS Offices (except Access, but there are substitutes for it). And OO works well. But, Exchange is entrenched in most enterprises, and it won’t be dislodged easily. Sure, there are alternatives for Exchange, IMAP/POP3 servers, iCal servers, etc. There is NO good way to inter-operate with an existing Exchange environment. And without one, Linux cannot make significant inroads in existing enterprises.
In the meantime, I am loading Windows XP as a VirtualBox VM so I can run Outlook.