Log Buffer #231, A Carnival of the Vanities for DBAs

Jul 29, 2011 / By Fahd Mirza

Tags: , , ,

Log Writer is busily and efficiently pumping out innumerable bytes from log buffer to online redo logs, while more and more exciting features are being added to the MySQL and the SQL Server community is getting more vibrant with each passing day, and in all this beautiful frenzy, we manage to catch some elegant blog posts from across all these Log Buffer editions and present you this Log Buffer #231.

Oracle:

Alex Gorbachev, the Oracle ACE Director at Pythian is taking a step back and listing the stakeholders of Oracle Mix Voting.

Randolf Geist is discussing the implications of “cost is time” model for the time estimate of the Cost-Based Optimizer (CBO) in the Oracle 11.2.0.2 patch set.

Jonathan Lewis illuminates the blogosphere with yet another striking post about Real Application Cluster.

Gavin Soorma explains the procedure used to install 10.2.0.5 Grid Control on a Linux operating system (64 bit Red Hat Enterprise Linux Server release 5.6) as well as the steps taken to upgrade the repository database from the default 10.1.0.4 version to 10.2.0.5.

Chris discusses the concept of automated nesting of Application Modules (AMs) when using Bounded Task Flows (BTFs) with a combination of the transactional options Always Begin New Transaction, Always Use Existing Transaction and Use Existing Transaction if possible.

SQL Server:

Matt Wollner shares his presentation at the Atlanta Microsoft BI user group about SSIS Logging and Auditing Framework.

Jason Brimhall is having fun with the activity monitoring and profiler tools.

Ryan Adams is walking through the basic steps to move the MSDTC for a cluster to a new SAN drive.

People often get HA (High Availability) and DR (Disaster Recovery) mixed up. Denny Cherry describes the reasons for this and then explains lucidly.

Mike Walsh shares a life lesson which was taught to him by government agency.

MySQL:

What scales best?  OldSQL, NoSQL, NewSQL? Tony Bain chimes into the interesting constant debate in the world of Big Data.

Multi-master replication between sites is the holy grail of applications ranging from credit card processing to large-scale software-as-a-service (SaaS) operations. Eero Teerikorpi blogs about upcoming webinar in this regard.

Jay Janseen blogs about MySQL MHA HA solution and talks about salient points raised by Yoshinori Matsunobu.

Long awaited InnoDB support for full-text index is available in InnoDB lab release. InnoDB Team post talks about the performance of InnoDB’s full-text support over MyISAM’s full-text support.

Baron Schwartz answers the million dollar question: What’s required to tune MySQL?

3 Responses to “Log Buffer #231, A Carnival of the Vanities for DBAs”

Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>