Tag: DBA Lounge

Cascade Replication and Delayed servers on PostgreSQL 9.2

Postgresql 9.2 will be released with a new replication feature: Cascade Replication. It will improve streaming between wide networks, shortening distances between the servers. For example: a master server in San Francisco, a slave in Chicago and a cascade server…

Read More >

A Few Thoughts on OSCon and the Open Source Community

This past week I attended OSCon, the annual conference for open source’s true believers. And there was a religious fervor in the air, particularly from the point of view of someone more accustomed to Oracle conferences. The companies generating buzz were the small companies built around development of their own open source products. There are a surprising number of them out there, especially relating to multiple forks of a popular product like MySQL or Hadoop.

Read More >

Varys’ Little Birds

One of the great joys of Perl and CPAN is how it allows you to stand on the shoulders of giants. By picking the right tools, applications that are not that trivial can be built in a matter of days, if not hours. The goal of today’s little project is to demonstrate that very thing. Grab a helmet and put your mouth-piece on, for this time I aim to do nothing other than blow your mind to awestruck smithereens.

Read More >

Case Study: DBA Under Pressure for Performance Troubleshooting on Friday 13

On Friday 13 of June 2012, I was an on-call Oracle DBA. I got to work on a high priority client’s request. One of our client’s financial team was executing final steps of a year closing process in their ERP production environment and had a problem. The step that I received a complain about took 2 hours and still didn’t complete.

Read More >

Exploring Configuration Management with Ansible

What is Ansible? Ansible is a configuration management and deployment system, like Puppet, Capistrano, Fabric, and Chef. Its aim is to be radically simple and let you use your existing scripts to help with cluster configuration and software deployment whenever possible….

Read More >

How to Prepare for Oracle Database 11g Certified Master Exam

Since a third person just asked me how to prepare for OCM exam in last 2 days, I decided to make my answer publicly available. I will leave you to discover the formal path yourself and give you a guideline in terms of the how-to and length of the preparation.

Read More >

Building Web Service APIs

A couple of years back, I created WWW::Ohloh::API because it seemed to be a fun thing to do. And trust me, it was. But now, since I’m not using that module personally, I thought it would be a good idea to see if anyone would be willing to co-maintain it. Before I could do that, though, I had to deal with two little problems.

Read More >

Help Wanted – A Proposal

What if we added a new field in the META.json — let’s call it x_help_wanted — that would contains all the different types of help a module maintainer could require? Positions like maintainer, co-maintainer, coder, translator, documentation, and tester. We could even have a Dist::Zilla plugin to populate that field for us.

Read More >

New and Improved: GitStore Now Plays Nice with Others

This is going to be a short one, but I think the changes to GitStore are cool enough to deserve a little blog-squeal.

Read More >

Shaving the White Whale (DBIx::NoSQL + MooseX::Storage)

I played with Mongo and looked at Mongoose, which are nifty, but holy schmolee are Mongo databases huge. And then I re-discovered DBIx::NoSQL, which was pretty much smack what I wanted. But I needed a way to easily serialize my objects for it. So I dragged in MooseX::Storage to the mix. And then I had fun with helper classes and roles to make the interfacing between the two systems as smooth and slick as a buttered piglet.

Read More >
Page 15 of 60« First Page...10...1314151617...20...Last Page »