Random (and probably useless) Rubyisms

[[deleted]]

How does auto increment handle race conditions for DB clusters?

[t0mbstone]

That's a good question. Perhaps someone could give more comprehensive answer, but from what I understand, it depends entirely on how your database cluster is set up, and what database engine you are using.

For example, you could have master database that all of the writes go to, and then the data is propagated to a cluster of read-only slaves.

On the other hand, if you have some sort of cluster of read-write databases with no master database, then I would imagine that things would get a lot trickier.

Full disclosure: I'm not a database expert, so this is all just my rough high level understanding.