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.
It is hard to believe that I leave here tomorrow to fly to Denver for RMOUG. I have been very fortunate to get selected give two presentations, one on Data Pump and the other on Oracle Application Server and LDAP. I am really looking forward to catching up with “my mates” in the Oracle community. I will send regular updates when I get to RMOUG.
A company has come up with a vendor-neutral database certification exam. Some are wondering how much use this will be, as it doesn’t go into vendor-specificities. For me, it will be interesting to see if companies value a vendor-neutral database certification as they would a degree. It seems to cover the same topics, at least from my standpoint.
Welcome to the 83rd edition of Log Buffer, the weekly review of database blogs.
Please join me in encouraging Cary Millsap in making regular appearances on his new blog. Cary, my personal story – one of my first and most vivid memories of taking on a DBA role was when my mentor, Guy Arteau, bringing me a copy of your OFA paper with great awe and reverence and suggesting I study it carefully.
As you may or may not know, I have been spending time in the Pythian Office in Sydney, Australia. In this post I share my experiences of what it is like to be from Ottawa, Canada but live and work in Australia (for at least a few weeks).
I’ve recently moved to Ubuntu Linux, and this post describes my attempt to play around with Oracle ASM on Ubuntu. For this demonstration, I used Oracle 184.108.40.206 on Gutsy Gibbon.What I really like about Oracle is that once you’ve done something, you have ten different ways to go. I hope this post will enable you to explore some 11g’s new features on your favorite operating system.
Well, Paul Vallee tagged me, and as I haven’t yet passed my probationary period I should probably answer the call…..Eight things about me that aren’t common knowledge:
n Stuffing Six Million Pages Down Google’s Throat, Tim O’Reilly brings up a point, and some questions. . . just how poorly the big search engines index small sites with large collections of data . . .But it’s worth thinking about absolute (and temporary) limits to the growth of Web 2.0. What constraints do we take for granted? What constraints are invisible to us? Read more.