DBA Tools

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