Archive for November 2006

Linux (performance, server, security) related book reviews

I took a vacation recently, which involved heading down to Hobart, for some rest & relaxation. And lots of food (read: oysters, seafood, yum!). I packed my suitcase with some books for some late night reading, and am pleased to provide some form of review.

Linux Server Hacks by Rob Filkenger was definitely interesting. I’d say I found at least 1/4 of the hacks useful, with others probably being common sense (or maybe I already knew them). There were some useful scripts, and overall while this book doesn’t earn a keeper on my shelves, I did take away some useful bits and pieces: xargs tips, looking for setgid/setuid binaries, hdparm tuning, rsync backups, iptables fun, a tool called vtund that I’ve never used, ntop, their very own httptop, and a few more.

Linux Performance Tuning and Capacity Planning by Jason R Fink and Matthew D. Sherer had some rather basic and shallow information, that you’d have learnt as part of the LPI Level One certification at least. There was a section on network tuning as well, which is important with things like NFS. I was hoping I’d see some details about AFS (because I know a very large install base), alas zilch. But there are good bits of basic information, like if you’ve ever wondered what RSS means from the ps output? A good introduction to LVM exists; this book was published in 2001, you hardly notice much about IPV6 in their networking chapters. And afaik, TCP ECN has been enabled by default for a while – sure it caused misery for a while, its all good. This isn’t a keeper on my packed bookshelf.

Linux Security Cookbook by Daniel J. Barrett, Richard E. Silverman, and Robert G. Byrnes seems to be woefully out of date, but maybe its because it was published in 2003. I found the examples of creating PAM-aware applications useful, and there were some good tips about sudo (have you thought that restricting su to a sudo user would be a secure solution? Apparently it isn’t, thought combined with SELinux I’d think otherwise). Yet another non-keeper for the bookshelves, though it’d be helpful if there existed an updated review copy covering SELinux, AppArmor (of which I know nothing about) and a whole lot more new happenings in the last three years.

What I did find as a keeper was: Optimizing Linux(R) Performance: A Hands-On Guide to Linux(R) Performance Tools (HP Professional Series). I’ll review this later as I soak up more of the text.

Technorati Tags: , , , ,

Core Data and MySQL as a data store?

I’ve been thinking a lot about Core Data recently. It supports SQLite out of the box, and its rather scalable and fast. Main reason being sqlite3 is included on every desktop and server of OS X that has shipped since 10.4 (Tiger).

It got me thinking about using MySQL as a data store. It will involve work, as Core Data itself is not extensible. And if written, will we have to embed MySQL into the application? What kind of problems will this pose? Licensing is the least of my worries, I’m thinking more from an application perspective.

I haven’t played with the Enterprise Objects Framework (EOF) yet, but it allows custom SQL, and is available in WebObjects so its probably time to take a gander. Only real problem is its not in Core Data, thus not available in desktop applications. Then there’s AJRDatabase which allows you to use EOF via Objective-C, which seems to be the missing link.

And then, why MySQL? Because it might be cool to use FEDERATED tables? Especially if FEDERATED is extended to allow local modifications…

Some useful resources: Core Data as a Cheap Database, CoreDataWish.

Technorati Tags: , ,


i