On Thu, 2005-09-29 at 16:15 +0100, Nuno Pereira wrote:
> [EMAIL PROTECTED] wrote:
>
> This one is interesting in terms of concurrency...
>
> Is the app2 the one responsable for setting the flag? I supose that it is.
> If that happens it's important that app2 doesn't mess with the flag, i
> mean, it may lead to problems if app2 sees that app1 writes the sales
> data, app2 sees it, starts reading it, app1 writes more data and app2
> sets the flag without seeing that app1 have written more data, and sets
> the flag without reading the new one.
>
> Make this work without problems can be tricky, and I don't see a good
> solution to this in five minutes. When app2 reads data what app does
> with it? How app2 sees what was the last data she read?
>
> --
> Nuno Pereira
>
I don't think there is any concurency problem:
App 2 sets the flag and then polls for it to be unset, it is unset by
app 1 when it has written all of the sales data. meanwhile app 2 is
polling for the flag to be unset again and does nothing until it is, if
app 1 dies before unsetting the flag app then app 2 will sit in a loop
forever.
when the flag is unset, app 2 reads it, process it and posts it to a
website via xmlrpc
app 2 site in a shell script while loop: (pseudocide)
while (1){
start app 2
sleep (60)
}
so there can never be more than one instance of app 2 running.
tony
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]