5 comments

[ 3.2 ms ] story [ 27.9 ms ] thread
"* You can't have multiple masters"

The ability to have multiple masters has been around for some years now: http://dev.mysql.com/doc/refman/5.0/en/replication-options-m...

That isn't a ring topology or based on a timer?
No. Each master has an offset so when you build a ring you give each master a different starting point. This keeps your ids in sync. So master1 would create ids: 1, 11, 21, 31, 41, 51, etc... and master2 would create ids: 2, 12, 22, 32, 42, 52, etc...
Older submission and discussion:

http://news.ycombinator.com/item?id=2766857

It was announced there would be a video soon but I was not able to find it.

The video can be found at:

  http://www.youtube.com/watch?v=lk-2XE00fqY
And the Q&A after the talk is at:

  http://www.youtube.com/watch?v=oDcsM8n72OU
Funny that they both managed to be close to 15 minutes on the dot and I didn't use any timers :)