Tag: DBA Lounge

MacGyvering a Remote Disk Usage Utility

For each of my machines I have one backup directory per week of the year (01, 02, 03, etc) and — and this is the über-cool part of it — rsync’s ‘–link-dest’ is used to hard-link files that didn’t change since the previous backup run. This means that I can have weekly snapshots of all my machines at the fraction of the space a full backup would take. Very nice. files have a nasty habit to fill up all available disk space. In my case, the 100% mark was hit last week. Obviously, I had to delete stuff. But… which stuff? Here is a way to get a snapshot of the disk usage locally, and in a format that would allow you to navigate and examine it at will.

Read More >

Installing TOra with Oracle Support on Ubuntu 10.10

I installed this on Kubuntu 10.10 x86_64 systems with the newest Oracle 11.2 client. The version of TOra this time around is 2.1.2 which works fine except for one really really frustrating thing, that I will mention at the end to keep you in suspense. I ran through this 3 times on 3 separate systems (VM, work and home) and in all cases I got through it mostly unharmed with only a few humps. So here we go, it’s time to…

Read More >

The DBA and the Trigger

Anyone can fall into this scenario. Everyone is carefully taking time to test before applying a couple patches to address an async I/O issue in Oracle to ensure all testing environments are exact, all patching is approved by everyone that would like to review it. No one is willing to pull this trigger and apply the patches until they are absolutely sure they have every SQL statement, every network tweak, every application scenario looked over and over again. Suddenly, the database reaches what every DBA dreads…

Read More >

Guerilla Perl Installations

App::perlbrew is a tool that simplifies down to triviality the process of making local perl installations. With it, any user can, in the span of a few minutes, have a working perl that is totally independant of whatever the system has. This is a win for you — you’re now in control of your perl, and of your destiny — as well as for the sysadmin, who is now free of the prickly choice between system integrity and users’ happiness. The path to self-sufficient brewing is incredibly easy. First, you have to download and install perlbrew

Read More >

Managing Production Systems: Document, test, verify, try again.

A couple of days ago I was reading a paper Paxos Made Live – An Engineering Perspective written by Google engineers. It is an interesting reading about implementation of Paxos algorithm for building a fault-tolerant database. But one paragraph made me think I am reading something very familiar…

Read More >

Oracle Database Consolidation – What’s Your Story?

I’m working on a small story about database consolidation and interested to learn what are success and failures that others are going through. While we have our own experience at Pythian, I find it interesting to learn about what others are going through. If you have enough details, it would be nice to see your feedback along these lines…

Read More >

Push… a Little More Than I Ever Wanted

Knowing how failible my memory is, I looked for some automated safety net to use with Git. The most obvious would have been to use a push hook, but alas Git has no such thing, and if the latest thread I caught on the topic still hold, one isn’t going to appear anytime soon. Since that venue is (for now) closed, I turned to plan B: crafting a new git command, git-safepush:

Read More >

Oracle DBA & DEV: MERRY CHRISTMAS!

Just to make you smile and let you remember all those sweet holidays I would like to congratulate you and wish you MERRY CHRISTMAS! in Oracle style:

Read More >

Having Fun with Logging and I18N

I must confess, that game I’m leasurely working on is nothing but a big fat excuse to dabble with fun bits of technology that I don’t get to touch with my usual projects. And in that optic, yesterday I fooled around with logging and internationalization stuff…. Yes, I know. I’m using a game as a pretext to work on logging and I18N. I’m ashamed of myself. But aaanyway, let’s see what I got to discover.

Read More >

Pod::Manual

Pod::Manual was born a little bit more than three years ago, and kind of lingered in alpha-land ever since. But now, I had the opportunity to return to the project and do terrible things to it. The code is even more alpha than it was before, and it’s now in a post-hack shamble, but at least it has been moosified and (or so I hope) pushed in the right direction.

Read More >
Page 24 of 68« First Page...10...2223242526...30...Last Page »