Hi,
I wonder if there is some easy way to audit old value and new value,
when a user updates his/her row.
I think I need to insert some trigger to do this in each backend
MySQL, in the worst case. When I look at the recovery
log table, it only keeps new values but now old values. Do you think
that there is some tricky way to put old values
in the recovery log?
The recovery log just logs SQL statements that update the database. It
does not record any value.
You can retrieve the value that is updated with a trigger by examining
the tuple before and after. You can eventually log the old value to
another table but in that case the trigger has to be the same on all
backends since this is an internal database mechanism and not something
triggered by Sequoia.
Note that Sequoia cannot schedule trigger execution either so you have
to be careful on how you use them to prevent out of order updates on
different nodes.
Best regards,
Emmanuel
--
Emmanuel Cecchet
FTO @ Frog Thinker
Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: [EMAIL PROTECTED]
Skype: emmanuel_cecchet
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
