4 ms·
"* 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
by xd 15y ago
"* 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-master.html#sysvar_auto_increment_increment http://dev.mysql.com/doc/refman/5.0/en/replication-options-m...
- alfiejohn_ 15y agoThat isn't a ring topology or based on a timer?
- jstephens 15y agoNo. 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...