ALL POSTS

On Disaster Recovery and my SQL Rally 2011 Presentation

I was reading my session evaluation results and came accross comment that said: “copy and paste coder.” I’ve been doing this specific presentation for almost 5 years now with a few tweaks every once in a while based on feedback. Yes, I live and breathe disaster recovery as part of my day-to-day job. However, there are several reasons why I do not type nor write code during my presentations. Here are a few of them.

Log Buffer #225, A Carnival of the Vanities for DBAs

March of bloggers goes on and so is the unstoppable production of the blog posts. It’s getting more exciting week after week watching the new and old bloggers adding spice to the database blogosphere. This edition of Log Buffer brings some of the simmering and scintillating posts from around the globe in Log Buffer #225.

Silent MyISAM Table Definition Changes and mysqldump

While trying to move a schema from one MySQL server to another, I encountered a very odd issue. The schema to be moved contained both MyISAM and InnoDB tables, so the only option I had was to dump the schema using mysqldump on the source server and import it on the destination server. I did some digging and found that the problem was that the MyISAM engine silently changed the table definition without any indications. Here are some solutions.

Using a Custom Timezone? Beware Oracle 11.2.0.2 Grid Infrastructure!

We have a client that runs an application that, for whatever reasons, does NOT like daylight saving time. For that reason, the Oracle server is kept in Eastern Standard Time and does not change with the rest of the eastern United States when DST begins and ends every year. They accomplish this with a custom /etc/localtime file. However, they left /etc/sysconfig/clock set to “TZ=America/New_York,” which would prove fateful as I shall point out.

5 Days Left – Vote for Pythian Sessions at Oracle OpenWorld 2011 on Oracle Mix

Summer’s here, and that means it’s time to start thinking about Oracle OpenWorld 2011. Pythian’s plans are well underway. We have been busily planning since March, have submitted a number of abstracts on all sorts of topics: Exadata, ASM, GoldenGate, ADR, ASM, many based on real world experiences with Pythian clients. Some have been accepted, but we’re hoping for a few more and we’re asking Pythian fans to vote for our sessions on Oracle Mix.

How to Confirm DIRECT IO is Getting Used on Solaris

I was working on a task where I had to confirm if the direct IO is in use or not. filesystem_io_option database parameter was set to “DIRECTIO” to make use of directio. Initially I was looking for same kind of memory structures in Solaris but could not find so ( bad luck :( ) and so used basic tracing using truss.First I logged into database and check the filesystem parameter ( Changed the name of the database and host :) )

Page 90 of 252« First...102030...8889909192...100110120...Last »