Log Buffer #189, A Carnival of the Vanities for DBAs
Welcome to the 189th Edition of Log Buffer. If a tree falls in a forest and there is nobody there to hear it, does it make a noise? If Oracle releases a new patch set and no blogger takes notice, did it really happen? Oracle released the long anticipated 10.2.0.5 patch set for Oracle Database on April 29 and Pythian’s French connection Grégory Guillou noticed immediately. Want to read blogs in other languages? Switch to Google Reader and change the translation setting to “Translate into my language.” Here are some international Oracle employee bloggers that you could follow for starters. It’s A Small World After All.
Rolando Carrasco & Juan Camilo Ruiz (in Spanish)
Lucio Fernandez H (in Spanish)
Fernando Garcia (in Spanish)
Francisco Munoz Alvarez in Spanish)
Leonardo Horikian (in Spanish)
Bernard Fischer-Wasels (in German)
Carsten Czarski (in German)
Uwe Küchler (in German)
Massimo Ruocchio (in Italian)
Lajos Sárecz (in Hungarian)
Andrei Pivovarov (in Russian)
Naoki Sato (in Japanese)
Hiroyuki Yoshino (in Japanese)
In Switzerland, Christian Antognini pored over the 10.2.0.5 liner notes and discovered that it comes with a native implementation of FULL OUTER JOIN that does not require an inefficient UNION operation. Is that one more reason to stick with Oracle Database 10g?
Back in Virginia, Tom Kyte was reminiscencing about ten years of Ask Tom. The first question ever asked on Ask Tom was about disaster recovery for Oracle Database 7.3 on SunOS 5.5.1. The last time the discussion was updated was just three months ago—disaster recovery is always a hot topic.
Master story-teller and long-time performance expert Cary Millsap will have you chuckling with his story about a stripe painter for the highway department who painted a stripe seven miles long on the first day, five miles on the second day, two miles on the third day, and one mile on the fourth day.
MySQL anyone? According to the Independent Oracle Users Group, 44% of its 20,000 members use MySQL in addition to Oracle. The MySQL camp is quite pleased with the welcome mat put out by the Independent Oracle Users Group and the Oracle Database Tools Users Group. Guiseppe Maxima is not suggesting any rushed moves by either side and suggests that “Some preliminary courtship and information gathering must precede more serious commitments. But both sides can start thinking about the advantages that one group’s exposure to the other can bring along. There is business to be done on both sides of the ditch, as many Oracle users are also MySQL users. There is going to be need for training, consulting, conference talks, integration, migration, and much more may come to mind after some pondering.”
Ronald Bradford and Paul McCullagh join Sheeri Cabral as MySQL ACE directors. Ronald has two decades of relational database experience including ten years with MySQL. He was the 2009 MySQL Community Member of the Year and is the co-author of the recently published Expert PHP and MySQL. Paul is the developer of the PrimeBase XT (PBXT) transactional storage engine for MySQL with full MVCC (multi-version concurrency control) support. For his work on the engine, Paul was nominated 2007 MySQL Community Code Contributor of the Year.
In other news this week, Sheeri Cabral and Chen Shapira both took part in the Battle Against Any Guess. Sheeri advised her listeners to “NEVER take any advice that tells you what to do or how to do it without understanding WHY.” Chen railed against the ingrained belief that “every question has a single solution and one that is so obvious that once you see it, you recognize its rightness in less than 30 seconds.”
Guiseppe Maxima has some performance tips for MySQL 5.1 partitions. The price is always right where MySQL is concerned!
Paul Randall listed his pet peeves about SQL Server and then tagged five of his friends. It should be an interesting discussion.
PostgreSQL core team member Peter Eisentraut dissected the “upsert” operation and implemented the syntax into the PostgreSQL parser on a short flight home!
And, in a blast from the past, Kenny Gorman came across an article that he wrote eight years ago for the May 2002 issue of the NoCOUG Journal about using OS snapshots for backups. The original article discussed only Oracle but Kenny shows how to use the same technique for PostgreSQL and MongoDB. The NoCOUG Journal is still going strong BTW; the May 2010 issue can be downloaded from the NoCOUG website.