Posts Categorized: Pythian

Rails and Database Session Variables

Ruby’s ActiveRecord provides a very robust means of manipulating database table structures especially in the context of automated deployments such as Capistrano. When there is a master-slave database configuration, it may not always be prudent to perform DDL statements on the master and let those propagate through to the slave, especially in high-volume sites where…

Oracle Ebusiness Suite 12.2 Online Patching Feature

Oracle hosted a webcast of Sysadmin-oriented Preview of EBS 12.2. It was an enlighting webcast, which gave a very good idea about things coming up in Release 12.2. Today I want to discuss about a prominent feature of the upcoming Oracle E-Business suite Release 12.2, Online patching feature. The screengrab in thiis post of a slide from presentation gives a nice overview of the feature.

Solaris 11 – First Impressions as Storage Server

Since I was using a version of 11 already, an experimental upgrade was not a problem. With the BE (boot environments) feature, one could boot into any version safely. BE is an awesome feature. Need to install a patch? Install into a boot environment – any problems reboot into the old environment. BEs leverage ZFS snapshots to create a clone of your boot disk, install any patches onto it and allow you to switch flawlessly between the two.

PostgreSQL 9.1 Presentation Slides available

Our resident Postgres expert Emanuel spoke at the Libre Software World Conferencelast week about PostgreSQL 9.1, and as the Community Liasion for PalominoDB for a few more days, I am posting the slides so that folks can download them.  They are in PPT format: Enjoy, and remember that all of our presentation slides and…

New England Database Summit

The New England Database Summit is an all day conference-style event where participants from the research community and industry in the New England area can come together to present ideas and discuss their research and experiences working with on data-related problems.  It is an academic conference with applications to real life, and includes any type…

Prep’ing for UKOUG or what

The presentation deadline for UKOUG is 8 days away. I have been madly preparing for 2 presentations, one on my best friend (rman) and the other on my co-best friend (the physical standby). Both of these topics have been perennial favourites for me and many of my attendees. I find with both of these items, there is always something more to learn.

Git::CPAN::Patch now detect repositories

Git::CPAN::Patch could already seed a local repository with the latest distribution of a module, or its whole BackPAN history, or its GitPAN mirror. But with version 0.7.0, it can now go straight for the meat and clone the distribution’s officil git repository, provided that it’s specified in its META.json or META.yml. Please allow me to demonstrate:

Non-deterministic Functions and the Binary Log

I wrote this post because I ran across this issue when debugging why tables with triggers/functions that were not getting replicated to slaves. The problem appears when binlog_format is set up  as STATEMENT. You can check the ‘change log’ checking the following link for more information about default values [1]. If you have non-deterministic functions…

Page 80 of 231« First Page...10...7879808182...90...Last Page »