<p>You need some way to take out an atomic lock... or, use a message queue.</p>
<p>E.g., one system processes the new things and inserts their data into a message queue, and you can then have N workers (where "N" is "as many as needed on average) to pop things off the queue and send mails based on the content of the message.</p>
<p>--<br>
Sent from my Ice Cream Sandwich!</p>
<div class="gmail_quote">On Feb 18, 2012 3:00 PM, "Chris Fowler" <<a href="mailto:cfowler@outpostsentinel.com">cfowler@outpostsentinel.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
On Sat, 2012-02-18 at 09:22 -0500, Mike Harrison wrote:<br>
> In reality, it looks like we'll just have to configure a cluster<br>
> and do some experiments. I know we'll have to code around some<br>
> potential<br>
> issues with unique keys.. and figure out other management issues.<br>
><br>
> Like any complex system, the answers get more specific the more<br>
> complex the scenerio is.<br>
><br>
><br>
<br>
Well then experiment with me. I've been wanting to do this, but I need<br>
to rework the applications so that I don't have them doing all the same<br>
thing.<br>
<br>
I have one application that looks for new rows in table A and then sends<br>
out email. If I have a cluster of these servers. each running that app,<br>
how do I keep them each from sending out the same email?<br>
<br>
My issues are more application issues than getting clustering to work.<br>
I'm sure I can do master-master replication. I need to get the programs<br>
to behave.<br>
<br>
Chris<br>
<br>
<br>
_______________________________________________<br>
Ale mailing list<br>
<a href="mailto:Ale@ale.org">Ale@ale.org</a><br>
<a href="http://mail.ale.org/mailman/listinfo/ale" target="_blank">http://mail.ale.org/mailman/listinfo/ale</a><br>
See JOBS, ANNOUNCE and SCHOOLS lists at<br>
<a href="http://mail.ale.org/mailman/listinfo" target="_blank">http://mail.ale.org/mailman/listinfo</a><br>
</blockquote></div>