Thread: Techniques for Recognizing DML Effects?

Techniques for Recognizing DML Effects?

From
"Ed L."
Date:
At last glance, some of the current trigger-based asyncronous master-slave
replication tools (dbmirror, rserv, erserver) do not support DML statement
replication.  If certain DML statements are executed on a master, say
CREATE TABLE or DROP COLUMN, adjustments must be made on the slave as well.
A warning of such an occurrence would be useful for an administrator.

Is there a simple means of recognizing when a DML statement has occurred on
a cluster strictly by querying system tables?  Other ideas as to how to
most easily recognize DML changes in an automated fashion, short of
continually grepping server logs?

Ed