A short post to draw your attention to this article by Kevin Burton titled “MySQL and the Death of Raid”. Although it’s written from the MySQL point of view, he does bring up some interesting points on the advantages of what he calls a “RAISe” or Redundant Array of Independent Servers” architecture (actually I coined [...]

Ronald Bradford has published the 47th edition of Log Buffer, the weekly review of database blogs, on Technical Notes and Articles of Interest. Get in touch if you’d like to edit and host an edition of Log Buffer on your own blog. The Pythian Group Blog is widely read, so being a part of the [...]

So you have followed the recipes to create a standby database, setup the database to switch logs automatically, and now, as with any good database, the space required to support the application grows and grows and grows. Eventually, using your monitoring software (in my case, Pythian’s avail or dailies), you get an alert suggesting that you [...]

Welcome to the 46th edition of Log Buffer, the weekly review of database blogs. PGCon 2007 has been happening just a few blocks from where I sit, and judging by what the bloggers have to say, organizer Dan Langille has done a great job putting together a very full conference. Let’s start with some blogs [...]

The excellent Doug Burns has published the 45th edition of Log Buffer, the weekly review of database blogs, on Doug’s Oracle Blog. Log Buffer thrives on the contributions of editors such as Doug and all the rest, and its dance-card is currently wide-open. If you’d like to draw some new readers to your blog, try [...]

I just want to raise a warning flag for DBAs using RMAN and flash recovery area in Oracle 10g. An RMAN script is usually something like: backup database plus archivelog

However, the behavior of plus archivelog depends on whether optimization is enabled or disabled in RMAN. The RMAN reference document says that when the plus archivelog [...]

Welcome to the 44th edition of Log Buffer, the weekly compendium of database blogs. This one’s a grab-bag. Let’s start with some Oracle stuff this week. Christian Shay notes that Oracle 10g for Windows Vista, is available for download. That is sure to please Oracle doyen and fervent Vista booster Doug Burns, who also has [...]

This is more of an essay than a blog post, but this subject comes up time and again, and since I tripped across this interesting blog post by Pedro Timóteo about why he has decided not to be a sysadmin any more, I thought now’s as good a time as any to comment on what [...]

Welcome to the 43rd edition of Log Buffer, the weekly review of database blogs. Let’s start with Leon Katsnelson on Database Talk, the first of a series on choosing a free database. He will be writing about SQL Server Express 2005, Oracle Express Edition (XE), MySQL, PostgreSQL, and in this first, DB2 Express-C. That [...]

Woohoo, I finally got a bit of spare time to blog — my first blog post ever! I chose to talk about a technique I used at a client’s site to report the topmost space-wasting objects in an Oracle database. I was looking for a way to detect these objects without having to run some expensive [...]