Welcome to the 103rd edition of Log Buffer, the weekly review of database blogs.
As an editor, I cringe at the title of this post. However, it is absolutely accurate. Recently, we had a situation where we had two servers running Sun Solaris 10 on some high-end Sun hardware. The two servers are configured in a master-master circular replication setup. Here is the problem. On both servers, the error logs were being created incorrectly. On one of them, it was creating an error log that was 154 megabytes in size.Â FLUSH LOGS worked, but the newly-created error log would be the same size. While there was some data in the file that I could use the cat, head or string command to discern, the majority of the file was not text data. If anyone has any thoughts or a similar experience, I would love to hear from you!
Small local user group meetings have their own beauty because of the special intimate atmosphere. We expected somewhat higher attendance but it seems that people were already in the holiday mode. The presentation itself went very well and I liked my pace since I didn’t have any time pressure. I’ve done this presentation before in 45 minutes and this time it took slightly more than an hour but I was able to spend additional time on few more complex topics and explain the underlying concepts making sure we all are on the same page. I also enjoyed the questions during the presentation — always a pleasure to know which parts are more interesting to the audience and questions is one of the best indicators. Another one is when people take notes. All in all — it was a very encouraging hour. Thanks to every one who attended!
Today I’m doing a presentation at the Toronto Oracle User Group meeting. It’ll be my first time there and I’m really looking forward to it. My session is called Oracle 11g New Features Out of the Box. It went pretty well at Collaborate 08 and I think it will be the right audience at the TOUG meeting.
In case you are attending Oracle Open World 2008, the biggest Oracle conference in the world, and interested in either (or both) MySQL or Oracle Enterprise Manager Extensibility — I posted a proposal for a new presentation: Extending Oracle Enterprise Manager by Example — Creating MySQL Management Plug-In
This fifth post assumes that you want to add a new node to your cluster and database. It describes most of the associated “silent” syntaxes. Even if you don’t leverage RAC’s ability to add or remove nodes to gain in agility, it’s still very likely you’ll come to these techniques when you want to upgrade some of your Servers or Operating Systems.
Usenix 2008 – Automated System Management, by Ã†leen Frisch of Exponential Consulting
From 7:30 – 8:30 pm tonight, Wed. June 25th, in the Berkeley room of the Sheraton Boston, I will be hosting a Birds of a Feather conversation entitled “Pros and Cons of Managed Services”. This will go beyond MySQL and even beyond remote database management, and just deal with the overall pros and cons. Come, share your good and bad experiences, and discuss why managed services may or may not be appropriate for your situation. I will try to take notes at the BoF.
I have *never* had this happen to me. Maybe it’s because it’s MySQL 6.0.4, maybe it’s because it’s on Windows, or perhaps I am just up working too late. I have seen mojibake before, but usually it is unintelligible. But this? After I post this I am backing away slowly from my computer. Has your data ever smiled at you?
This fourth post introduces the fundamental silent installation commands for a 10.2 RAC. this post will dig into how to (1) install the 10.2 Clusterware, (2) apply the latest Patch Set on top of it, (3) install the 10.2 database, (4) apply the latest Patch Set on top of it, and (5) create a RAC database. These operations will be performed with the Oracle Universal Installer, NETCA and DBCA in silent mode. Before you start, just in case you’re not familiar yet with Oracle Silent Installation.