On Apr 30, 2012, at 08:03 25, Wayne Merricks wrote: > Multi-master inserts can be quite simple but get very complicated very > quickly the more nodes you have.
Nothing about data sharding is simple. :) > I haven't looked into the DB side of Riv in detail to figure out if the > auto number field is critical to any part of it though. It's used heavily throughout RD. With a few exceptions, the primary key for every table is an auto_increment INT. > As you can have > a situation where Server B not being used very often is sitting at auto > number position 4 while Server A has already gone up to 213. Which is why we'll need a clustering daemon to mediate access to the MySQL instances. With master-master replication, the auto numbers do tend to converge quickly, but the potential for nasty races still exists when concurrent writes to the same table on different nodes are permitted. Cheers! |-------------------------------------------------------------------------| | Frederick F. Gleason, Jr. | Chief Developer | | | Paravel Systems | |-------------------------------------------------------------------------| | "No, `Eureka!' is Greek for `This bath is too hot!'" | | -- Dr. Who | |-------------------------------------------------------------------------| _______________________________________________ Rivendell-dev mailing list [email protected] http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
