tracing table updates

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 updated but i could
not tell where or when. thanks in advanced.

Regards,
Ron

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: tracing table updates

--------------000109010100070207000103
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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 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 updated but i
> could not tell where or when. thanks in advanced.
>
> Regards,
> Ron
>
> ------------------------------------------------------------ ------------
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.5.392 / Virus Database: 270.13.34/2268 - Release Date: 07/28/09 06:00:00
>
>

--------------000109010100070207000103--

Re: tracing table updates

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 wrote:
> 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 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 updated but i
>> could not tell where or when. thanks in advanced.
>>
>> Regards,
>> Ron
>>
>> ------------------------------------------------------------ ------------
>>
>>
>> No virus found in this incoming message.
>> Checked by AVG - www.avg.com
>> Version: 8.5.392 / Virus Database: 270.13.34/2268 - Release Date: 07/28/09 06:00:00
>>
>>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org