Hi All,
I have a mysql cluster setup with 2 nodes. I would like to log all
updates for a certain, only updates, not inserts, is it possible?
would i be able to tell when it was updated and from what IP address the
update came from?
coz i have an issue wherein a certain table is being
Ron
I would like to log all updates for a certain, only updates, not
inserts, is it possible?
Sure. For a review of methods for various kinds of audit trails see
Audit Trails Parts I II at
http://www.artfulsoftware.com/infotree/mysqltips.php.
PB
Ron wrote:
Hi All,
I have a
Hi Peter,
Thanks for your help. I now created a trigger that would do an insert on
another table on what changes has been made to the other table.
another question is, is it possible to get the host from where the
update request came from from the trigger?
Regards
Ron
Peter Brawley