On Thu, 2005-09-29 at 09:30 -0400, [EMAIL PROTECTED] wrote:
> The key here is > that you are making multiple changes from app1 that really should be > within a transaction. The entire process of writing sales data and > unsetting a flag from app1 needs to be transacted. That way the other > server (app2) will either have consistent data or will never find out that > anything was going on in the first place. > Many thanks Shawn, I few changes needed to the app but i'll give it a go. Regards tony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]