Copyright ©1997-2011 Glenn Fleishman except as noted otherwise. All rights reserved. For permission to reprint, contact Glenn Fleishman at glenn at glennf.com. Photo © 2008 Laurence Chen; used with permission.
Turning technology from mumbo-jumbo into rich tasty gumbo
I just came up with the perfect tagline for the new Hitchhilker’s Guide to the Galaxy (HHGG) movie for which the preview is now available based on that preview:
A film almost entirely but not quite unlike the book.
That’s a compliment by the way.
For all of my regular reader (sorry, old joke) the big news for February and Ben’s six-month birthday is that he now sleeps unswaddled. Let angels sing and cherubim frolic. A big transition for us, and apparently of little significance to him; he’s busy sleeping. I’ll post more updates on Ben’s beaming face, his ability to sit unsupported, and his one (so far) unassisted roll from stomach soon.
This one goes out to the MySQL administrators out there who were baffled, like me, why when they upgraded through their normal process from 4.1.8 to 4.1.9 (or to 4.1.10) their invocation scripts broke given them strange and annoying errors. The reason is that the MySQL developers changed the context into which mysqld is launched via safe_mysqld. I’m writing this post so it can be found with a clear answer (much clearer than is documented over the MySQL developer’s site) on how to fix it.
I have two instances of MySQL running on a dual-processor machine in order to balance load. This made a large difference when I split up databases of equal utility among them. So I invoke them by defining a my.cnf file in /etc/ with settings applicable to both, and then I have a my.main.cnfand my.second.cnf set of files that are particular with ports, sockets, and other details.
I invoke mysqld as
Now this stopped working when I upgraded from 4.1.8 to 4.1.9. I stepped backwards assuming a bug and didn’t have time to deal with it. The other night I tried to jump to 4.1.10. Same problem. I start reading bug reports and resolutions and release notes and find an obscure note about the data directory being resolved to a path relative to mysqld if mysqld is invoked via mysqld_safe through a relative means. This didn’t make complete sense as I had defined the datadir in my .cnf files.
But there you go: I had to add an explicit —datadir declaration into the safe launching:
mysqld_safe —defaults-extra-file=/etc/my.main.cf —datadir=/path/mysql
mysqld_safe —defaults-extra-file=/etc/my.second.cf —datadir=/path/mysql_second
Then it worked. Really frustrating, and it took me about 45 minutes to sort it out because the behavior is inconsistent. I’m not sure whether it’s a bug or just something that you can no longer define within a .cnf file. I’ve added a note to the bug report to see whether they’ll either deprecate use of datadir within configuration files or fix this problem.
When you pull 30 miles of Ethernet into a new facility, you wind up with a comfortable pile of snipped ends, good for sleeping on at 2 a.m. while servers are rebooting (according to my co-location facility’s CTO).
My co-lo is digital forest, and they’re moving from the outskirts of town up northeast, where they’ve resided in sleepy Bothell, to the edge of Seattle—literally as the southern border of town touches their server room’s edge—in a spanking new building. Spanking new in 2001, that is, when the tenant who had the building constructed went belly up, leaving it mostly empty for four years.
I took pictures with their permission of my tour. You can follow the saga of moving hundreds upon hundreds of active servers on a procession across the lake and down the highway in the wee wee hours every night for weeks on their Support blog. It’s gotten quieter as they’ve moved virtually all of their hosted boxes that they talk about publicly and are now moving client co-lo boxes (such as mine) which they don’t broadcast the identity of.
I feel for them. The technical staff hasn’t had much sleep in weeks and the migration continues until mid-March.
If you’re looking for a very well-priced co-location facility with top-notch people, I recommend these folks unhesitatingly. They’re responsive, interested in finding a solution, and their prices are damn fine. The new facility is even higher tier than their last.
It’s terribly hard to get rid of old Macs, because I love them so. However, I’m about to do a big swap.
Out: I swore I’d never sell it, but the G4 Cube no longer meets my needs as a potential home entertainment centerpiece after some months spent running Mac OS X Server in the office. It’s being sold, as cool as it is, because it’s still a good machine and needs to find a good home.
In: Mac mini! It’ll be our music, video, DVD, CD player for the near future fitting nicely in our entertainment console. At some point, when we upgrade from CRT to LCD for our TV, we’ll find the DVI interface quite nice.
Out: Power Mac G4 upgraded from 450 MHz to 850 MHz with FireWire 800 added. My brother in law needs an upgrade from his blue-and-white G3, so that’s a good move for the G4. The G4 has been the office server, handling backups and faxes among other tasks, for several years. Its backups have paid for themselves several times over through a number of disasters that it’s helped me recover from. But it’s big.
In: G4 Xserve. This machine was, for a while, running parts of isbn.nu and other systems, but it was ultimately not fast enough as a workhorse system. It’s a little too specialized. I’m bringing it from my co-location facility back into my office to fit onto a nice rack I already have in place where it will run backups, and be a testbed as Mac OS X Server 10.4 (Tiger) appears, which I will write about for various publications. It’s a nice dual 1.33 GHz G4 system, so it’s got a lot of life left in it. Plus, I bought a software subscription for it that expires Oct. 2006, so I’ll get at least Tiger at no additional cost. It originally ran Jaguar, so I’ll get $2,000 worth of software out of a $1,000 subscription.
Out: Two Linux boxes. I might drill through the hard drives instead of wiping them to avoid years of data remaining even faintly on the disks, but the old isbn.nu box, which has practically no duties at the moment, will retire. Likewise, a replacement system I built in the event of emergencies from new parts will settle into a Craig’s List posting for whomever needs a nicely priced, never-used Windows or Linux system. The Xserve will answer for the working box’s meager requirements.
In: A spanking new somewhat expensive database server. This will be my third Linux box from Penguin Computing that will reside at the very fancy new digs of digital forest. In fact, my other two boxes are moving on Wednesday night, I believe, and my new machine should arrive later this week to join them. The core needs of isbn.nu are database operations, and the new system will be powerful enough to handle the load. Related to this is that I need a machine solely to build new databases that isn’t a production system on which users depend. This move will dramatically speed isbn.nu performance and make it even easier to keep data fresh.
I was interviewed via email by Darren Rowse of problogger about my propensity for entrepreneurial blogging. Here’s my lengthy response to his questions.
This is not a doctored screen capture.
I wrote Cory Doctorow the other day “complaining” that I would have random interesting ideas flit through my head and realized they were all snippets from his intriguing fiction (and sometimes non-fiction). He response: “pwned!”
I was almost “pwned” last Sunday and yesterday when a flaw in awstats 6.2 and earlier, the program I started using partly because of Cory et al. at BoingBoing to perform traffic analysis, allowed a bunch of Brazilians to pwn sites all over the Internet. Luckily, the root kit—a prefab package for taking over a Web server when you have local user access—disabled all access to my computer when it ran rather than allowing access. A later check using rkhunter found no rootkits or replaced binaries. But I’ll be watching.
By the way, I don’t believe there’s a connection between the theft of my credit card number and the attempt to take over my machines. I don’t store credit card information on those servers, including my own.
Somebody managed to steal the Amazon.com credit card number my wife and I use. Was it YOU?
I’m pretty careful about online purchases, but it’s possible it was a real-world copying down. The credit card company noticed strange charges and an attempt to change the address to Brooklyn.
Also interesting: on Feb. 1, the card was charged by AOL and eFax for $1 each. The fradulent charges showed up on Feb. 9. I’m guessing that this is a common technique to ensure a valid card number. But it makes it easier to pinpoint the thieves, and I imagine the credit card companies use that information pretty well. And there’s an address in Brooklyn where merchandise was going to be sent to that will be full of cops (or credit card private detectives) soon.
A few days after covering the flurry of activity around the New Millennium Research Council’s report discouraging municipal broadband (over at wifinetnews.com, I was asked to moderate a panel on the discussion on March 14 during the South by Southwest (SXSW) music, arts, and interactive festival and conference in Austin, Texas. Esme Vos is also on the panel, from MuniWireless.com, and we should have a rip, and might I add, roaring time. The interactive part of the event runs March 11 to 15; the overall event is from March 11 to 20.
I love this latest idea from Amazon.com: pay $79 per year and you get two-day shipping on everything you buy with no shipping charges per item. If you join “Amazon Prime” (reminds me of the Bezos Prime joke from Mike Daisey’s 21 Dog Years: Doing Time @ Amazon.com) you can upgrade to overnight shipping for $3.99 per item.
They even offer to ship stuff out for next-day delivery if ordered by 6.30 pm Eastern. This reminds me of those glory days in the early 1990s when a few Macintosh firms had insane overnight delivery by co-locating warehouses with an Airborne Express hub in Ohio. Was it MacConnection? I’m blanking out on which ones offered this.
A few times, I would order right up against their late-night limit—I think it was 2 a.m. Eastern—and receive the item by 10 am the next morning (Pacific). Tremendous.
Now, I’ll sign up for Amazon Prime. It will absolutely save me shipping costs. (I can add my wife, too: the Terms of Service say so! “…you may also invite up to four eligible family members living in your household (at the same address) to register for Prime membership at no extra cost.”) I have had to order a few 2-day and overnight items in the last year; shipping for those items was probably $40 or more alone. And many times, I choose the ground delivery not Super Savings (free over $25) because I need something in a few days, not an indeterminate period of time that might be two weeks.
October 2011 | August 2011 | June 2011 | May 2011 | February 2011 | December 2010 | November 2010 | October 2010 | September 2010 | August 2010 | July 2010 | June 2010 | May 2010 | April 2010 | January 2010 | December 2009 | November 2009 | October 2009 | September 2009 | August 2009 | July 2009 | May 2009 | April 2009 | March 2009 | February 2009 | January 2009 | December 2008 | November 2008 | October 2008 | September 2008 | August 2008 | July 2008 | June 2008 | May 2008 | April 2008 | March 2008 | February 2008 | January 2008 | December 2007 | November 2007 | October 2007 | September 2007 | August 2007 | July 2007 | June 2007 | May 2007 | April 2007 | March 2007 | February 2007 | January 2007 | December 2006 | November 2006 | October 2006 | September 2006 | August 2006 | July 2006 | June 2006 | May 2006 | April 2006 | March 2006 | February 2006 | January 2006 | December 2005 | November 2005 | October 2005 | September 2005 | August 2005 | July 2005 | June 2005 | May 2005 | April 2005 | March 2005 | February 2005 | January 2005 | December 2004 | November 2004 | October 2004 | September 2004 | August 2004 | July 2004 | June 2004 | May 2004 | April 2004 | March 2004 | February 2004 | January 2004 | December 2003 | November 2003 | October 2003 | September 2003 | August 2003 | July 2003 | June 2003 | May 2003 | April 2003 | March 2003 | February 2003 | January 2003 | December 2002 | November 2002 | October 2002 | September 2002 | August 2002 | July 2002 | June 2002 | May 2002 | April 2002 | March 2002 | February 2002 | January 2002 | December 2001 | November 2001 | October 2001 |