Welcome the the 85th edition of Log Buffer, the weekly review of database blogs. Here we go!
Recreating the Voting disk may not be as easy as written in Metalink. If you work with RAC, you know about Metalink Note 399482.1 : “How to recreate OCR/Voting disk accidentally deleted”. Of course, you back up the voting disk every time you change your RAC configuration, or on a regular basis. You probably played with the procedure and it worked just fine. Like you, I did all of that. Yesterday, I had to recreate this precious file when it was lost a couple of hours after the whole software stack had been installed. It was, I guess, just before we would have setup our monitoring on the server that would have backed up the voting disk. Here’s how you can fix this problem
The time is flying here and two days of RMOUG Training Days 2008 have gone. In a nutshell, what a great conference! Well done RMOUG and special thanks to Peggy King! It was very nice to see a bunch of old friends and meet new ones in person including Jeremiah Wilton and Tim Gorman. The highlight of the day was controversial presentation by Moans No Balls Longgood about the current state of database performance tuning. For a full rundown of the last day keep reading.
It’s the 84th blog-tacular edition of Log Buffer, the weekly review of database blogs!
Today was a mini-Pythian day at RMOUG. Both Alex and myself gave two presentations each. My first session was on using LDAP with Oracle Applications. George Trujillo was presenting on MySQL for the Oracle DBA in the same room, so I stayed and learned a few things. I was lucky enough ( a little tongue in check there!!) to present the last session of the day on Oracle 11g DataPump.
Do I really need to say more?
I had a great time at RMOUG today. I attended a lot of great sessions, even though I was a little late getting there this morning. I particularly enjoyed Daniel Liu’s 11g New Features for DBAs presentation. Read my post for more highlights.
‘m in Denver now and it’s RMOUG Training Days time! The University Sessions were running yesterday and the conference itself starts today. I have heard a lot of good things about RMOUG and the conference is considered one of the best Oracle events in North America. I will be able to confirm it during the next two days but I have no doubt that it’s true. Keep an eye out for my RMOUG updates.
Someone asked me what applications were good/bad for MySQL Cluster. As I’ve now actually had experience with a Cluster setup and a real-life application of it, and dug through the manual, I present a few characteristics of applications that will work with Cluster, and why they are so. if you have an application that meets some of the characteristics you can decide whether it’s worth it to use Cluster or not.
The database schema really should be source controlled in the same place as the application code, because otherwise how do you know what changes happened when, and which version of the code goes with which version of the schema. The problem I have is this — being a purist (and by the way, *not* a programmer so there could very well be concepts I’m missing), I really want to source control the DDL/GRANT statements and whatever that are applied to the production database, because that way anyone can see exactly what was run, and I can do a schema backup and compare to the source controlled version.