Do you need to know why the standby periodically lags during the day, if the standby redo apply rate lag during the day and when, or how fast is the current archived redo log being applied? If you answered yes to any of these look no further. The following SQL script will help you answer these questions.
It is indeed a different world here. I have a feeling I’ll like it even more over the next three months I am here on Pythian duties. I will be writing more, so stay tuned.
At the risk of making it seem like this is all we’re talking about here at Pythian, here we go again. Paul Vallee pointed me towards this article by John Dvorak that more or less echoes a blog post I wrote in French the day previous for my personal blog that you can read here. So, first things first, Dvorak’s article leads me to think my theory is indeed wrong: if Dvorak says I’m right ; I’m afraid I’m wrong.
The 80th edition of Log Buffer has been published by Gwen Shapira on her blog, I’m just a simple DBA on a complex production system.
Play or download the podcast interview with Brian Aker of MySQL here. A special thank you to our sponsor, The Pythian Group, www.pythian.com.
I’m sorry that I haven’t commented on the BEA acquisition. It’s just been too obvious for too long, I can’t get excited even though it’s really really big. Manifest destiny manifested, that’s it. On the other hand…Tip of the hat to Lucas Jellema at AMIS who posts his own commentary on the acquisition and also provides this great find where Springsource CEO Rod Johnson comments at length on the deal.
t 2 pm EST (-5 GMT), OurSQL will be interviewing Brian Aker, MySQL’s Director of Architecture, about today’s announcement that Sun Microsystems bought MySQL. If you have a burning question (about the purchase), please comment here. If you’d like to be identified, please leave your name and where you’re from in your comment
The only criticism of the SUN/MySQL deal I could possibly give is that MySQL is still on the early phase of an exponential adoption curve and I think they’ve got lots of growth yet to come. But really, a billion dollars has a lot, if not most, of that growth factored into the price already. Think of what they get, huge mindshare in a 30,000 person company with an established presence and sales channel throughout the world. They get that mindshare because that same company is one that has struggled to find the next big thing, the next huge thing that is going to change the landscape of enterprise IT. Well they’ve found it. And they’re going to get to work on making it happen.
SUN Microsystems just bought MySQL. I don’t know much about SUN internals, but I’m not sure how the company resolves being the primary developer of 2 differing DBMS’s. Since those are the top 2 open source DBMS’s (and there aren’t really any other ones out there, as I don’t count sqlite as a DBMS), there could be a real conflict of interest.
The latest release of DBD::Oracle is now ready and can be found at: CPAN DBD::Oracle. It is a Perl module that works with the DBI module to provide access to Oracle databases. It is maintained by me, John Scoles as open source/free software, under the auspices of The Pythian Group.
The release has been fully tested with the latest version of DBI (1.601). A list of the changes and/or fixes in this release are included.