Taming MySQL is… challenging. Especially in very large, fast-growth, ‘always-on’ environments. It’s one of those things where you seemingly can never know all there is to know about it. That’s why I really like coming across posts like this one from FreshBooks that describes a very real problem that was affecting their users, how they…
Category: Linux
I’m a Top 25 Geek Blogger… for some value of “Top”
I’m not someone who wakes up every day and looks at how my blog is ranked by all of the various services. I check out my WordPress stats, but that’s really about it. However, someone went and did some of the work for me, and they’ve decided that, of the blogs that they read or…
Stop Doing Things That Don’t Work (a.k.a: Excel and Virtual Private Servers are Evil)
Note that I’m talking about using these tools in some kind of professional way, and more specifically, I’m talking about using Excel as a database, and using VPS hosting to host “professional” web sites. By “professional”, I mean something other than your personal blog, picture gallery, or other relatively inconsequential site. Excel is not a…
By popular demand: ReportLab Sample Document
I posted here last week about using ReportLab to generate very simple reports with a chart and code sample. I got several requests for screenshots, but what fun is that? Here’s the PDF… gfe.pdf
Clone a table in MySQL without killing your server
So, I recently ran into one of those situations where a customer complains that his MySQL database is slow, and “it worked great until about two weeks ago”. The first thing I look at in these situations is not the queries or any code, but the indexes. Once I determined that the indexes were almost…
Sustained IO on EBS == No Bueno
I have a small EC2 instance running with a 25GB EBS volume attached. It has a database on it that I need to manipulate by doing things like dropping indexes and creating new ones. This is on rather large (multi-GB, millions of rows) tables. After running one DROP INDEX operation that ran all day without…
Is it time to switch VM apps on OS X?
Thought I’d throw this out to the lazyweb for advice. I’ve been running OS X as my primary desktop OS since I got my macbook pro around May 2006 or so. I installed Parallels as soon as I found it, and it was great. I still have it installed. However, I’ve found two issues with…
The promise of Drizzle
I got to actually speak to Brian Aker for maybe a total of 5 minutes after his micro-presentation about Drizzle, which took place at the Sun booth at OSCON 2008. I was a bit nervous to ask what questions I had out loud, because the things I had wondered about were things I really didn’t…
OSCON Day 2: Launching a Startup in 3 Hours
Launching a Startup in 3 Hours was a great talk given by Andrew Hyde (of techstars.org) and Gavin Doughtie (of Google). Both of the speakers are heavily involved in the recent trend of doing “Startup Weekends”, and techstars.org is an organization that hosts startup weekends all around the US (and I think internationally as well…
OSCON Day 1 Comes to a Close
I think I have pictures of most of the basic parts of the conference at my OSCON Flickr set, and I thoroughly enjoyed day 1 of the conference. Of course, while *day* 1 is over, *night* 1 has yet to even begin. There are lots of BoF sessions, and maybe even more smaller meetups going…