DBA Lounge

Implementing Exadata: The results are in

Following up on my earlier webinar Implementing Oracle Exadata – Strategies for Success, I’ll be giving another webinar to present the results of the Exadata implementation at LinKShare. I’ll be talking about actual performance results, our zero-downtime go-live, compression experiences, and performance tuning in an Exadata environment.

Chopt Utility

There is a new tool came with Oracle 11g Rel.2 that helps to modify options in installed oracle home (Enabling and Disabling Database Options) It is very simple and straightforward utility that recompiles database kernel with different flags.

Blog-Agnostic Widgets

While there’s a thousand and one different blog engines out there, it’s kinda silly that, for each of them, we re-write almost-identical HTML and Javascript for the different widgets and badges we adorn them with. Wouldn’t be be nice if there was a standard way to write those widgets so that we they could be used and shared across all Perl blog engines? Cue in WWW::Widget, probably the most trivial API ever designed. Written as a Moose Role, it requires from wannabe-widget classes only two things: that they pass all configuration elements at object-creation time, and implement a as_html() method.

Oraenv in 11.2.0.2

Oraenv is great utility that helps to control environment and to avoid exact use of ORACLE_… variables in scripts. With invention of ORACLE_BASE it was enhanced to change the variable and to print the value in the output. More interesting that behaviour of oraenv in 11.2.0.2 has been changed
and now it is able to switch oracle base variables but it does not show oracle home path in the output, only oracle base

No Silver Bullet – Sharding and MongoDB

ourSquare, the location based social network, suffered from extended outage yesterday. They explained the causes in a blog post, which caused much discussion around the web. Here’s the gist of the analysis: FourSquare are using MongoDB, which is a sharded database. Data is split between nodes based on a shard key, usually the User ID or something similar. One of the shards became overly loaded. After failing to resolve the issue in other ways, FourSquare decided to add another shard to share the load. This caused the entire cluster to fail.

Redo Transport Compression

I was co-presenting recently at Sydney Oracle Meetup about Data Guard Compression and in preparation I did
some tests to see how it works for 11.2.0.1 (Linux x86-64). Here are my results.

Catalyst::Plugin::Sitemap

I wrote my very first Catalyst plugin, and it’s going to be something useful for Galuga. As I don’t have a lot of time, I’ll be succint. As you’ve doubtlessly gathered by now, the name of the game is Catalyst::Plugin::Sitemap. It’s on Github, but it’s not CPANized yet. To use it, add the plugin to your Catalyst app main module

Linux, Windows, Virtual Machines and You — DIY VPN Jump Box

Being in the remote administration business is a strange beast and offers lots of challenges, but when you are working for multiple clients sometimes connecting to the servers can be challenging enough. Here’s a little idea that I had this morning that may save someone some grief, so I thought I would jot it down for all to see.

NoSQL Deep Dive – The Missing White Paper

I’m giving a NoSQL overview presentation at MOTS in two days. The conference organizers didn’t ask me for a white paper, so I thought I could get away without writing one. But it turns out that I don’t really feel that I can speak confidently about a topic if I didn’t write the paper. I wonder if other presenters have this addiction too. So I’m posting the paper here for your enjoyment. Feedback is very welcome.

Page 25 of 67« First Page...10...2324252627...30...Last Page »