Re:MySQL--Replication - Peer-to-peer based, multi-master rep...
by alfiejohn_ on Tuesday August 02, 2011 @07:36AM
(#2836753)
That isn't a ring topology or based on a timer?
[ Parent
| on HN ]
Re:MySQL--Replication - Peer-to-peer based, multi-master rep...
by jstephens on Tuesday August 02, 2011 @04:42PM
(#2838623)
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...