Archive for October, 2008

review: Backup & Recovery by W. Curtis Preston

Just finished up O’Reilly’s Backup & Recovery by W. Curtis Preston.  The title is wide-reaching, covering backups at the operating system as well as on all the popular database platforms, including Oracle, MySQL, Postgres, Sybase, SQL Server and DB2.  Preston has an amazing grasp of a spectrum of technologies and platforms, and as an Oracle & MySQL DBA myself, I’d use this as my backup reference text any day.

I’ve posted my review of Backup and Recovery over at Amazon.

Wednesday, October 22nd, 2008

review: Oracle Essentials 11g - O’Reilly

Just had a chance to read O’Reilly’s introductory book on Oracle 11g, Oracle Essentials.  I thought it was quite good and gave it four out of five stars.  Take a look at my review of Oracle Essentials on Amazon.com.

The book covers a wide range of topics, and is one part new features, one part Oracle 101, and one part summary of all of the Oracle products.  It is primarily targeted to DBAs, Developers and System Administrators, albeit on the novice side, however it’s writing style, and technical depth are not unweildy, so IT managers, and business users can surely learn a lot from this book as well.  The writing style is quite good, and overall it is an enjoyable read.

Monday, October 20th, 2008

facebook, mysql & memcache

Was scanning through the facebook team’s engineering blog recently.  Although it’s not updated very frequently, there’s some good technical discussion of the engineering behind Facebook, and what it takes to make the site work.

In particular I found this discussion Scaling Out by Jason Sobel.   He talks about the cache coherency challenges they had, and how they used MySQL & memcache to get the job done.

Monday, October 13th, 2008

DBJ: Intro to Oracle’s Automatic Workload Repository (AWR)

If you’re interested in getting started with Oracle’s AWR facility, roughly the new statspack that’s built in, and easier to use, take a look at this new article over at Database Journal.

Intro to Oracle’s Automatic Workload Repository (AWR) 

Thursday, October 9th, 2008

death of the database… again?

For a while the new features in database automation had some DBAs scared that their jobs would somehow become obsolete in short order.

Paul Boutin’s recent article in Valley Wag discusses Robert Cringley’s declaration of the Death of the Database  that has everyone all excited.  At root is the idea of cloud computing, and the likes of the Google’s of the world storing all of our data, and managing all the dirty messy database storage seemlessly for us.

Yes, I’ll give you that for many applications, and small websites, this will certainly be the future.  Who wants to manage a database for every website.  But for the large clients of Oracle databases, the terrabyte datastores, datawarehouses, Oracle applications, and Financials, the backend datastore will remain a requirement.  This isn’t necessarily because a third party can’t do the job better, or that it wouldn’t make a business sleep better at night leaving the database management to the experts.   Nor is it that security couldn’t be implemented properly, to make the data available only to the business, and invisible to the prying eyes of the DBAs down the line.  No all of those problems are solvable.

The problem is one of handing over the keys to the kingdom.  Take the worldwide GPS system, for example.   Currently Europeans, Russians, and Chinese alike rely on a US built satellite system for GPS service.  Imagine military operations relying on US technology were the US to get into a scuffle with the Russians or the Chinese.  In the end business wants to see their data, if not physically, then confident of where those servers are, and who touches the data, the hardware, the backups etc.

I do agree with Cringley and Boutin that cloud computing will change things, and continue to put pressure on the big database vendors like Oracle, but I don’t think it’ll put them out of business anytime soon.

Monday, October 6th, 2008

Open Insights 48 - Balancing Time & Money

In this month’s newsletter Open Insights 48 - Balancing Time & Money, we talk about the important and delicate balancing act of using your time wisely.  One simple equation to evaluate a project, or use of your time can sometimes shed a lot of light on how much effort and energy you may want to put in that direction.

Wednesday, October 1st, 2008