Tag: DBA Lounge

MySQL Recipes: Promoting a Slave to Master or Changing Masters

In MySQL–land, failovers for redundancy, disaster recovery, or load balancing are performed by master databases and slave databases, the most popular method using binlog replication. There are a couple more methods of replication which aren’t covered here. Also see the MySQL Replication FAQ. The methods are the same, but the formatting of the procedure(s) are less than ideal.

Read More >

Stability, Agility, Scalability, and Cost: The eBay Example

Anyone interested in the architecture of highly scalable and stable infrastructure will enjoy this Presentation by Randy Shoup and Dan Pritchett of Ebay on how they, in their words, “strike a balance between site stability, feature velocity, performance, and cost.”

Read More >

Oracle 10.2.0.3 patchset is out

My colleague Vamsi Chikkam noticed that the Oracle 10.2.0.3 patchset has been released for Linux and Windows 32-bit. The major bugfixes are the same as my original post with a few additions:

Read More >

“Federated Array of Bricks” – Deja Vu?

StorageMojo keeps producing interesting material. This time it’s about FAB (Federated Array of Bricks). I wonder if this will make the same hype as RAC? Dear Reader, what is your perspective?

Read More >

Oracle Listener Crash in Windows

I faced a problem yesterday. The Oracle listener crashed each time a connection was made. The OS was WINXP SP2. It goes without saying that this was a testing install. The event log showed the following error in SYSTEM log and APPS log. Finally I found the following magic command which fixed the issue after running and restarting the box.

Read More >

Using RMAN Repository for Database Growth Trend

REPORT SCHEMA is quite handy to get growth rate of your database/datafile/tablespace providing RMAN repository is used. I don’t remember what triggered that thought but I see it in my “to blog” list so here it goes.

Read More >

“change tracking state change latch”

In my UKOUG 06 presentation on block change tracking internals I assumed that “change tracking state change latch” is, probably, used by DBWR and CTWR to protect access to a buffer area in shared pool. I wanted to verify it and tried to trace this latch.

Read More >

Which Risks Are You Protected From?

I worked on one site for a while and during 2.5 years it didn’t face a single media corruption of Oracle datafiles. But one day, my fellow DBA (who is usually extremely cautious and reviews his actions at least twice) overwrote a controlfile with some crap. Even the fact that controlfiles were on raw devices didn’t prevent this disaster from happening.

Read More >

A Good DBA’s Peripheral Vision

I believe that a good DBA should have well developed “peripheral vision”. It helps everywhere — troubleshooting production issues or performance problems, database/application design, system architecture, reading documentation, etc. I also notice that a newbie DBA with good peripheral vision catches up much faster than a strictly focused person.

Read More >

MySQL and PostreSQL on Solaris 10

First of all, there is now FREE Solaris 10 media kit available to order by mail if you’re not fancy downloading several GB. By the way, it also includes Sun Studio (anyone using it?). Second, I found a cool article on Solaris BigAdmin portal – Deployment Guide for an Open Source Stack on the Solaris 10 OS also available as PDF.

Read More >
Page 49 of 60« First Page...10...4748495051...60...Last Page »