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 …

On Monday, October 12, 2009* from 7-9 pm at MIT, I will be giving a presentation explaining SHOW ENGINE INNODB STATUS for the Boston MySQL User Group. There is information about foreign keys, transactions, deadlocks and mutexes just waiting to be discovered, and I will show how to decipher the information.

For all those in the Boston area, I hope to see you there! For those who cannot be there, we will video this presentation and make it available online, and post here when the video/slides are up.

*Yes, I realize that this is a bank holiday in the US.

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.

…

On the 23rd of June 2008, I wrote a note saying that I had just joined Pythian. Today I am posting a similar, but different, note saying that as of the last of September, I will no longer be employed by Pythian, the time has come to look for new challenges. Although I am sad to leave, I do look forward to the future and what it may hold for me.

I wanted to take this moment to thank Pythian for having me, for having such great co-workers whom I count myself lucky to have worked with. I also want to give a special thanks to Augusto for taking care of me when I first joined, and showing me around how the company works. I must thank Paul as well—he is an exceptional person to work with, and I’ve come to value his …

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 …