« October 2007 | Main | January 2008 »

December 19, 2007

Remove Mirror Effect on Leopard Dock (Cleaner Look)

While the new 3D dock that comes with Apple's OS X Leopard is flashy, I find it hard to quickly understand what the dock is supposed to tell me. The two problem areas are (1) that it reflects things that are near it on the desktop and (2) the indicator that an application is running got changed from the simple triangle icon to a white dot which is hard to see on the white dock surface.

Here's my dock:

The reflections of my application windows make the dock look cluttered. And it isn't immediately obvious which programs are running because the white indicators get lost.

So I've poked around and discovered that you can easily shut off the reflectiveness of the dock, with a simple command-line option:

defaults write com.apple.dock no-glass -boolean YES

Doesn't this look much better?

Definitely not as slick, but so much easier to quickly see what is there and active.

Posted by mike at 9:23 AM

December 7, 2007

Fixing Broken MySQL Database Replication

And just as I was saying I rarely get to fiddle with databases at work, this morning I resolved an issue with replication.

One of our database machines got rebooted yesterday without properly shutting down replication. The slave server had no idea this was happening. After looking around a bit it seems clear that MySQL on the master has moved to recording changes in a new log file, but the slave is still attempting to read from the old.

Which results in something like:

Slave_IO_Running: No
Slave_SQL_Running: Yes

After verifying the log positions in master and slave binary log files to confirm exactly where things stopped, I shut down the slave processes altogether and issue a command to point the slave to the new log file and reset the log position:

mysql> CHANGE MASTER TO MASTER_LOG_FILE='data15-bin.000030', MASTER_LOG_POS=4;

Start replication back up, the slave scrambles a bit to get caught up, and we're back to another period of not having to do anything to keep MySQL running.

Posted by mike at 9:42 AM

Where's Mike and MySQL?

Have been thinking about my lack of postings . . . there are two reasons why posting about MySQL (and in general) has become rare in recent months.

First, and primarily, it is because of life changes. Where I used to have a moment here and there to write what was happening or on my mind, I'm barely able to post about anything these days. The whole time and season thing seems to be at play here.

Second, I just don't spend that much time fiddling with MySQL. It used to be that my work brought up lots of interesting things related to the database. I'm still the resident MySQL guy at my current job, but it's rare that something comes up that requires database expertise. And it's not that we're lightweights. We have a very high-volume system with a farm of database servers doing some pretty intense business/enterprise-level querying. We just don't find many issues that require attention down at the database level.

Some folks might wonder if I've run off in a different direction because of these concerns. Not true.

Posted by mike at 9:07 AM

December 6, 2007

Headed to MacWorld 2008

macworld_keynote.jpg I just made the necessary arrangements (flight, hotel, conference pass) to attend MacWorld 2008 in San Francisco.

It has been a dream of mine for some time (documented in 2005) to get out there and be a part of the action. I guess the thing I'm most excited about it seeing Steve Jobs delivering the keynote in person, but there's also a ton of good content throughout the week.

Will be a little different reading the speculation this year. Will no doubt be posting photos and comments about the weeklong event.

Posted by mike at 5:48 PM