Posts Categorized: Technical Blog

How to Run a Streaming Backup with innobackupex

On many of our clients, we have a need to run XtraBackup as a regular OS user. Aside from running into the issue where tar4ibd was not provided with Percona’s xtrabackup-1.6.2.tar.gz package, our main issues have been with permissions when attempting a streaming backup. Here is the innobackupex command that works for us.

Incident Notification – Pythian internal – Jul 29th 3PM EDT

We have incident reporting procedures at Pythian. This incident report was sent just recently internally at Pythian. We learned some good lessons from it so I hope it would be useful to the community as well – As part of our incident management process, you will find below a summary of the details from the incident that occurred on July 29th at 3PM EDT. Overview: Pythian employees were de-motivated by the lack of refreshments on Friday afternoon

The DBD-Quest of Unknown Kadath

I already aluded to the fact in a few posts already, but just to make it a wee bit more public: a few weeks ago, someone had a lapse of common sense and knighted me Maintainer of DBD::Oracle. mouahahaha *ahem* I mean, I’m honored to be allowed to at the wheel of what is one of the most venerable battleships of the CPAN armada, and hereby swear to serve her at the best of my abilities.

RMOUG 2011: Pythian Raffle Results

I’m following up on a conference almost half a year later — try to bet that! Actually, this blog post was written more than 3 months ago and was sitting in my drafts waiting the moment I understand why I really wrote it. 3 months later… I still don’t know but I thought I should share it anyway. Maybe I could at least get some comments…

OpenWord Suggest-a-Sessions @ Oracle Mix

There has been quite a bit written about Oracle Mix Voting (let me refer to it as OMV for short) this year and I don’t think I should waste your time restating any of this. What I wanted to do is to take a step back and try to list “stakeholders” of OMV.

Pythian Tools: Method R Profiler, MR Tools & MR Trace

With this blog post I’d like to start sharing a series of posts which I wanted to call “Pythian Recommended Tools”. After some thought, I decided to remove “recommended” Strictly speaking, this blog must have covered bunch of tools in the past but this time I’ll emphasize the tools that I really like and see widely used at Pythian. OK. Introduction is over.

Bandying Tickets from RT to GitHub Issues

As the new maintainer of DBD::Oracle, I’m trying to wrap my head around the 32 tickets currently open against it. Many tickets are platform-dependent, or appear for a specific version of Oracle. It would be fantastic to be able to tag the different tickets with those details, but alas CPAN’s RT doesn’t have tags..Fortunately, with the help of RT::Client::REST and Net::GitHub, it’s quite easy to export our tickets.

Oracle DBA: Do we need REDO statistics in V$SQL ?

Tom Kyte, Cary Millsap, Steven Feuerstein hold a Database Guru Panel at #Kscope 11′s conference organized by ODTUG. I had a great opportunity to not just watch the Live Stream (you can see the recorded version HERE) but also ASK questions..One of the questions was related to UNDO/REDO statistics. I think that it was a bit of challenge to define the question precisely having just 140 Twitter characters and therefore I decided to share my question here, give a bit of background and ask you “What is your opinion?”

Page 31 of 61« First...1020...2930313233...405060...Last »