Log Buffer #211, A Carnival of the Vanities for DBAs
Welcome to Log Buffer, the weekly news update of happenings in the database world. This is Iggy Fernandez, your guest host this week.
In the beginning were books on database technology. Then Al Gore invented the internet and a million blogs sparkled into life. Previous generations of database professionals read books in order to gain that certain edge but the modern database professional reads blogs instead. Books are mammoth undertakings, they don’t have a long shelf-life, and there is no living in them. Blogs rule.
Kevin Closson broke the news of the amazing new snapshot capability of Oracle RMAN backups on his blog last week. Previously, cloning a database meant moving a massive mountain of data from point A to point B. Now an RMAN backup can function as a “writable snapshot” of your database. If you need to modify a block of the snapshot, a copy of the block is simply written to a changed block file. The possibilities are mind-boggling. “Part I (and a half)” of Kevin’s research is now available. Check his blog every week for more on this breaking story. Kevin reports that he has operated 64 clones of a database using this method. Legions of Oracle Database administrators without access to hardware-based snapshot functionality will take notice.
Are physical database installations yesterday’s technology? In other breaking news heard around the Oracle world, Surachart Opun and others excitedly draw attention to the release of Oracle VM VirtualBox 4.0. However, Wim Coekarts cautiously raises awareness about licensing issues surrounding Oracle VM VirtualBox.
In the alerts and alarms department, Laurent Schneider warns us that communication between 10g Oracle Management Service and AIX Management Agents may break tomorrow because of a certificate that expires on December 31.
On the lighter side, the AMIS Technology blog delves into urgent matters such as “which letters do not occur in the names of the employees”, “in which months of the year was no one hired,” “who in each department does not have a colleague with less experience (or a lower salary),” “which employees do not have a colleague in the same job (either in their own department or in the entire company),” and more.
In the DB2 arena, the DB2Night Show has listed the top ten episodes of 2010 including The Top 10 DB2 LUW Mistakes People Make and Adam Gartenberg brings attention to the IBM Information Champion awards.
In the open source ring, Mark Callaghan writes about performance monitoring in MySQL, Andrew Morgan links to an upcoming webinar on managing and monitoring MySQL Cluster, and three worlds collide in String Aggregation in PostgreSQL, SQL Server, and MySQL in Postgres OnLine Journal.
This is the last Log Buffer of 2010. God bless us every one, in 2011.