DBA Tools

Critical bug fix for asyncdata data migration script

    After several times under production environments (with thousands of concurrent connections), I did hit some critical bugs for this script. For example, lot's of unique constraint errors, it's hard to explain the reason here. I just want to...

Posted on September 14, 2007 11:17 PM

How Perl or asyncdata connect to different databases

    Perl is very popular programming language for DBA scripts and tools, following are the code of how to connect to different database with DBI. There is something special for the DBD-Sybase driver. DBI->connect('DBI:Oracle:tnsname', $user, $pass); DBI->connect('DBI:mysql:database=;host=;port=', $user, $pass);...

Posted on September 14, 2007 2:20 PM

Implement materialized view log on MySQL for asyncdata

    Of cause, MySQL does not have materialized view log now as Oracle has. But we can implement the same feature with a log table and a trigger, since MySQL version 5 does support the trigger. In MySQL we...

Posted on September 11, 2007 5:30 PM

Using trigger for asyncdata log table in Oracle database

    Oracle materialized view log is good for capture the DML change, however it's not flexible, for example, the table must have a physical primary key defined for asyncdata, and you have no wait to skip the change capture...

Posted on September 11, 2007 12:15 PM

Tuning the performance of data replication with asyncdata

    Performance is critical for OLTP system, asyncdata should have good performance for the data replication, else it may not be able to catch up with the source table. Following is the key points to get the best performance....

Posted on September 10, 2007 10:53 PM

Migrate data between different databases with asyncdata script

    Migrate data may be a regular job for a DBA, sometime from this Oracle server to another Oracle server, and sometime migrate from Oracle to MySQL or other database, or other database to Oracle. With good utility it...

Posted on September 10, 2007 8:55 PM