Tag: DBA Lounge

On the Perils of Importing Remote Tags in Git

One of the things I love about Git is how I can add branches from remote repositories in mine at will without fearing messing up anything. The remote branches will not clash with mine, even if they share the same names, because they are referenced as repository/branch. However, as for anything else, you can still poke yourself in the eye if you try hard enough…

Read More >

IBM Storage Fails Too Often, so Let’s Switch to EMC…NOT!

A couple weeks ago I did a short blog post about SAN storage failures and how people are blinded by all the bells and whistles that are supposed to make storage arrays 100% reliable and failsafe. My conclusion was that there is no way to avoid storage failures, and that a better way is to anticipate those failures and be ready to handle them with minimal service impact.

Read More >

Applying binary logs without adding to the binary log

Applying binary logs to a MySQL instance is not particularly difficult, using the mysqlbinlog command line utility. Turning off binary logging for a session is not difficult, from the MySQL commandline, if you authenticate as a user with the SUPER privilege.sometimes you want to apply binary logs to a MySQL instance, without having those changes applied to the binary logs themselves. One option is to restart the server binary logging disabled, and after the load is finished, restart the server with binary logging re-enabled. This is not always possible nor desirable, so there’s a better way, that works in at least versions 4.1 and up

Read More >

Product management, effective developers, and the future of MySQL

Here’s the future of MySQL, Drizzle, Monty Program, the Percona fork, etc. The best product management strategies… should we be lightweight for the web, plug-in oriented like Drizzle? Should we follow Monty’s giant-killing roadmap? Should we focus on performance-oriented patches? The best product management strategies will win. They can’t win alone. Will they be backed by appropriate investments from effective developers? Effective developers are the ones who convert winning product management strategies into working products. You can’t get there without them and I’ve seen lots of great strategies fail that test (including my own actually). And there can be more than one winner.

Read More >

cpanvote: A Perl Mini-Project

For many, CPAN is a Canadian Prairies-sized field of modules where it’s darn hard to separate the wheat from the chaff. While the CPAN Ratings service is the principal and official way CPAN tries to rank its distributions, for me at least, it doesn’t quite scratch the itch. Consequently, for a while now I’ve been playing with ideas on how the rating could be improved. What I came up with so far is a very minimal system going straight for the goods. And now, since I’ve had a three-day week, I decided to give the idea a try and implement a prototype.

Read More >

How To Learn Oracle (MySQL, SQL Server, Java…)

Today I’ve read the following email on the mailing list of Sydney Oracle Meetup. I thought that this question is asked many times in attempt to find a silver bullet to learning Oracle so I wanted to publish my reply here on the blog, especially, that I’m a firm believer in one silver bullet that exists — there are no silver bullets.

Read More >

DBD::Oracle 1.24 Released

The “Beer” version of DBD::Oracle (1.24) has been released. You can find it at CPAN DBD::Oracle. DBD::Oracle is a Perl module that works with the DBI module to provide access to Oracle databases. It is maintained by me, John Scoles, under the auspices of Pythian as Open Source/Free Software. This is largely a maintenance release that fixes a number of bugs. New stuff includes some more improvements to embedded types from Charles Jardine. Find out more here.

Read More >

Oracle GoldenGate Extract Internals, Part III

This is the third post in Oracle GoldenGate Extract Internals series (links to part I and part II). In this post, we’re going to take a closer look at various queries that the Extract process uses against the database. As before, we will start by examining the strace output.

Read More >

PAUSE Id, Bug Tracking, and Code Repositories

Want to contribute to your favorite CPAN module, or maybe create your own, but don’t have the foggiest idea how to do it? Here’s a few notes, tips, tricks and links that might help you get started.

Read More >

How to Submit a BoF Session for the MySQL Conference

The call for proposals for Birds of a feather sessions closes at 11:59 pm PST on Thursday, February 18th, 2010. Sessions can be added during the conference, but if you submit and your BoF is accepted it will be printed in the schedule.

Read More >
Page 34 of 68« First Page...10...3233343536...40...Last Page »