In an Oracle database, database replication is the process of duplicating objects and moving them out to multiple databases so users have continuous access to shared data even in the event of a disaster.
Read More

New clustering system promises fully synchronous replication for MySQL databases.
Read More

New clustering system promises fully synchronous replication for MySQL databases.
Read More

Rob Gravelle lists his top 10 MySQL best practices for database administrators, architects, developers, and security personnel.
Read More

Discover the wealth of I/O performance tuning information that Oracle 11gR2’s Automatic Workload Repository (AWR) reports provide, and learn how to use that information to determine if any I/O performance bottlenecks actually exist, and how to form initial hypotheses to resolve those bottlenecks within the database’s underlying input/output (I/O) subsystem.
Read More

Become complacent at your job and your job could be at risk. These days, an Oracle DBA needs to be adept in one or more areas of advanced database administration. Steve Callan discusses the top 5 skill areas for the advanced DBA.
Read More

In the Web 2.0 world where smart phone and Web applications are competing to access terabytes of data, there is a new imperative for speeding up retrieval times as much as the technology permits. Rob Gravelle lists a few coding techniques that we as database administrators and developers can use to whittle down unwieldy results sets into manageable chunks.
Read More

The MySQL Binary Log files are important to the proper functioning of the database and facilitate replication, and recovery. This article discusses some of the inner workings of these important files, and explains how ordering of transactions also plays into how they work.
Read More

Can an IBM DB2 DBA learn Oracle? Follow one DB2 DBA as she prepares to take the Oracle Certified Associate Examination.
Read More

Table partitioning is an option available to DBAs that can help them manage key database performance areas including i/o balancing, contention reduction, SQL statement performance improvements and even data availability. Oracle Database 11g adds some very powerful new table partitioning methods that can be implemented to help to achieve some of these goals.
Read More