This is the 168th edition of Log Buffer, the weekly review of database blogs. Let’s give the wheel a spin and see who comes first . . . 

MySQL

Brian “Krow” Aker has something to say about Drizzle, InfiniDB, and column-oriented storage: “I have been asked a number of times ‘do you think there is a need for a column oriented database in the open source world?’ The answer has been yes!  . . .  I was very happy to see Calpont do their release of Infinidb last week.”

Vadim of the MySQL Performance Blog said, “As Calpont announced availability of InfiniDB I …

Welcome to the 167th edition of Log Buffer, the weekly review of database blogs.

Since all that OOW news forced Gerry to give them short shrift last week, let’s begin with blogs on . . . 

SQL Server

Jeremiah Peschka gets our week going with his refresher introduction to SQL Server system databases.

Likewise, Pinal Dave reviews the difference between candidate keys and primary key.

…

This week the Log Buffer is a little more challenging for two reasons: a) Oracle Open World 2009 and b) the controversy around Monty Widenius‘ opposition to Oracle owning MySQL due to the Sun acquisition, so let’s go straight to the articles.

Oracle – Oracle Open World 2009

There is so much material about OOW09, that I’m giving a full subtitle to it.

Let’s start with a quick recap of the keynotes by Scott McNealy and Larry Elison in this article by Andrew Clarke: The return of The Scott And Larry Show. The recap suggests that the presentations aimed to show how …

I regret to say, there is no Log Buffer this week, as we’ve all been busy preparing for the Big New Thing coming in a few days. The good news is, we have a Big New Thing coming in a few days. Stay tuned for that, you won’t want to miss it.

LB will be back in a week, with Gerry Narvaja at the helm. In the meantime, I invite you to leave a comment with your favourite DB blogs from this week — MySQL, Oracle, Microsoft SQL Server, DB2, Postgres, Ingres, or other relational/NoSQL databases.

Welcome to the 165th edition of Log Buffer, the weekly review of database blogs.

Since they haven’t had any Log Buffer love for a couple weeks, let’s start this one with . . . 

PostgreSQL

Selena Marie Deckelmann was tending the garden and found a Snow Leopard amongst the Macintoshes. The result, her post Snow Leopard and PostgreSQL: installation help links.

Josh Berkus posts a poll on encrypted backup. he writes, …

Welcome to the 164th edition of Log Buffer, the weekly review of database blogs.

SQL Server

We have a delicious assortment of technical posts from the SQL Server world this week.

Piotr Rodak writes, “While I always knew and imagined that ON DELETE CASCADE may be useful, I wondered, what scenarios would be suitable for ON UPDATE CASCADE. I still don’t have this answer, but I came across some interesting behavior which kept me occupied for quite a bit more time that I had intended to.”

On In Recovery…, Paul S. Randall pursued the answers to …

Welcome, readers, to the 163rd edition of Log Buffer, the weekly review of database blogs, your sieve

Oracle

First, the ghastly news—Tom Kyte said “I’m not a DBA anymore.” Say it ain’t so, Tom! “After nine years and nine months of running the database that hosts asktom, I’ve retired . . . not from answering questions, but rather from being the DBA and semi-SA for the machine that was asktom.oracle.com.” Okay, so he said it ain’t so.

Meanwhile, Tom’s Oak Table colleague, Jonathan Lewis, played no head games on us, but he has been at the hash …

Welcome to the 162nd edition of Log Buffer, the weekly review of database blogs.

Oracle

The big news this week came was Oracle’s unveiling the OLTP Oracle Database Machine & Exadata v2, as reported by Alex Gorbachev.

Kevin Closson covered it, of course: Oracle Drops Exadata In Favor of Sun FlashFire Based OLTP Database Machine?, and he and his readers kick it around in a diverting way.

…

Welcome to the 161st edition of Log Buffer, the weekly review of database blogs … and the first one under my penmanship.

MySQL

Johan Andersson explains in a very simple way the scenarios in which you may fall into a split brain situation and how to avoid it in MySQL Cluster on two hosts – options and implications. An article worth reading from one of the MySQL Cluster experts.

I love simple scripts that solve complex problems. I love it even more when the command line can be defined in an alias, and SQL from SQL offers some …

Welcome to the 160th edition of Log Buffer, the weekly review of database blogs.

MySQL

Blame it on MyISAM, says Mark Callaghan of High Availability MySQL, on considering sql_mode and type coercion. “I think that MyISAM has its place,” writes Mark. “It does fast table scans, but InnoDB is much faster on just about everything else. I am just not thrilled with the impact it has had on MySQL.”

Not that those other engines are without flaw. Peter Zaitsev reports on an InnoDB performance gotcha with larger queries.

Here on the …