How do I manage a single database with multiple web servers?
July 28, 2011 3:41 PM Subscribe
How do I ensure data integrity when using multiple load-balancing servers?
posted by vraxoin to Computers & Internet (5 answers total)
I'm sure this is a simple question for some of you, but this is a new area for me. The basic setup is this: I've got a single database server that's used to create giant lists of emails to be sent out (not spam! I promise!). In order to increase throughput, I intend to create multiple load balance servers on my rackspace cloud. So basically each of these servers will do nothing but query the database and get a bunch of information about what to send, then send it, then report back to the db about what's been sent. The question is this: what's the most effective means for keeping the load balanced servers from stepping on each others' toes, datawise (i.e., how do I stop two servers from accidentally grabbing the same data between the SELECT and UPDATE queries)? I'm sure there's a simple answer to this, but I don't know what it is.